Interested to Buy Any Domain ? << Click Here >> for more details...
What is level based metrics?
- 1 Answers
- 3133 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 will you do different types of narrative reports in obiee?
What are the key configuration files in obiee?
How do i disable cache for only 2 particular tables?
How will you create interactive dashboards ?
How will you enable or disable caching in the system level and table level?
What are different types of joins that are possible in obiee rpd?
How the users created differs from rpd/answers/dashboards level?
What is level based metrics.how will you create it?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How will you create report from two subject areas
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?
You worked on standalone or integrated system?
Teradata 
