COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: samiar784@gmail.com on 04 Feb 2016 10:30:44 AM

Title: Sorting issue in COGNOS Workspace Advanced(Crosstab report)
Post by: samiar784@gmail.com on 04 Feb 2016 10:30:44 AM
Hello!!

I am trying to sort the year column on a crosstab, but getting the below warning.

"There are no sets to sort on the opposite edge".

Thanks in advance.

Sameena

Title: Re: Sorting issue in COGNOS Workspace Advanced(Crosstab report)
Post by: MFGF on 05 Feb 2016 03:48:30 AM
Quote from: samiar784@gmail.com on 04 Feb 2016 10:30:44 AM
Hello!!

I am trying to sort the year column on a crosstab, but getting the below warning.

"There are no sets to sort on the opposite edge".

Thanks in advance.

Sameena

Can you give us more information? What *exactly* are you doing to implement the sort? What do you have in rows, columns and cells?

MF.
Title: Re: Sorting issue in COGNOS Workspace Advanced(Crosstab report)
Post by: samiar784@gmail.com on 08 Feb 2016 05:38:56 AM
Thanks for replying. This issue is happening to my user, I am getting the sorting right. My crosstab has countries as the rows and years as the columns. I am trying to sort on one of the year column. But on doing so I get the attached warning. :(

Regards,
Sameena
Title: Re: Sorting issue in COGNOS Workspace Advanced(Crosstab report)
Post by: MFGF on 08 Feb 2016 09:13:04 AM
Quote from: samiar784@gmail.com on 08 Feb 2016 05:38:56 AM
Thanks for replying. This issue is happening to my user, I am getting the sorting right. My crosstab has countries as the rows and years as the columns. I am trying to sort on one of the year column. But on doing so I get the attached warning. :(

Regards,
Sameena

Can you describe exactly what you are doing? "I am trying to sort on one of the year column" is very vague. How are you doing this? What steps are you taking?

What sort of package are you using - relational or dimensional? What are "Countries" and "Years"? Are they query items? Member sets? Calculations? Attributes? Something else?

MF.