Interested to Buy Any Domain ? << Click Here >> for more details...
What is level based metrics?
- 1 Answers
- 3041 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 query repository tool?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
What is clusterservices in obiee ? Why its used?
How to sort columns in rpd and web?
If you want to limit the users by the certain region to access only certain data, what would you do?
What is object level security?
How will you port changes for dashboards,reports,rpd from development to production?
How do implement event polling table?
What is time series wizard? When and how do you use it?
How will change port of obiee answers?
Do you know about Initialization Blocks? Can you give me an example where you used them?
What are different types of joins that are possible in obiee rpd?
Teradata 
