Rams - Business Intelligence & Data Warehousing
Labels
SQL
SSIS
SSRS
MDX
Sharepoint
DWConcepts
Design Document
Dynamic Calendar Control
PPS
QlikView
Rank
SQL Script
Sharepoint Requirement
Wednesday, June 30, 2010
Ratio for the Dimension (MDX code)
Ratio for the Dimension
[Work Cost %]
[Measures].[Work Cost] / (
Root
([Task]), [Measures].[Work Cost] )* 100
[Leavetype ratio]
[Measures].[Leave Count] / (
Root
([Leave Type]), [Measures].[Leave Count] )
Newer Post
Older Post
Home