What is level based metrics?
- 1 Answers
- 2293 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 authentication? How many types of authentication.
Can you use physical join in BMM layer?
How many bi services node can be clustered together?
How will you go about adding additional column to the repository in the presentation layer?
Can you bypass siebel analytics server security ?if so how?
What are different types of variables?
How will you do different types of narrative reports in obiee?
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?
How do you define the relationship between facts and dimensions in BMM layer?
What is complex join, and where it is used?
What are the different log files in obiee?
What is connection pool and how many connection pools did you have in your last project?
Teradata 
