Guest User

Untitled

a guest
Nov 21st, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  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]))
Add Comment
Please, Sign In to add comment