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 level based metrics.how will you create it?
Have you created hierarchy in obiee. If so where and how?
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?
What are the challenges you faced while making of reports?
What are global filter and how they differ from column filter?
What is write-back in obiee ?
How to hide certain columns from a user?
How will you create interactive dashboards ?
can you change the location of the obiee repository?
How will change port of obiee answers?
What are the key configuration files in obiee?
How online/offline mode impact development and delpoyment?
What is a bridge table ?
What is time series wizard? When and how do you use it?
