OpenLM Reporting Hub Data Structure


 

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.

 

What are your feelings
Skip to content