Is a tuple in MDX an implicit crossover?
Are these two statements equivalent?
Tuple:
SELECT {[Measures].[Volume]} ON COLUMNS,
([Product].[Product Id].[Product Id].AllMembers
,[Time].[Time].[Year].AllMembers) ON ROWS
FROM [My Cube]
Compared to explicit crossing:
SELECT {[Measures].[Volume]} ON COLUMNS,
[Product].[Product Id].[Product Id].AllMembers
* [Time].[Time].[Year].AllMembers ON ROWS
FROM [My Cube]
They seem to return the same result, but from reading I did it seemed like they shouldn't (at least not always).
+2
source to share
1 answer
What you have in your first query is not a tuple. Tuples are made up of a collection of one or more members.
eg. (member1, member2, ...)
Where do you have (set1, set2 ...). which I count as a subcube, since that's what is used when defining subcubes for the scope operators. And the subcube is essentially an implied cross-xin, so your two queries should return the same result.
+2
source to share