COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: a.chamkeri on 01 Feb 2017 10:23:39 AM

Title: Interactive Filtering in Cognos 11 Dashboard
Post by: a.chamkeri on 01 Feb 2017 10:23:39 AM
Hi All,

I have around 4 visualisations on my Dashboard. One of them is a Donut. When I click on each of the categories all the other visualisations filter correctly. However when clicking on one of the categories it gives an "Cannot copy 25 characters to varchar of length 8" error in all the other visualisations.

I am using Cognos 11.0.5.

Any inputs on what may be the issue will be highly appreciated.

Thanks in advance.

Regards,
Ajay
Title: Re: Interactive Filtering in Cognos 11 Dashboard
Post by: MFGF on 01 Feb 2017 10:40:47 AM
Quote from: a.chamkeri on 01 Feb 2017 10:23:39 AM
Hi All,

I have around 4 visualisations on my Dashboard. One of them is a Donut. When I click on each of the categories all the other visualisations filter correctly. However when clicking on one of the categories it gives an "Cannot copy 25 characters to varchar of length 8" error in all the other visualisations.

I am using Cognos 11.0.5.

Any inputs on what may be the issue will be highly appreciated.

Thanks in advance.

Regards,
Ajay

Hi,

What is the data source being used for the dashboard? Sounds like there's an incorrect column definition somewhere under the covers in your data? It thinks a specific data item is 8 characters in size, and somehow you're filtering on a 25-character value?

MF.
Title: Re: Interactive Filtering in Cognos 11 Dashboard
Post by: a.chamkeri on 01 Feb 2017 10:58:59 AM
Hi MF,

I am  using a Cognos Package as a datasource for the Dashboard.

Thanks,
Ajay
Title: Re: Interactive Filtering in Cognos 11 Dashboard
Post by: MFGF on 02 Feb 2017 02:07:51 AM
Quote from: a.chamkeri on 01 Feb 2017 10:58:59 AM
Hi MF,

I am  using a Cognos Package as a datasource for the Dashboard.

Thanks,
Ajay

Sounds to me like there's a problem with the way your package is modelled. I'd talk to the person responsible for your packages and show them the issue if I was you...

MF.