If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

csv repeating cells

Started by nayitian, 25 Jun 2008 10:58:27 AM

Previous topic - Next topic

nayitian

Hi All,

I have an another problem, hope can have your help.
The csv file which is exported from version 7 powerplay has duplicating values repeated, but when I export csv file from 8 Analysis Studio, they are not.
   
  C7                             C8

2008  Jan ...            2008 Jan ...
2008  Feb ...                   Feb ...
2008  Mar ...                   Mar ...

How could I have '2008' repeated while exporting from C8 ?
Thanks.

whatever890

In 8.4, go to System and on each Report and Batch service, add the following to the Advanced Settings:

RSVP.CSV.REPEAT_XTAB_LABELS  = TRUE

cognos_learner

Hi, i need help in this too.
Currently using Cognos 8.3, how do i output crosstab report with nested rows/columns from Analysis studio to excel, with repeated rows & columns in excel?
Right now it's appearing like that:
C8.3
2008 2008P01
        2008P02
        2008P03

I need excel to be
2008 2008P01
2008 2008P02
2008 2008P03

Any advice?