What is level based metrics?
Answer / madhu
Level based metrics means, having a measure pinned at a certain level of the dimension.
A LBM is a metric that is defined for a specific level or intersection of levels.
Monthly Total Sales or Quarterly Sales are the examples.
Ex: if you have a measure called “Dollars”, you can create a “Level Based Measure” called “Yearly Dollars” which is Dollars for a Year. This measure will always return the value for the year even if you drill down to a lower level like quarter, month, etc. To create a level based measure, create a new logical column based on the original measure (like Dollars in the example above). Drag and drop the new logical column to the appropriate level in the Dimension hierarchy in the above example you will drag and drop it to Year in Time Dim.
Is This Answer Correct ? | 0 Yes | 0 No |
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?
What are the different layers of obiee repository?
What are the things you can do in the BMM layer?
How will you do different types of narrative reports in obiee?
What is level based metrics.how will you create it?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
Why do we have multiple LTS in BMM layer? What is the purpose?
What are global filter and how they differ from column filter?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How will you do sort in reports in obiee.
What is object level security?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?