Skip to content

Instantly share code, notes, and snippets.

@fernandojunior

fernandojunior/gist:2718ab5e3bfb515d3625

Created January 20, 2015 00:59
Show Gist options
  • Save fernandojunior/2718ab5e3bfb515d3625 to your computer and use it in GitHub Desktop.
Save fernandojunior/2718ab5e3bfb515d3625 to your computer and use it in GitHub Desktop.
Download ZIP
Exemplo de analise MDX entre duas datas
Raw
gistfile1.sql
WITH Member
[Measures].[Volume Venda (Anterior)] as
Sum({[Data].[2014].[January].[1] : [Data].[2014].[January].[19]} , [Measures].[VLATEND])
Member [Measures].[Volume Venda (Atual)] as
Sum({[Data].[2015].[January].[1] : [Data].[2015].[January].[19]} , [Measures].[VLATEND])
SELECT
NON EMPTY {[Measures].[Volume Venda (Anterior)], [Measures].[Volume Venda (Atual)]} ON COLUMNS,
NON EMPTY Hierarchize([Cliente].Members}) ON ROWS
FROM [Pedidos]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment