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

Offline Cognome

  • Associate
  • **
  • Join Date: Jun 2019
  • Posts: 2
  • 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.

Offline Cognome

  • Associate
  • **
  • Join Date: Jun 2019
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Writting down parameter values to Excel
« Reply #1 on: 26 Jun 2019 09:01:31 am »
Hello again,

I've came up with a solution to the problem. You can use Repeater (Not Repeater tables) to write down normal text or and prompt values to Excel.

  • For text value - I just added expression to the Repeater. For Instance: 'Retailer Country prompt Values: '
  • For prompt value - since I have multi-select prompt, I could not use parameter values directly in any shape or form. I had to create a separate query with the filter that uses the same parameter as the one in the main query. Then I just added the [Retailer Country] to the repeater and added - + ' ' - to have some space between the values.

That's about it. If anyone needs more information, let me know.

 



       
Twittear