Interested to Buy Any Domain ? << Click Here >> for more details...
What is level based metrics?
- 1 Answers
- 3119 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 |
How to startup obiee in linux?
Define repository in terms of OBIEE?
How will change port of obiee answers?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is a table alias in obiee 11g? Where and 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?
What are the major challenges you faced while creating the rpd?
What is authentication? How many types of authentication.
How will you create interactive dashboards ?
What is data level security?
How do you know which report is hitting which table, either the fact table or the aggregate table?
Can you use physical join in BMM layer?
Teradata 
