Hello. Just finished moving the site to a new hosting. Still in testing. Please let me know if you find something wrong with it. Thank you for your patience.
There’re many interesting things happening in Oracle BI World and I can’t wait to write about those.
OBIEE blog changed hosting.
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: