daily pastebin goal
50%
SHARE
TWEET

Untitled

a guest Nov 21st, 2017 50 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
  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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top