Sql code generated in Cognos

[backhandx]

 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.

[Kiran P]

Hi

Are you using rank() in your report query?

Thanks
Kiran

[backhandx]

No, I don't.

[rockytopmark]

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.