Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 02/27/20 07:41 AM

    ​Hello,

    I do not see the 'Freeze' option in the crosstab that will allow the freezing of a column heading.

    I have also tried this after changing report setting 'Run with will interactivity' to No.
    Does this option not exist in my version (11.0.11)?

    Thanks-Jen



    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 02/28/20 07:48 AM
    Hi Jenifer,

    Using the classic viewer, you can still do it the C10 way (by right-clicking on the viewer), for both lists and crosstabs. Setting the Run with full interactivity property on the report to No should still enable this in version 11.0.11. In the resulting report viewer, the right-click menu should look like this:

    Thanks
    Steve


    ------------------------------
    Steve Templeton
    ------------------------------



  • 3.  RE: Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 02/28/20 12:10 PM
    Hello, 
    this option is planned to be added into Cognos Analytics - see the request.
    Unfortunately there is no similar option with full interactivity mode on now. The only one possible workaround Is to disable interactivity mode as Steve mentioned.

    ------------------------------
    Jiri Smrz
    ------------------------------



  • 4.  RE: Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 03/03/20 03:45 PM
    Thank you both.  I thought I had tried this, but I will research this again and try to get it to work.​

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 5.  RE: Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 03/04/20 04:04 AM
    Hi Jenifer

    A few weeks ago I had to look at something similar to what you propose. In my case I had a list with many columns and wanted to freeze one or several columns. I found this video that can help you, it works with a custom control.

    https://www.youtube.com/watch?v=kzStfI59Gj0&t=59s

    In the end I didn't have to carry out the work and I didn't try it, but this solution can be a way to investigate your case.

    Please tell me if it works for you.

    regards

    ------------------------------
    Luis Moreno
    ------------------------------

    Original Message


  • 6.  RE: Cognos 11.0.11 Crosstab Freeze Column/Nested Column Headings

    Posted 03/04/20 09:57 AM
    @Luis Moreno  Hi Louis - Thanks for this input.  I will give it a try once I am able to .​​

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message