COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: sunny bachan prasad on 23 Jan 2018 07:13:45 AM

Title: List or cross tab in cognos 11 Analytics
Post by: sunny bachan prasad on 23 Jan 2018 07:13:45 AM
Hi,
I am currently using cognos 11 multi tab dashboard and want to show list or cross tab in second tab along with measure. Is it possible?
Title: Re: List or cross tab in cognos 11 Analytics
Post by: MFGF on 23 Jan 2018 07:37:15 AM
Quote from: sunny bachan prasad on 23 Jan 2018 07:13:45 AM
Hi,
I am currently using cognos 11 multi tab dashboard and want to show list or cross tab in second tab along with measure. Is it possible?

Hi,

Yes. Drag in either a crosstab or a table from the visualizations pane:

(https://image.ibb.co/fTm0Ww/Dash_List_Crosstab.png)

Cheers!

MF.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: sunny bachan prasad on 24 Jan 2018 12:33:25 AM
Hi MF,
Thanks for the time but i think List is not working as usual in report studio. I am satisfied with cross tab. I was thinking to show some detail data in second tab of dashboard in list.Please share your experience if you have any on this.

Title: Re: List or cross tab in cognos 11 Analytics
Post by: MFGF on 24 Jan 2018 04:20:19 AM
Quote from: sunny bachan prasad on 24 Jan 2018 12:33:25 AM
Hi MF,
Thanks for the time but i think List is not working as usual in report studio. I am satisfied with cross tab. I was thinking to show some detail data in second tab of dashboard in list.Please share your experience if you have any on this.

Can you explain what "List is not working as usual" means?

MF.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: sunny bachan prasad on 26 Jan 2018 06:53:27 AM
Hi,
MF thanks for your time. I was trying to say that list is not coming as it used to come in report studio. all the items are coming under one column as shown in attached snapshot.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: Lynn on 26 Jan 2018 07:17:25 AM
Quote from: sunny bachan prasad on 26 Jan 2018 06:53:27 AM
Hi,
MF thanks for your time. I was trying to say that list is not coming as it used to come in report studio. all the items are coming under one column as shown in attached snapshot.

Report Studio is now just authoring and you can still use that in Cognos 11 for all that familiar functionality. The dashboard tool offers different functionality.

Within the dashboard tool the table object might be closer to what you are interested in. There is a user guide for dashboards and stories which might help you:

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/11.0.0/ug_ca_dshb.pdf
Title: Re: List or cross tab in cognos 11 Analytics
Post by: MFGF on 26 Jan 2018 09:38:16 AM
Quote from: sunny bachan prasad on 26 Jan 2018 06:53:27 AM
Hi,
MF thanks for your time. I was trying to say that list is not coming as it used to come in report studio. all the items are coming under one column as shown in attached snapshot.

You must be doing something very strange! It works perfectly for me...

(http://image.ibb.co/h6sTOb/Dashboard_table.png)

MF.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: Lynn on 26 Jan 2018 10:09:33 AM
OP appears to be using the List object rather than the Table object that you've highlighted.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: sunny bachan prasad on 26 Jan 2018 11:59:19 AM
Hi MF,
Could yoou please maximize and see if it is List as shown in attached snapsot. Since i tried again but i am getting same output.

Title: Re: List or cross tab in cognos 11 Analytics
Post by: Lynn on 29 Jan 2018 02:33:25 AM
Quote from: sunny bachan prasad on 26 Jan 2018 11:59:19 AM
Hi MF,
Could yoou please maximize and see if it is List as shown in attached snapsot. Since i tried again but i am getting same output.

MFGF suggested a TABLE object, not a list, and posted a screenshot of it. I suggested a TABLE object after you posted a screenshot showing a list. MFGF then showed the output again using a TABLE object, not a list.

Can you try using a TABLE object rather than a list? This used to be called a grid but was renamed in R7. The List object used to be called a hierarchy. Take a look at the first screenshot that MFGF posted which shows all the objects in the toolbox and has a highlight of the table object.
Title: Re: List or cross tab in cognos 11 Analytics
Post by: sunny bachan prasad on 01 Feb 2018 09:50:34 AM
Hi Lynn/MFGF,
Thanks for your time and suggestion. Yes table solve my problem.