Hi all
Need to sort this problem out..
i was working on analysis services 2000 with SQL server 2000 and OWC
pivot table version 9

i need help in figuring this requirement:

i got a defects cube with defects (count) and pages (sum) with
dimensions
person(parent-child), defect types, books.

requirement is i need to give the defects for a given person along with
page count.

this works fine at the leaf level but at the aggregation level, i need
the total defects along with their distinct pages. the reason is i can
have multiple defect types raised on the same book..so the page count is
repeated for each defect type.. what i want is total count of defects
and distinct sum of pages.

Hope u got the issue.. i was in a fix and thought that a calculated
member with defect count/pages will solve but it is applying the same
formula even at the group total level.. what i want is the aggregation
must be sum of the childs within that level.

--
Posted via http://dbforums.com

hi all
found a solution for the distinct sum issue i posted earlier..
here is the code i figured out but this one is taking huge processor
resources and takes a very very very long time on the browser..
please help me in tuning this expression..

iif([Person_Role_Success].currentmember.level.ordinal =
[Person_Role_Success].[Level 05].ordinal, iif([Measures].[Dfc Sk] > 0,
ValidMeasure([Pj Actual Size]),0), sum([book].children,
iif([Measures].[Dfc Sk]>0,ValidMeasure([Pj Actual Size]),0)))

where dfc sk = defect count and Pj Actual Size is page count.

i'm able to get the results i expected but this one is taking very very
long time everytime there is a change inthe current view..please help me
in tuning this expression

thanks in advance

--
Posted via http://dbforums.com