Cognos Analytics

 View Only
  • 1.  Crosstab unmerge cells

    Posted Wed July 07, 2021 02:40 AM
    Hello community,

    We have a report in Excel format which holds a crosstab with multiple hierarchies on the left-hand axis. Here is an example, (Year, Month, Day are the hierarchies):

                                      Mesure1
    Year1 Month1 Day1  data1
                           Day2  data2
              Month2 Day3  data3
                           Day4  data4
    Year2 Month3 Day5  data5
                           Day6  data6
              Month4 Day7  data7
                           Day8  data8
       
    In the Excel sheet we wish to display the categories unmerged, so that every row would display the year and month.
    Any hints of how to achieve that in Cognos 11.1.7?

    Many thanks.

    ------------------------------
    Ori
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Crosstab unmerge cells

    Posted Wed July 07, 2021 03:18 AM
    There is an option on report level. Set 'Group repeating cells - export to Excel' to No.

    ------------------------------
    Thomas van der Meer
    ------------------------------



  • 3.  RE: Crosstab unmerge cells

    Posted Wed July 07, 2021 06:49 AM
    Works perfectly. Many thanks.

    ------------------------------
    Ori
    ------------------------------