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

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

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

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

Tim Ellison

2006-01-26, 4:58 pm

Hi all. I'm trying to show a distinct list of months on the rows and
calculated measures for fiscal year on the columns, but I end up with
duplicate names for the months on the rows.

Fiscal year totals are calculated measures.

What is the best way in MDX to accomplish the "Unique Month Name on Rows"
trick?

Thanks.

Tim

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