daily pastebin goal
66%
SHARE
TWEET

Untitled

a guest Nov 21st, 2017 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. {Measures.[Deviation],[Measures].[Product ID]} ON COLUMNS,
  3. Filter (
  4.             CROSSJOIN(
  5.                         {[Dim Customer].[Customer Name].[Customer Name].MEMBERS},
  6.                        {[Dim Customer].[Gender].[Gender].MEMBERS},
  7.                        {[Dim Customer].[Customer ID].[Customer ID].MEMBERS}
  8.                      ) ,    
  9.             ([Measures].[Product ID] > 1 AND [Measures].[Deviation] >5 and [Measures].[Quantity]>1)      
  10.          ) on ROWS FROM( SELECT  ( [Dim Customer].[Customer ID].&[1] : [Dim Customer].[Customer ID].&[5]) ON COLUMNS FROM ( SELECT { (Instr( [Dim Customer].[Customer Name].currentmember.Properties( 'Member_Caption' ), 'H' )  = 1  ) } ON COLUMNS
  11. FROM [OLAP Cubes]))
RAW Paste Data
Top