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

Abed Jaji

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.

Joel

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.

SonPat99

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.