Interactive mode crosstab wrong summary when expanding

[Commander Cognos]

Hi everyone,

I'm have a big issue in Cognos Analytics. I'm wondering if anyone has an update on this or a proper workaround.

When you have a report in CA in interactive mode with dimensional data and you expand a member in a set, the total in the summary row is double counting the children on the set. This makes no sense at all, however, I see no chance to edit the behaviour.

Example:

                     Net value
Product A      100
Product B      200
Product C      300
Summary      600

When I expand Product A:

                Net value
Product A      100
  Product A1    30
  Product A2    50
  Product A3    20
Product B      200
Product C      300
Summary      700

I noticed there is a change request open, however I'm wondering why there is no more complaining on this?

Thanks a cheers,
CC

[CognosPaul]

This is a problem with the extended data items. I can't really see any solution to this. The solution would be to total the unique descendants to the lowest grain in the rows. But there doesn't appear to be a way to do any complex calculations before the aggregation.

I'm still looking into this, but I suspect the only solution would be a code fix.

[Commander Cognos]

Hi CognosPaul,

thanks for having a look. In the meantime I found this request already one year old:
https://ibm-data-and-ai.ideas.aha.io/ideas/CAOP-I-493

I hope there will be a fix soon.
Thanks!