Skip to Content
0
Former Member
Apr 28, 2010 at 04:14 AM

Aggregation issue for report with bw structure

34 Views

Hi,

I am facing aggregation issue while grouping reports in webi.

We have a BW query with 16 values, which we bring to bw as structure. Out of 16, 8 are percentage values (agg. type should be average).

If we bring the data at site level, data is comming properly. But if we use same query and try sum/grouping( on region level), then percentage is getting added.

Since it's a dashboard report with lots of filters, we cannot go for seperate query at each level(site, region, zone).

How we can resolve this.. please give me suggestion.

Regards

Baby