dbTalk Databases Forums  

#ERR appears in first cell (ordinal 0) but goes away when scroll

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss #ERR appears in first cell (ordinal 0) but goes away when scroll in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lesley
 
Posts: n/a

Default #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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.