#ERR appears in first cell (ordinal 0) but goes away when scroll -
08-03-2005
, 10:17 AM
I am using a custom rollup on a parent/child dimension. This is the
syntax:
CalculationPassValue([Measures].CurrentMember,
-1, RELATIVE) -
iif(IsLeaf([Hist Mgr Hierarchy Dim].CurrentMember),
0,
CalculationPassValue(([Measures].CurrentMember,
[Hist Mgr Hierarchy Dim].CurrentMember.DataMember),-1, RELATIVE))
This gets rid of the parent's datamember totals in his/her own total.
This works.
However, I have dimension security on this same dimension. An MDX
statement executes that does a nonemptycrossjoin amoung other things
and a link member to only show users the members of the parent/child
dim they are allowed to view.
When they are clicking down in the hierarchy, the #ERR shows in the
first cell (no matter what measure it is). When you click on it, it
shows the value. If you scroll over and back, the #err disappears and
the correct number shows.
When you get to the manager's info in the hierarchy, the #ERR does not
show. Only in levels above the user's level.
Any help would be greatly appreciated. |