Dimensions
Calendar Dimension:
Holds time and date fields:
- Date – full date in date format (format by year, quarter, month, day, free form)
- Date_string – date in string format (example “09-01-2017”)
- Date_string_long – named date as string (example “Jan 9th 2017”)
- Is_weekend – is the date a part of the weekend
- Is_holiday – is the date a part of a holiday
- Week_yyyyww – week of the year (YYYY-01 to YYYY-51).
- Day_of_month – day of the month (1 – 31).
- Day_of_week – day of the week (Sunday to Saturday).
- Day_of_year – day of the year (1 – 365)
- Month – month of the year (January – December)
License Dimension:
Holds fields with information related to licenses.
- License_server – license server
- License_vendor – vendor
- License_feature – feature
- License_description – product name
- License_type – license type
- License_version – version
- License_additional_key – additional key
- License_expiration_date – Expiration date of the license (Blank means ongoing)
Package Dimension:
Holds license package information.
- Package_vendor – Vendor name of the package
- Package_feature – Package feature name
- Package_description – Package descriptive name
- Package_versions – Package version
- Package_is_fixed – Package set as fixed
Project Dimension:
Holds project information.
- Project_allocated_time – Time from start of project
- Project_create_date – Project creation date
- Project_end_time – Project expiration time
- Project_name – Project name
- Project_percent_done – How much of the project is done.
- Project_priority – Project priority
- Project_source – Where was the project loaded from
- Project_start_time – Project starting time
- Project_valid – is project enabled
Group Dimension:
Holds group information.
- Group_name – group name.
- Group_source – source of the group (License output / LDAP).
- Group_valid – is group set as enabled.
User Dimension:
Holds information related to users, such as – Full user name, department, office, address etc..
- User_name – user name.
- User_first_name – user first name.
- User_last_name – user last name.
- User_display_name – selected display name for user.
- User_title – job title.
- User_department – organizational department.
- User_phone_number – user phone number.
- User_description – user description.
- User_office – user office.
- User_email – user email.
- User_source – source of the user (License output / LDAP).
- User_valid – is user set as enabled.
Workstation Dimension:
Holds all workstations.
- Workstation – workstation hostname
Raw Measures
Raw Usage Measure:
Holds total session duration, without any aggregation.
- Usage_time – total session duration (do not query by time)
- Num_of_licenses_used – number of licenses pulled on a single session (tokens)
- Borrowed – was a license borrowed for this session.
Raw Denials Measure:
Holds denials, without any aggregation.
- Count(denial_id) – count of denials.
- Major_error – denial major error code
- Minor_error – denial minor error code
- Hour_of_day – denial hour of day (only for using on denials)
- Error_message – detailed error message for the denial.
Raw Idle Time Measure:
Holds total idle time periods, without any aggregation.
- Idle_time – idle time periods
Calculated Measures
Feature Usage Measure:
Holds daily usage time and concurrent usage. (features with one version only)
- Usage_time – session duration cut by days.
- Concurrent_usage – concurrent usage (per single feature selected).
- Num_of_licenses_used – number of licenses pulled on a single session (tokens)
- Borrowed – was a license borrowed for this session.
Feature Idle Time Measure:
Holds daily idle time periods that allows you to summarize different features and license servers.
- Idle_time – idle time cut by days.
Daily Measures
Daily Concurrent Measure:
Holds daily maximum concurrent usage that allows you to summarize different features and license servers. (features with one version only)
- Max_concurrent_usage – daily maximum concurrent usage.
Daily Concurrent Measure All Versions:
Holds daily maximum concurrent usage that allows you to summarize different features and license servers. (features with several versions)
Acts as the “Select All Versions” in EasyAdmin.
- Max_concurrent_usage_all_versions – daily maximum concurrent usage for features with more than one version.
Daily Quantity Measure:
Holds daily maximum license quantity that allows you to get accurate daily license quantity information
- Max_license_quantity – Daily license quantity per license.
Unused Tables
These tables are auxiliary tables for the usage of the ETL only, and should not be used in any report.
- Version_Table table – Holds the ETL version and last ETL run time.
- Quantity_Dimension table – Holds all license procurements, but is not structured to be in a report, only to assist the ETL.
- Unfinished_Sessions_Aux – Holds all the ID’s for unfinished sessions.
