If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Maximum function in cross tab row

Started by bluecarbon, 12 Mar 2013 03:12:29 PM

Previous topic - Next topic

bluecarbon

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?

RKMI

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