How to create a measure from data that is stored in a dimension table.
Sometimes, we need to define an Aggregated Measure based on a Dimension Table.
If aggregated calculations are performed directly from a dimension logical table field, an error similar to the following will appear:
A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: ). Please fix the metadata consistency warnings.
To resolve this type of error, put the measure indicated by the error message in a fact table object.
To define an aggregated measure of a dimension table, complete the following steps:
- Create a new fact logical table with the physical dimension table as source.
- Include all fields that should be aggregated as a measure of this new fact object.
In the Siebel Analytics version 7.5.3 repository, a good example is the Fact – Campaign Metrics fact table that is based on the W_PRG_CAMP_D physical table: