MS SQL Server OLAP - Re: MDX query to show FY2004, FY2005, ... FY~n on columns and distinct set of months (Jan...Dec) on

Home > Archive > MS SQL Server OLAP > January 2006 > Re: MDX query to show FY2004, FY2005, ... FY~n on columns and distinct set of months (Jan...Dec) on

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: MDX query to show FY2004, FY2005, ... FY~n on columns and distinct set of months (Jan...Dec) on

Deepak Puri

2006-01-26, 8:23 pm

In the case of AS 2000, you could create appropriate Member Properties
at the Month level; then add a Month virtual dimension, based on these
properties. Such a new virtual dimension would permit year vs month
analysis.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links

Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com