January 23, 2015 at 1:11 pm
I'm sure this is a very newbie question, but I'm trying to understand the difference between accessing the Style Members below using approach 1 vs approach 2. In the first one I'm accessing the members thru the level Style. I thought the second one does the same thing even though i don't specify the level. I get different results, which makes me think these are not the same.
1.
SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS,
{ ([Product].[Style].[Style].Members) } ON ROWS
FROM [Adventure Works]
2.
SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS,
{ ([Product].[Style].Members) } ON ROWS
FROM [Adventure Works]
January 23, 2015 at 2:27 pm
Mike49 (1/23/2015)
I'm sure this is a very newbie question, but I'm trying to understand the difference between accessing the Style Members below using approach 1 vs approach 2. In the first one I'm accessing the members thru the level Style. I thought the second one does the same thing even though i don't specify the level. I get different results, which makes me think these are not the same.1.
SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS,
{ ([Product].[Style].[Style].Members) } ON ROWS
FROM [Adventure Works]
2.
SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS,
{ ([Product].[Style].Members) } ON ROWS
FROM [Adventure Works]
The second one will include the "All Styles" member as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply