Bind Dashboard Items to Data in OLAP Mode

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.6 u5 > Dashboards and Reports Customization Guide > Designing Dashboards > Bind Dashboard Items to Data 

Bind Dashboard Items to Data in OLAP Mode

In OLAP mode, the cube schema is fetched automatically, and the Data Sources page of the dashboard menu displays the entire OLAP cube structure.

 

wdddatasourcespageola

To visualize data, open the dashboard item's Bindings menu, click a placeholder and choose the required measure, attribute or hierarchy in the invoked list of data source's available fields, as described in the Bind Dashboard Items to Data topic. Note that OLAP measures can only be placed in the Values section, while dimension attributes and hierarchies can be placed within other data sections.

 

papercliper

Note:

By default, the dashboard displays only dimension values that have intersections with measures in a cube. To show all available dimension values, add hidden measures to the dashboard item so that all dimension values of the dimension will have not be empty for at least one measure value of these measures.

 

OLAP hierarchies allow you to customize each of their levels separately. Select the desired level in the dashboard item's Bindings menu to invoke the data item menu to access hierarchy level options.

 

wddolapdatahierarchy

 

papercliper

Note:

You can easily drill down through OLAP hierarchies using the Drill-Down feature.