• subscribe
May 22, 2002 12:00 AM

June 2002 MDX Puzzle

SQL Server Pro
InstantDoc ID #24918

One of the most common measurements of group or individual performance in a consulting agency is utilization. Decision makers in consulting groups calculate utilization by dividing the total number of hours billed by the total number of business hours available (e.g., 8 hours for each business day). Having a high percentage of utilization is good because it means you're effectively deploying available resources to generate revenue. Use the cube structure that Figure 1 in the main article shows to create the MDX for a measure that calculates utilization for a selected employee and time period.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here