Hi,
I m trying to display a maximum of a value in a cross tab row. When i run the SQL against database i get the maximum value as 89 but the same when ran in cognos the value is displayed as 551. The maximum value is from a derived column in sql which uses dense_rank(). On further analysing it seems the dense_Rank() gets stretched for each measure value for different column values.
Is there a way to surpress the maximum() to not aggregate based on measure and only based on the other row values?
Hi,
When you view this data in terms of a list is the maximum value correct, I know when you change into a crosstab view the aggerations change slightly and even the generated SQL at report level you can try if at the query level at query explorer if you set Auto Group and Summarize Property to No by default it is Yes. Also another thing you would like to try to see if you have speificed rank([measure] for [data type]) or max ([measure] for ...) it feels like you are missing a grouping.
Thanks,
RK