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
What is a bridge table ?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How the users created differs from rpd/answers/dashboards level?
What is authentication? How many types of authentication.
How analytics process your request when you create your requests?
What is a table alias in obiee 11g? Where and how will you create it?
From where u get the logical query of your request?
How to hide certain columns from a user?
What is star schema and snowflake schema?
How will you do sort in reports in obiee.
Have you created hierarchy in obiee. If so where and how?
What is clusterservices in obiee ? Why its used?
What is time series wizard? When and how do you use it?
What you will do when your report is not fetching right data?
How will you enable or disable caching in the system level and table level?
