Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- {Measures.[Deviation],[Measures].[Product ID]} ON COLUMNS,
- Filter (
- CROSSJOIN(
- {[Dim Customer].[Customer Name].[Customer Name].MEMBERS},
- {[Dim Customer].[Gender].[Gender].MEMBERS},
- {[Dim Customer].[Customer ID].[Customer ID].MEMBERS}
- ) ,
- ([Measures].[Product ID] > 1 AND [Measures].[Deviation] >5 and [Measures].[Quantity]>1)
- ) 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
- FROM [OLAP Cubes]))
Add Comment
Please, Sign In to add comment