Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Measure with total number of records for any query in repository OBIEE 12.2.1.4

Received Response
13
Views
2
Comments
deniska
deniska Rank 5 - Community Champion
edited Aug 13, 2024 5:14PM in Oracle Analytics Cloud and Server

Is there any way to create in repository measure with function like this one?

MAX(RSUM(1) BY 1)

It works great in answers but produces an error when we create measure with it.

OBIEE Error[14041] Nested Aggregation measure are currently not supported

Probably there are any functions we can use for this purpose in Repo?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    And how about a COUNT and using content levels to tell OBIEE at what levels of your hierarchies it has to work?

  • deniska
    deniska Rank 5 - Community Champion

    Would you explain how to...

    For example(very simple) I have three detail tables(degenerate dims) and two dimension tables

    Detail tables

    1. Main_data (id_main(PK) , period_id , attr_main1...attr_mainN)
    2. Document_data (id_doc(PK), id_main(FK), period_id, attr_doc1...attr_docN)
    3. Goods_data (id_good(PK), id_main(FK), period_id, product_id, cost, attr_good1...attr_goodN)

    Dim Tables

    1. Period (period_id(PK),period_name)
    2. Product(product_id(PK), product_name)

    So In Business Layer we have

    5 Logical tables - Main_data, Document_data, Goods_data, Period, Product.

    1 Measure table - Measures()

    Each logical table has dimension

    Measures table contains 2 measures

    1. Count distinct(id_main). This measure has 3 logical source - from each detail table
    2. sum(cost) - from Goods_data



    So the question is

    Count of What should I add to measures in this model and which logical level set to each dimension

    to get record count of any query in Answers

    Thanks