Data structure

Download the Reporting Hub Data Structure video

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.