If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Aggregating measure based on values of another measure - MDX

Started by eliza_jane, 27 Aug 2013 06:42:39 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

eliza_jane

27 Aug 2013 06:42:39 AM
The requirement is to display say Sales where the difference between Order Date and Ship Date is < 90 days. Both Order Date and Ship Date are dimensions with Sales Fact table.

How do I aggregate the Sales measure only for those records where the date diff is < 90 days?

This is against DMR using MDX.
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite