cancel
Showing results for 
Search instead for 
Did you mean: 

Webi - Report Grand Total set as a Section Did Not Work

former_member243717
Participant
0 Kudos

All,

I have a report with one of it's dimensions as a Hierarchy Dimension and couple of measures. Note: I have expanded all the hierarchies. When I try to section the report. I created the sub-totals of the sectioned dimension, which is giving correct values but when I tries to calculate the Grand Total of all the sub-totals, am not getting the correct figure. I have tried and tested the grand total value with other ways like converting the report to a "Break" and also creating a new report from the scratch by dragging and dropping and also deleting the dimensions one by one to see where the issue may be, but no luck.

The irony is that I have another report previously created months ago with a section that the Grand Total is working fine. I also modify another report entirely from a break to section and it worked fine.

Can anybody please tell me what can be wrong here with this particular report because the grand total is way less that what it should be, almost half.

This is a BICS Connection with BW 7.3 and BO 4.1 (SP5).

Greatly Appreciated !!!

Thanks,

Recca

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Did you check the filters applied on the document, table or cell even?.

Is the measure a variable or BEx KF?. Do you have any merged queries?.

Thanks,

Jothi