Skip to content

Instantly share code, notes, and snippets.

@buggtb

buggtb/gist:6b45ae32a062a283940d20a0521e7433

Created April 18, 2016 09:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save buggtb/6b45ae32a062a283940d20a0521e7433 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save buggtb/6b45ae32a062a283940d20a0521e7433 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
WITH
SET [~ROWS] AS
Hierarchize({{[Time].[Years].Members}, {[Time].[Quarters].Members}, {[Time].[Months].Members}})
SELECT
NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [SteelWheelsSales]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment