Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 36 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 274 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 101 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Measure with total number of records for any query in repository OBIEE 12.2.1.4
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
-
And how about a COUNT and using content levels to tell OBIEE at what levels of your hierarchies it has to work?
0 -
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
0
