Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
44
Views
2
Comments
Abed Jaji
Abed Jaji Rank 1 - Community Starter

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.

Tagged:

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    SonPat99 Rank 6 - Analytics Lead

    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.