Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is level based metrics?



What is level based metrics?..

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

Post New Answer

More OBIEE Interview Questions

How do you work in a multi user environment? What are the steps?

1 Answers  


How to startup obiee in linux?

0 Answers  


How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

0 Answers  


What is authentication? How many types of authentication.

0 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


Can you run multiple rpd’s in a single obiee instance?

0 Answers  


What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  


What is clusterservices in obiee ? Why its used?

0 Answers  


If you want to limit the users by the certain region to access only certain data, what would you do?

1 Answers  


What is star schema and snowflake schema?

0 Answers  


What is logging level? Where can you set logging levels?

1 Answers  


What you will do when your report is not fetching right data?

0 Answers  


Categories