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

Question

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?

deniska · Answer

Would you explain how to...

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

Detail tables

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

Dim Tables

* Period (period_id(PK),period_name)
* 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

* Count distinct(id_main). This measure has 3 logical source - from each detail table
* 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

Gianni Ceresa · Answer

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