This report shows the relationships between cube measure groups and OLAP dimensions in the metadata as a matrix.
Objects Included
The following WhereScape RED object types are included in this report:
- OLAP Dimensions
- OLAP Measure Groups
Parameters
There are no parameters for this report.
Results
The results of this report are displayed as a list of refreshed objects in the metadata repository with the following columns:
- Dimensions (the dimension name)
- Measure Group 1
- Measure Group 2
- ...
- Measure Group n
The cells in the cross tab have a value to indicate the relationship else 'No Relationship' if no relationship exists between the Measure Group and the OLAP Dimension. The result set is not sortable.
Report Example
Sending Results to Microsoft Excel
Right-click the result set and click Output to File to send the results of this report to Microsoft Excel.