Cognos Analytics

 View Only
  • 1.  Crosstab Space Tool

    Posted Thu October 03, 2019 04:06 PM

    Hi All,

     

    I'm having some trouble putting more than one crosstab space on the same row, it keeps creating a new row, any suggestions? Is this a bug?

     

    Thanks

    Heather


    #CognosAnalyticswithWatson


  • 2.  RE: Crosstab Space Tool

    Posted Fri October 04, 2019 03:19 AM
    Edited by System Fri January 20, 2023 04:41 PM
      |   view attached

    Hi Heather,

    you can have several cross tab spaces in a row, side by side.
    It needs a bit finesse to do so.

    Here's a sample build in Cognos Analytics  11.1 using GO Sales (query). It mainly follow the steps described in this Technote:

    How to add column titles for crosstab without using tables in crosstab corner

    Instead of placing the qiery items in the spacer you are also able to use the automatically added text items (comes with the spacer) and enter your title name as needed.

    When you build your report on DMR or OLAP sources using the Report Option "Automatically create crosstab headers for sets"; see:
    Creating headers automatically for sets in crosstabs
    Hope this helps



    ------------------------------
    Gertrud Lohwasser
    ------------------------------



  • 3.  RE: Crosstab Space Tool

    Posted Fri October 04, 2019 08:05 AM
    @Gertrud Lohwasser
    Thanks Gertrud, I appreciate your response, that did work, however, this seems more like a work around than a solution because then you can't see your corner measure in the report and it's a lot of extra steps instead of the drag and drop that used to be available. Do you know if there are any plans to revise how this is done? ​


    ------------------------------
    Heather
    ------------------------------