April 26, 2012 at 3:18 pm
I have the following MDX query being used inside of OpenRowset:
SELECT { [Measures].[Sales]} ON COLUMNS,
[Dim1].[Product].Members
* [Dim2].[Year].Members ON ROWS
FROM [CUBENAME]
When I run this in SSAS I get
ALL ALL ####
ALL 2010 ####
ALL 2011 ####
ALL 2012 ####
M1 ALL ####
M1 2010 ####
...
M3 ALL ####
M3 2010 ####
etc
When I run it in OpenRowset in TSQL, the ALLs are showing as NULL. Is there a way to default the NULL to all? Is there a way to not return the All record?
Thanks,
John
April 26, 2012 at 10:58 pm
maddencircledme (4/26/2012)
I have the following MDX query being used inside of OpenRowset:SELECT { [Measures].[Sales]} ON COLUMNS,
[Dim1].[Product].Members
* [Dim2].[Year].Members ON ROWS
FROM [CUBENAME]
When I run this in SSAS I get
ALL ALL ####
ALL 2010 ####
ALL 2011 ####
ALL 2012 ####
M1 ALL ####
M1 2010 ####
...
M3 ALL ####
M3 2010 ####
etc
When I run it in OpenRowset in TSQL, the ALLs are showing as NULL. Is there a way to default the NULL to all? Is there a way to not return the All record?
Thanks,
John
what is your mdx query?
---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply