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 Posted / madhu
No, it is not mandatory to define hierarchies to other Dimension tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What is authentication? How many types of authentication.
How online/offline mode impact development and delpoyment?
How will you port changes for dashboards,reports,rpd from development to production?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What is clusterservices in obiee ? Why its used?
What is time series wizard? When and how do you use it?
What are the major challenges you faced while creating the rpd?
How to get sql from obiee for reports?
How will you execute direct sql in obiee?
What is level based metrics.how will you create it?
Have you created hierarchy in obiee. If so where and how?
What is scd type 1 and 2.
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is star schema and snowflake schema?