Categories
- All Categories
- 146 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
How to apply sum on columns from dimension table in RPD?

I have two tables in each of the three layers in RPD: table A (fact) and table B (Dim) joined by line_id. They are setup as separate logical table source. There is couple of fields from table B (dim) that I want to apply sum on in the rpd in other words I want to define them as measures. How do I achieve this correctly in the RPD? This is needed in OBIEE 12c.
Answers
-
You’ll have to add the “dimension“ table as a logical table source in your logical fact and then add the “measure” columns into the logical fact.
0 -
Hello Abed,
You will have to drag and drop the columns from DIM B which are required to be defined as "measure" in the FACT A in BMM layer.
Once done, define your new columns as measures by applying appropriate aggregation rule.
The same Fact A and DIM B from BMM should be exposed in Presentation Layer. If you have already exposed Fact A and DIM B, please delete them and re-expose these in Presentation Layer.
0