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] )

Posted by Ram at 11:16 AM
Labels: MDX
Newer Post Older Post Home

About Me

My photo
Ram
View my complete profile

Search This Blog

Popular Posts

  • How to run SSIS 2012 package in SQL2008 environment?
  • DimDate Table Script
  • How to use TransactionOption in SSIS
  • SSIS IncrementLoad using Conditional Split Transformation
  • Top 10 New features in SSIS 2012
  • SQL Server 2012 New Features
  • How to use RunningValue() in SSRS
  • SSIS 2012 not working with temp tables
  • How to work on Role Playing Dimension in QlikView
  • How to create Checkpoint in SSIS

BICOLLECTION

  • Design Document (1)
  • DWConcepts (1)
  • Dynamic Calendar Control (1)
  • MDX (7)
  • PPS (1)
  • QlikView (1)
  • Rank (1)
  • Sharepoint (3)
  • Sharepoint Requirement (1)
  • SQL (45)
  • SQL Script (1)
  • SSIS (15)
  • SSRS (8)
Simple theme. Theme images by luoman. Powered by Blogger.