How to apply sum on columns from dimension table in RPD?

Question

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.

SonPat99 · Answer

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.

Joel Acha · Answer

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.