The Analytics system is only available to administrators (Phase 1). 
 

A screenshot of a computer 
Description automatically generated with medium confidence 

 

This Report builder has the following features: 
 
A close-up of a screen 
Description automatically generated 

 

Analytics Cubes: A set of data to report againstWhen a cube is selectedyou have the ability to select more cubes, however the remaining cube options will be filtered to remove cubes that cannot be related to the one you initially selected.   
 
DimensionsReport Columns. All Dimension names are pre-pended with their source cube name. The order of dimensions/columns selected will create a “left join” ordering in the report query.  To elaborate: 

Example: Select an Item dimension. Then select a User dimension. The report will generate with all data for Items but will only include User data that has a relevant Item. If there is User data without Items associated, that User data will not appear. If this relationship is reversed (User data first, then Item data), then you will see all Users in the system, and Items will only display if related to a User. 
 
*NEW* Report criteria rows can now be re-ordered by grabbing the triple line/handle symbol 
A screenshot of a computer 
Description automatically generated 

 

MeasuresAggregation or Count of rows. Example: You can determine the number of times an Attribute has been used by selecting Attributes and then Item cubes. Then add “Count of Items” as the Measure. See screenshot below. 
 
A screenshot of a computer 
Description automatically generated with medium confidence 

 

SegmentsCommonly used Filters that have been turned into shortcuts called Segments. If there is a filter you use often, please inform the development team and we can create a Segment. 
 

Filters: Similar to the existing Reporting system. You may create AND or OR filter groups for complex filtration rules against dimensions. 
 

Time dimensions: If you have selected a Cube with a time dimension, you can filter your results by a fixed date range or a relative date range. Relative date ranges are expressions such as: “10 days ago, last year, last month, last quarter, 10 business days ago”, etc. 

Order: Specify column ordering manually or simply click on a column header in the report and it will automatically create an Ordering rule.