tag:blogger.com,1999:blog-32998500.post8386523389553368530..comments2023-10-05T18:28:39.552+05:30Comments on Microsoft Analysis Services & MDX - blogs by Ajit Singh: NextAnalytics and MDX : Part 1 - Swap Cells with Row LabelsAjit Singhhttp://www.blogger.com/profile/17889678799981918534noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-32998500.post-70960690408681541982009-09-17T19:38:01.744+05:302009-09-17T19:38:01.744+05:30Dear Ajit,
Thanks for the entry, very interestin...Dear Ajit, <br /><br />Thanks for the entry, very interesting. I am trying to accomplish something similar although there are a couple of differences. First, once the calc (weighted average i my case) is defined on the cell level, I will define a basket value 1-10, as in your case. Then I want to create a virtual dimension which when placed on rows will have the available basket values - 1-10 and corresponding aggregated cells - count/sum/avg of the cell occurrences with the same value as the basket. The only complication is that instead of using a hard coded set - emp in your case - I would like to get correct aggregations irregardless of the dimensions selected. So the bucketing happens on the cell level. Possible or not? Thanks a lot.Polaronoreply@blogger.comtag:blogger.com,1999:blog-32998500.post-46408927926179943852008-08-27T02:35:00.000+05:302008-08-27T02:35:00.000+05:30"The goal is not to prove who is superior or compl..."The goal is not to prove who is superior or complex to use. Just the sheer pleasure of validating that MDX is equally capable of fulfilling similar requirement."<BR/><BR/>Thanks Ajit for spending so much time and effort to demonstrate that nextanalytics makes life much easier for the business analyst (at least in this case) :) Surely the whole point of both MDX and nextanalytics is to enable human beings to perform analytics on a set of data. I believe that most human beings understand a series of operations performed sequentially (as in a nextanalytics script) better than the multi-dimensional query paradigm (as in MDX).Anonymousnoreply@blogger.com