Repeat attributes in a cross tab

[wyconian]

Hi

I've got a cross tab where the first attribute is country.  As you'd probably expect the cross tab is grouping on this attribute and not repeating it. 

Does anyone know how to get the attribute to repeat?  I don't think this is possible in a cross tab (I'd use the group span property in a list but it's not available in a xtab). 

Can anyone prove me wrong?

As always thanks for your help.

[blom0344]

Why do want it to repeat? The point of the crosstab is to roll up the facts against row and column objects.

If it would repeat what do you expect from the crosstab body?

Please shed some light on this..

[wyconian]

Thanks for the response.  I realise this is a bit of a naf requirement but it's what my client is asking for.  I think they want it to repeat so that it would be easier to see in excel and then they could sort on the the repeating column.  They still want the measures to be rolled up to the country level but they want the country column to be repeated against every row for the other attributes in the report.

Part of the problem is that I've done this for them in a list by grouping on the country column but then either changing the group span to the lowest grouping level or by adding  the same column to the report again but not grouping on it.  Obviously the group span option isn't available/appropriate in a crosstab.

Any ideas?  I've already told the client I don't think this is possible in a xtab.

[praviin]

Please find the details

New to Cognos 8.2 is an advanced parameter for the Report Service and Batch Report Service that outputs CSV with repeating crosstab labels (normally suppressed with nested rows).  This parameter must be set for all Report and Batch Report servers in the environment.

Steps:

  1.  Go to Server Administration within Cognos Connection.
  2.  On the Monitor tab, select the Services radio button.
  3.  Click the Properties icon for Report service.
  4.  Click the Settings tab.
  5.  Click the Edit link under Environment's Advanced settings.
  6.  Select the Override the settings acquired from the parent entry checkbox.
  7.  Add the following parameter and value:

        RSVP.CSV.REPEAT_XTAB_LABELS          TRUE

  8.  Click OK, and OK again to save the change.
  9.  Repeat the steps above for the Batch Report service.
  10. Wait 30 seconds for the new settings to take effect.
  11. Open Analysis Studio and run a report with nested rows as CSV (selecting Open when prompted by the popup window).

The output should include all rows without the default auto-grouping

Thanks
- Praveen

[wyconian]

WOW

Thanks for that.  Will that change the way all xtabs work or can it be report specific?

[blom0344]

If all they are after is a way to sort in Excel, you can also created a derived column that holds the country concatenated with the attribute of the lowest grain.
As this is still unique ,but starts with the country it should be a perfect sort candidate. Bit of an artificial solution maybe, but should do the trick..