Hi all,
I am executing a report in Report Studio. In the code generated by Cognos, I see that Cognos created 'over partition by' instead of 'Group by'. I am wondering what are the factors which force Cognos to behave like that.
Hi
Are you using rank() in your report query?
Thanks
Kiran
No, I don't.
It might present itself if you have an explicitly defined aggregation in a data item, such as:
total([measure] for [some dimensional attribute])
... rather than just setting the aggregation properties as desired and letting Cognos naturally aggregate, and may also infer if you are working with a list that you haven't grouped it on anything.