Unary Operator Column in Accounts Dimension Behavior

Question

I set up a cube with 4 dimensions:

Time

Account

Department

Project

and 1 measure

Amount

 

Without adding the unary operator to the Accounts Dimension, I am able to drag Project to be rows and Amount to be column to break up the amount by project.  Once I added the unary operator column to the heirarchy in the Accounts Dimension, I have to drag the Accounts Dimension first, followed by Project to see any breakdown at all.  I couldn't do Project, then Accounts.  Is this the expected behavior?

Answer 1

After some debugging, it seems like the tilde (~) operator is causing the problem.  If I change all the account with (~) to any other operator, I can break down my measure by any dimension.  On the other hand, if any account member has the (~) operator, I can only break down the measure by the account dimension first.  Is this a bug in SSAS?

Answer 2

I just discovered this problem, particularly if you set up a WITH MEMBER of a couple of members and use it on the parent child dimension. If the rollup operator is +, the results are fine. If it is ~ a null is returned.

As I do not have the aggregate (ALL level) setup on the parent, I am going to set the ~ to be + and then check the results and report back.

Answer 3

Using + unary operator did not resolve the error I am getting. The results appear correctly when I have a custom member aggregation formula defined. Otherwise it does not return the correct results. The unary operator did not have an impact.

Next step is to upgrade to SP1 hotfix 2153 and check it out. There is a KB at http://support.microsoft.com/kb/912450/ which might explain this behavior.

Answer 4

The hotfix 2153 did not fix the aggregation with member using a parent-child dimension.