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 |
|
Pachi
Starting Member
2 Posts |
 Posted - 2012-02-22 : 04:03:41
|
| i am not able to get the output for the below query,Please advice.--'SELECT NON EMPTY { [Measures].[New Actives], [Measures].[Signups], [Measures].[Gross Win GBP], [Measures].[Registrations], [Measures].[NGR GBP], [Measures].[Actives] } ON COLUMNS, NON EMPTY { ([Customer].[Acquisition Source].ALLMEMBERS * [Customer].[Affiliate Group Name].ALLMEMBERS * [Customer].[Affiliate Name].ALLMEMBERS * [Customer].[Affiliate ID].ALLMEMBERS * [Product].[Sub Product].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS --FROM ( SELECT ( { [Location].[Country].&[United Kingdom] } ) ON COLUMNS --FROM ( SELECT ( { [Channel].[Channel Hierarchy].[Channel Name].&[23] } ) ON COLUMNS --FROM ( SELECT ( {' + [Yesterday] + ' : ' + [Yesterday] + '} ) ON COLUMNS FROM [AllProdsWarehouse]--'')--' |
|
|
Pachi
Starting Member
2 Posts |
Posted - 2012-02-22 : 04:04:56
|
| I guess the problem is in FROM ( SELECT ( {' + [Yesterday] + ' : ' + [Yesterday] + '} ) ON COLUMNS line, but even after commenting i am not getting the result |
 |
|
|
|
|
|
MDX issue