What is level based metrics?
- 1 Answers
- 2591 Views
- I also Faced
- E-Mail Answers
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 |
What is a bridge table ?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
Define pipeline. Did you use it in your projects?
How to hide certain columns from a user?
Can you bypass siebel analytics server security ?if so how?
What are the key configuration files in obiee?
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?
What is connection pool and how many connection pools did you have in your last project?
What you will do when your report is not fetching right data?
How do implement event polling table?
Can you have multiple data sources in OBIEE?
What is a table alias in obiee 11g? Where and how will you create it?
Teradata 
