Interested to Buy Any Domain ? << Click Here >> for more details...
What is level based metrics?
- 1 Answers
- 3121 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 |
If you want to create new logical column where will you create (in repository or dashboard) why?
Can you bypass siebel analytics server security ?if so how?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is the end to end life cycle of OBIEE?
What is scd type 1 and 2.
How online/offline mode impact development and delpoyment?
How to enable drills in a given column data?
Explain the architecture of obiee and what each components do?
What is level based metrics?
What is connection pool and how many connection pools did you have in your last project?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
Teradata 
