Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2012-12-04 : 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 ROWSFROM [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