Skip to main content

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 activated

Group dimension​

Holds group information.

  • Group_name - group name.
  • Group_source - source of the group (License output / LDAP).
  • Group_valid - is group set as activated.

User dimension​

Holds information related to users, such as - Full user name, department, office, address and so on.

  • 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 activated.

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. Use this measure to summarize different features and license servers.

  • Idle_time - idle time cut by days.

Daily measures​

Daily concurrent measure​

Holds daily maximum concurrent usage. Use this measure 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. Use this measure 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 for 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.
Last updated on by Maria Gilca