Intellicus Enterprise Reporting and Business Insights 19.0

Hierarchy/Level/Attribute Properties

0 views June 28, 2020 0

The following table lists the properties of hierarchy/level/attribute in an Analytical Object.

Item Property Values Comments
Hierarchy Name Type yourself You can see the name for this Hierarchy on the High Speed View and reports.
‘All’ member caption Type yourself Caption to be displayed on High Speed View to show the summarized value.
Field Select from list Value of the field in case of a Time type dimension.
Calendar Select from list In case of a Time type dimension, for the chosen date field you can select Calendar as ‘None’ to specify Year-Quarter-Month-Day as YQMD, YQM, YQD, etc. under Levels. In case of ‘Standard’ Calendar, along with the levels you can specify the Start and End Dates.

You can also customize the Standard Calendar according to your business needs. For example, an organization may be using a twelve-month Gregorian calendar starting on January 1 and ending on December 31st. However, some organizations may want to use a fiscal calendar that defines the fiscal year used by the organization.

Levels Select from list Choose from YQMD, YQM, YQD, and so on.
Date Start Date

 

 

 

End Date

Specify the first date, month or year in fact table. You can also specify a fixed start date from calendar

Specify the last date, month or year in fact table. You can also specify a fixed end date from calendar

Level Name Type yourself You can see the name for this Level on the High Speed View and reports.
Field Select from list Value of the field in case of a Regular type dimension.
Display Field Select from list Display name of the field in case of a Regular type dimension.
Data Type Read only Data type of the field in case of a Regular type dimension.
Secure Using Parameter Select from list You can choose from the secured parameters to restrict user to view cube data.
Hyperlink Select the option In case of a hyperlinked field (specified at the analytical object level), you can drill down to open another report or URL on clicking the value of field. Refer “Working with Hyperlinks” under Common Help section to know more about hyperlinking.
Level Format Select from list If you have specified levels for a TIME type dimension, you can choose a Level Format to display a particular year, month, quarter or day.
Attribute Name Type yourself You can see the name for this Level on the High Speed View and reports.
Field Select from list Value of the field in case of a Regular type dimension.
Display Field Select from list Display name of the field in case of a Regular type dimension.
Data Type Read only Data type of the selected attribute
Secure Using Parameter Select from list You can choose from the secured parameters to restrict user to view cube data.