COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => SDK => Topic started by: kenny on 04 Nov 2010 12:22:19 PM

Title: Retrieve all parameter values
Post by: kenny on 04 Nov 2010 12:22:19 PM
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!
Title: Re: Retrieve all parameter values
Post by: jdzurek on 06 Oct 2011 10:56:27 AM
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 (http://www.ibm.com/developerworks/data/library/techarticle/dm-0808sleigh/index.html)

j