What are level based measures (metrics)?
Level-based metrics means, having a measure pinned at a certain
level of the dimension. For Example, 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)
· 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.
· You can compare monthly sales with quarterly sales. You can
compare customer orders this quarter to orders this year
Thank you for sharing this Useful Information !!
ReplyDeleteLINUX INTERVIEW QUESTIONS
Linux FTP vsftpd Interview Questions
SSH Interview Questions
Apache Interview Questions
Nagios Interview questions
IPTABLES Interview Questions
Ldap Server Interview Questions
LVM Interview questions
Sendmail Server Interview Questions
Read more at Linux Troubleshooting
Hi There,
ReplyDeleteThanks for highlighting this and indicating about Oracle Business Intelligence where more study and thought is necessary.
New-ish to Linux. I have a few questions but it's best if I dedicate each question to a single thread.
What is the difference? Which is better: more stable, more supported, etc.?
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Grazie,
Abhiram