Author Topic: Writting down parameter values to Excel  (Read 24 times)

Offline Cognome

  • Associate
  • **
  • Join Date: Jun 2019
  • Posts: 1
  • Forum Citizenship: +0/-0
Writting down parameter values to Excel
« on: 14 Jun 2019 09:10:20 am »
Hello everyone,

I've got a relatively simple problem. I need to import a report from Cognos to Excel via IBM Cognos for Office - report has cross-tab and lots of prompts including multi-value prompt. I can easily import cross-tab to the Excel but unfortunately I can not add Text nor Report Expression to write down prompt parameter values - since IBM Cognos for Office wont show me Report Expression values in Excel. I've also try to make Data Item that would take prompt parameter values but that does not work for multi-value prompts since using that Data Item in the report will enforce single-value on a multi-value prompt.

So I'm looking for a way to import not only cross-tab from my report, but parameter values as well.

Any advice would be appreciated. If you need more info, let me know.