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

Retrieve all parameter values

Started by kenny, 04 Nov 2010 12:22:19 PM

Previous topic - Next topic

kenny

Hi @all!

I'm new at cognos SDK and I found a lot of helpful topics in your forum  :)! But now I have a problem which I couldn't solve
for three days and found no help in the internet (I used google a lot). Maybe you can help me, I would be very grateful.
(My Boss wants a solution within 5 days  :( )

(Please excuse me, if my English is not 100% correct  :-[ .)

I run a report and save it as a PDF-File. This report contains a parameter (in this case "Year"). If I set a value for this parameter in
the sourcecode (for example "2004") everything works fine. But the report has to be run and saved for every possible value. In this
report there are just 4 values (2004-2007) but my solution has to work with other reports, too, which contain 3000+ possible values.

So I want to retrieve all parameter values, write them in an array and let the report run once for every value. I am able to retrieve
the modelFilterItem (e.g. "[Sales (query)].[Time dimension].[Year] ) but I'm not able to get it's values.

My question is: Is it possible, and if yes, how, to retrieve all values?

Thank you very much!

jdzurek

Hi,

Just off the top of my head, it might be worth your while to look at the Validation Tool. Here they validate report parameters and to do so they must retrieve a list of report parameters and set the values to dumby values to continue with validation.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0808sleigh/index.html

j