May 22, 2017 at 8:11 pm
Comments posted to this topic are about the item Super Grand Total MDX
May 22, 2017 at 11:13 pm
Nice to see a question about MDX, thanks Devendra
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
May 23, 2017 at 12:14 am
Nice question, but the correct answer is wrong. It should be the 4th one as said by the explanation, right?
May 23, 2017 at 1:01 am
Good question, I haven't done any MDX so interesting to read the link.
Thanks.
May 23, 2017 at 1:26 am
Nice question, but the correct answer is wrong. It should be the 4th one as said by the explanation, right?
May 23, 2017 at 3:40 am
Also got it "wrong" even though the explanation given points to answer 4...
May 23, 2017 at 4:56 am
The fourth option is the correct answer.
This: "Super grand total of all the measures for all the dimension at all level"
makes absolutely no sense since not only can measures have different formats they can have different methods of calculation (last non empty, average of children, distinct count etc.). This query will always result in either the default measure or (if it's not defined) the first measure defined in the XMLA of the cube aggregated over the All member of each dimension which is irrelevant in this case but worth mentioning for completeness.
Additionally, I have never seen the term "Super grand total" used in any SSAS documentation. A quick google search reveals this question as the only full hit. Is this a term you have made up? If not, can you cite your source?
May 23, 2017 at 7:28 am
Correct answer should be 4.
I took a quick look and was surprised the official documentation doesn't make it clear that if you specify no measures in the MDX, you get the default measure. I saw a lot of posts about determining which measure is the default but not its behavior.
May 23, 2017 at 7:50 am
I join the chorus in that the answer is 4. It's one of the reasons that you specifically set a default measure or else you might get the super sum of any measure. The link does not specify otherwise and it's not an official source in any case. Looking for a review and further explanation if the original answer is upheld.
May 23, 2017 at 7:58 am
Yes, it is #4. It is the sum o the default measure.
Thomas LeBlanc, MVP Data Platform Consultant
May 23, 2017 at 2:01 pm
Just pitching in for #4 to get a point.
May 24, 2017 at 7:16 am
It's been a whole day and there's been no comment from the author of the question about all the comments that say it's number 4, and if it will be corrected or why we are all wrong. Had I written a question I would be watching the feedback pretty closely. Just saying....
May 24, 2017 at 10:12 am
If 4 is correct, less than 30 percent of respondents got it right.
May 24, 2017 at 10:34 am
I thought I had it right! Let the adjudicator decide (did I spell that right?). Either way a good question?
...
May 24, 2017 at 10:38 am
That in itself doesn't say much. What were the other percentages? I can't seem to find a way back there.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply