Totals are Miscalculated in Webi

[Former Member]

Hello everybody,

I have a problem in a Webi report.

My report is based on two sources, one Bex query and one universe. There s a common object, which i have used for merging, and it works good.

However when i want to display total of measures from Bex source, based on dimension from universe, it fails to do so.

As you can see in the screenshot attached, sum value shows total of whole report, instead it should show total of each group.

Does anyone know, is it an expected behaviour? Or how to fix it?

I already tried Sum in break, sum in section, foreach and in functions, did not help.

Thanks

[Former Member · Accepted solution]

Hello

@Ingo: It is 4.0.

@Prhabit : It is a CKF at Bex

I tried your solutions, but none of them worked.

At the end, we asked SAP and here what they recommended, it is working:

Create a variable which is (= Completion) , but as a detail of DisplayOrderPath (merged dimension).

Now i can both see total in correct way, and i can remove this column from table.

Thanks for all your replies.

Regards

[jyothirmayee_s]

Hi,

Try

=sum([TEC]) forall ([DisplayOrderPath];[Completion])

If that doesn;t work then remove the subtotals from the report and reinsert using the SUM from Analsyis >> Functions tab

Also .. did you jsut tried inserting Sum([TEC])?.

Thanks,

Jothi

[sateesh_kumar1]

Hi Sathish,

Use =forcemerge([TEC]) , if you are not using any of the merged dimensions in the block.

[IngoH]

Hi,

is this XI 3.1 or BI 4.0 / BI 4.1 ?

is the key figure configured as delegated ?

Ingo

[Prabhith]

Hi Sathish,

I am more interested in knowing the TEC Keyfigure in your Bex Query?

Is it directly coming from any Infoprovider or a derived one like RKF or CKF(with some except aggr)

Can you let us know the definition of TEC in Bex query?

BR

Prabhith

[Former Member]

Hi Sathish,

Are you using Display Order path dimension from Query 1 or using the Merged object.

Can you try with Merged Dimension and TEC keyfigure and sum up the value ad more over can you let me know the total amount of key figures individually.

I believe Merged dimension and Keyfigure will give correct value.

Regards,

G.Sainath.

[Former Member]

Hi Gajawada,

I am using Merged Dimension already, but i tried with single objects from Queries as well.

None of the combinations working!

Thank you

[Former Member]

Hi Sathish,

Can you please let me know the Sum value for TEC from Query 2?

Regards,

G.Sainath

[Former Member]

Hi Gajawada,

Total of TEC from Bex Query is 617644430,34.

Regards

[Former Member]

Hi Satish,

Can you try with =sum(TEC forall(DOP)),  DOP should be from merged one and try with DOP from query1.

Regards,

G.Sainath

[Former Member]

Hi Sathis,

Use context operator in Block to sum the measure objects.

As Sum([measure-obj]) in Block

Regards,

Ambreen

[Former Member]

Hello Ambreen,

I changed sum cell to =sum([TEC]) in block

But nothing changed, still shows total of report.

Any other ideas?

Thanks a lot.