Nice question, but there should have been a better trap answer. Too many obviously wrong. You could have done a 20,6,10,3 and it may have tripped up some people....

It seems a bit strange to start with learning about a tool, and then using it to define one's needs. Usually people come at it the other way and...

So now the question is just size?

That is pretty tough to answer without getting into specifics (how big is too big? do you need all the data you are including?...

Is the batch file executing it from the catalog, or from the file system?

If the problem is only with the catalog, did you configure the package/project correctly? Protection levels...

edit: Duplicate post

I'm pretty sure the .members is the correct syntax. The query will filter down which numbers it includes to those in may,the .members in the definition just says...

I have no idea why you would want to set up your views that way. With no measures in the first view, there is really nothing you gain from...

Try bringing up the properties of the level and setting the Hide Member If property to "OnlyChildWithParentName"

EDIT: Removed this approach as performance was terrible

I did a quick and dirty scale out of the test data (adding copies of the test set for other masterid's), and the...

This is what I came out with.

No idea if it will perform well. So many iterations and changes as I got to understand the intracacies of your requirement.

I suspect it...

First tip: if you put all of that in a code block it will give a seperate scrollbar and not make your page so long and hard to read.

At first...

I don't think the issue is with scope specifically but with having a calculated measure.

from msdn:

When you query a cube that contains a linked measure group, the link is established...

Its definitely worth doing when the dollar figure...

I don't know Luis, I think that's not complicated enough 🙂

A quick example building some tables to work with. It was thrown together quickly so some testing may be...

So you are doing the time in minutes, not hours, correct?

Working on a set based example for you ...