|
cipriani1984
Constraint Violating Yak Guru
United Kingdom
300 Posts |
 Posted - 12/04/2012 : 04:13:38
|
Hi
I have the following union in MDX and just trying to figure out how to only put a parameter on one of the unions, any ideas?
SELECT
[Measures].[Score Dm Count]
ON COLUMNS,
UNION (
CROSSJOIN (
[Dim ACQ Score Card Time Table].[Month Name].&[7] ,
NONEMPTY ( [Dim ACQ Score Dm Acc Rej].[Hierarchy].[Label] )
) ,
CROSSJOIN (
[Dim ACQ Score Card Time Table].[Month Name].&[10] ,
NONEMPTY( [Dim ACQ Score Dm Acc Rej].[Hierarchy].[Label] )
)
) ON ROWS
FROM [Accs Rej]
So the 2nd set of results on the 2nd crossjoin id like to paramitise those results and the ones from the first will always stay.
Thanks |
|
MDX Union
