Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How will you create report from two subject areas
What is a table alias in obiee? And 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?
How to enable drills in a given column data?
What are the different types of variables in obiee? Explain
What are the challenges you faced while making of reports?
How will you port changes for dashboards,reports,rpd from development to production?
How will you go about adding additional column to the repository in the presentation layer?
How will you execute direct sql in obiee?
What is authentication? How many types of authentication.
What is write-back in obiee ?
can you change the location of the obiee repository?
How to startup obiee in linux?
What is level based metrics.how will you create it?
What is a bridge table ?
