NP.....

Does this calculated measure, after applying the division, rollup up along all other "non-product dimensions" in your cube by summing (x/y)?

If you don't hear from me the rest of the...

RE: sliced from the top of the dimension down to the different hierarchies

Do you mean "only roll up (x/y) from the leaf level of product if its ancestor is...

Also, what is the size of the SOURCE DATA you are trying to process (uncompressed, in GB)?

Did you get this resolved? I wish I could help you more, but I am really having trouble envisioning the solution. Forgetting the MDX for just a second, what...

Without seeing the data model, I am going to say try your original solution, but make sure you test for the member being empty as WELL AS being equal to...

In business terms, what are you trying to do? What is the rationale driving the calculation?

Creating calculations in your ETL or a named calculated column in your data source view will result in your results being physically materialized in a cube....enabling for quicker rollups/aggregations.

Creating calculated...

You caught me on a good day 😉

1. Are any of your users present in more than one role? Unlike SQL Server RDBMS, denied privileges do not trump allowed privileges but are a UNION of all...

First try moving the set in the WHERE clause to the "ON ROWS" axis. Do you then get what you want?

You'll probably want to use a combination of the SCOPE assignment operator together with the LEAVES function and "THIS" statement instead of using the IF function and testing the coordinate's...

My laptop is not showing the screen print so I am taking a blind stab here, but consider this:

1. The WHERE clause in MDX is evlauted before the axes.

...

BIDS Helper has a nice add-on utility "Aggregation Manager", but that is technically still BIDS.

SSMS has an "assign aggregation design" feature that assigns existing designs to other partitions.

http://technet.microsoft.com/en-us/library/ms181200.aspx

Once...

Yes, as a BI practitioner, I have a special place in my heart for DATE_CORRELATION_OPTIMIZATION. 🙂

Perhaps the confusion stems from the fact that this question is ONLY within the context of SQL Server 2008 R2 (as if SQL Server 2012 had not yet existed)?

It's like...