What Is Level Based Metrics.how Will You Create It?

1.	What Is Level Based Metrics.how Will You Create It?
Answer» Leval-base matrics MEANS, having a measure pinned at a certain level of the dimension. Monthly Total Sales or Quarterly Sales are the examples. To create a level based measure, create a NEW logical column based on the ORIGINAL measure (like Sales 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 Month in TIME Dimension. Leval-base matrics means, having a measure pinned at a certain level of the dimension. Monthly Total Sales or Quarterly Sales are the examples. To create a level based measure, create a new logical column based on the original measure (like Sales 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 Month in Time Dimension.

Answer»

Leval-base matrics MEANS, having a measure pinned at a certain level of the dimension. Monthly Total Sales or Quarterly Sales are the examples.

To create a level based measure, create a NEW logical column based on the ORIGINAL measure (like Sales 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 Month in TIME Dimension.

Leval-base matrics means, having a measure pinned at a certain level of the dimension. Monthly Total Sales or Quarterly Sales are the examples.

To create a level based measure, create a new logical column based on the original measure (like Sales 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 Month in Time Dimension.

Discussion

No Comment Found

Related InterviewSolutions

Have You Ever Tried With Denormalized Database To Build Reports? If Yes, How To Handle?
What Is Level Based Metrics.how Will You Create It?
What Are The Minimum Services Needed To Load A Repository File Onto Memory And View A Dashboard Which Has Reports That Have Been Refreshed On A Scheduled Basis?
What Kind Of Joins Would You Perform In The Physical Layer Of The Repository File When Opened With Administration Tool?
Can You Change The Location Of Your Rpd File In Your Obiee Configuration? If Yes, Where Would You Mention The New Location Of This Rpd File For Bi Server?
What’s Xmla And Where Is It Used For In Obiee Context?
What Is The Default Location Of A Repository File?
Why Obiee Security Is Different Compared To Other Bi Tools?
What Kind Of Privileges Can Be Granted From Presentation Services Level?
Does Obiee Have Two Layers Of Security?