Monday, March 12, 2012

Matrix Drill down Value not Correct

I am making a report that has column groups Day of Week and then "late".
(early late ontime) Row groups consist of region,district,store,dept. The
value is the sum(Fields!Measures_Rec_Count.Value) and reflects the correct
numbers throughout the drilldown. I am having problems with the Ratio value
calculated as format(sum( Fields!Measures_Rec_Count.Value
,"matrix1_late_Late")/sum(Fields!Measures_Rec_Count.Value,
"matrix1_dow_Dow"),"#.#%")...this calculates the correct ratio for the top
level but remains the same throughout the drilldown...I have tried using the
InScope() function but not getting any positive results....
Any Ideas?
Sunday Monday
...etc
Early ontime late Early ontime
late
region 10(83%) 2(17%) 10(25%) 25(64%) 4(10%)
district 1 3(83%) 2(17%)
district 2 4(83%) (17%)
district 3 3(83%) (17%)still could not get dynamicly grouped columns and rows to drill down with the
correct numbers....altered my MDX to create a matrix with one dynamic column
and 3 static columns and the drill down works now.....If anyone knows of a
way to have multiple dynamic columns where calculated cells drill down with
correct values please let me know.
Thanks.
"Raz" wrote:
> I am making a report that has column groups Day of Week and then "late".
> (early late ontime) Row groups consist of region,district,store,dept. The
> value is the sum(Fields!Measures_Rec_Count.Value) and reflects the correct
> numbers throughout the drilldown. I am having problems with the Ratio value
> calculated as format(sum( Fields!Measures_Rec_Count.Value
> ,"matrix1_late_Late")/sum(Fields!Measures_Rec_Count.Value,
> "matrix1_dow_Dow"),"#.#%")...this calculates the correct ratio for the top
> level but remains the same throughout the drilldown...I have tried using the
> InScope() function but not getting any positive results....
> Any Ideas?
> Sunday Monday
> ...etc
> Early ontime late Early ontime
> late
> region 10(83%) 2(17%) 10(25%) 25(64%) 4(10%)
> district 1 3(83%) 2(17%)
> district 2 4(83%) (17%)
> district 3 3(83%) (17%)
>

No comments:

Post a Comment