Webi Report Measure values are not showing up in the summary - cross tab.

[Former Member]

Hello,

I have detail tab in which all the calculations are working as expected. But however when I tried to show the information in different way by using the cross tab it doesn't gives me the correct values.

For Eg :

Detail Report has the following objects:

Number # , Id, Region, Value and so on...

Dimension(merged), Id(Dimension-Variable), Region( Detail Object) , Values (Measure)

This Number # is a merged dimension which from 3 query's, Id is a variable defined by using the existing objects, Region is a detail object defined associated to this account and the value is the measure object which is defined by using a variable. This is a normal table and it gives the correct results.

I want to show the same information in cross tab, Region( Detail Object) , Values (Measure) and it doesn't give me correct values at all. I tired to apply the forcemerge() to the measure but no luck.

If i pull the Number # , Id, in the cross tab then it give me correct result again. Not sure what is going on. But, I have to show only the Region and the Value in cross tab.

So any help on this will be appreciated.

[former_member492038]

What is the point in using a crosstab? If I understand correctly you just want to show the Region and the Values associated with them - can't you just use a vertical table for that?

[kohesco]

Hi,

this is quite normal behavior I guess, the variable/formula will calculate on the level of the dimensions specified, so it will calculate on the aggregation. It looks to me you want to calculate some things before the aggaregation. When you need to do that, you will need to specify the system on which level that is via ForEach() or ForAll(), chek out:

https://archive.sap.com/discussions/thread/1962721

https://michaelwelter.wordpress.com/2011/07/31/removing-the-confusion-from-calculation-contexts/