COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: houlivan on 14 Feb 2018 08:47:04 AM

Title: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: houlivan on 14 Feb 2018 08:47:04 AM
We upgraded recently from Cognos 10.2.1 to  Cognos 11.0.8

In Cognos 10, there was a Table Menu that let you do things like add rows to tables

That functionality seems to be missing in Cognos Analytics

Am I missing something? I know I could add a new table with a different number of rows but was hoping to adjust the number of rows in an existing table

Thanks

Mike Sullivan
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: MFGF on 14 Feb 2018 08:56:15 AM
Quote from: houlivan on 14 Feb 2018 08:47:04 AM
We upgraded recently from Cognos 10.2.1 to  Cognos 11.0.8

In Cognos 10, there was a Table Menu that let you do things like add rows to tables

That functionality seems to be missing in Cognos Analytics

Am I missing something? I know I could add a new table with a different number of rows but was hoping to adjust the number of rows in an existing table

Thanks

Mike Sullivan

Hi,

Just click on a table cell. The option to insert new rows/columns is on the interactive toolbar - use the ellipsis at the end, choose 'Insert' and you'll see the options:

(https://image.ibb.co/m22RMS/Table_Adjust.png)

Cheers!

MF.
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: houlivan on 14 Feb 2018 09:40:16 AM
Thank you so much MF! I was spinning my wheels. I really appreciate it
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: adam_mc on 27 Feb 2018 01:26:08 PM
In 11.0.6, we've found that you can bring up the Menu bar by going to the Page View, Selecting a Page then pressing <Control>, <Alt>, <M>.

This gives all the previous menu drop downs similar to 10.2 including the Table Menu.

Thanks,
Adam.
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: dougp on 27 Feb 2018 04:40:19 PM
...and I expect that menu to disappear once 11.0.x is ready for production.
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: MFGF on 28 Feb 2018 03:46:30 AM
Quote from: dougp on 27 Feb 2018 04:40:19 PM
...and I expect that menu to disappear once 11.0.x is ready for production.

Hmmm. That's a slightly negative comment there, my friend ;)

I don't think that menu will disappear - it's primarily there to allow debug options to be enabled if IBM Support need to dig into a report, I think. It's not something supported or advertised for production use, though. :)

Cheers!

MF.
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: dougp on 28 Feb 2018 09:55:05 AM
I've had a slightly negative experience with Cognos since upgrading from 10.2.1. ;)
Title: Re: How to add rows to tables in Cognos Analytics (no Table Menu any longer?)?
Post by: MFGF on 28 Feb 2018 11:01:29 AM
Quote from: dougp on 28 Feb 2018 09:55:05 AM
I've had a slightly negative experience with Cognos since upgrading from 10.2.1. ;)

I have just the song for you!!

https://www.youtube.com/watch?v=jHPOzQzk9Qo

Hee hee :)

MF.