Intellicus Enterprise Reporting and Business Insights 19.1

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 “Hyperlinks” section under Common Help section to know more about hyperlinking.

When designing analytical object, you can specify filter parameters for the hyperlinked High Speed report in Hyperlink Options window. These report parameter options should contain all the levels of each dimension present in the selected report. These selected report parameters are passed as filter values to the linked report.

hyperlink
If you have more than 1 dimension in Row measure, then all subsequent field values are passed as filters along with the hyperlinked field value.
hyperlink1

Note: 

1.The name of the Parameter Object should be same as the field name, if default parameter values need to be passed in the link
2.Instead of default parameter value, if you want to pass a selected field value then the dimension field name is passed in the linked URL
3.If both default field value and dimension field value are specified, only dimension field value is passed as filter in the link
4.For linking a dashboard, you need to pass the dashboard id with the required parameters in the URL, example:
./dashboard/DashBoardViewer.jsp?DASHBOARD_ID=3C429A8C-183D-261A-D26F-F20C45EEA3D2:Insured.Country=<%Country%>:prmCustomer=<%prmCustomer%>
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.