We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
Answer / madhu
No, it is not mandatory to define hierarchies to other Dimension tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is star schema and snowflake schema?
What is scd type 1 and 2.
How online/offline mode impact development and delpoyment?
What are the different types of security you have worked in obiee?
How to startup obiee in linux?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is complex join, and where it is used?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How many bi services node can be clustered together?
What is object level security?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How do you know which report is hitting which table, either the fact table or the aggregate table?