I've got a very strange behaviour from an Realtime ROLAP cube (SQL notification).

The structure (2 dims , 1 measuregroup)

DImCustomer : (All level )
- mandantid
- salesman
+- mandantid (rigid, many)
- compnyid (key)
+- salesman (rigid , many)

DimArticle: (All Level)
-L1
-L2
+-L1 (rigid, many)
-L3
+-L2 (rigid, many)
....
-L7 (key)
+-L6 (rigid, many)

One measure group
- Sales (sum)
- Wieght (sum)


The cube is working fine, fast and the data is ok.

I defined a role wich is allowed to see only some mandants (4) from the total of 20 with visual totals on.

I have data only for this 4 mandants at the moment.

I browse the cube from management studio. I make a pivottable like:

DimCustomer
DimArticle M1, M2, M3, M4, Total
L1 sales ...
-L2 ...
....

and I get the correct data.
If I make the following selection:

DimCustomer
DimArticle M1, Total
L1 sales ...
-L2 ...

I get below M1 the sum of all (4) mandants and not only the values for M1. If I select more than 1 mandant (M1, M2) the values are correct.
I have the same dimensions used in a MOLAP cube and there everything is working fine.

Anyone have an ideea?

Thanks,
Radu