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
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.
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!