Hi Gianni,

If i invoke it in the web page with hardcoded parameter value 2009 than i can get my Excel sheet download with 2009 records,

if i pass the url directly with the value like below

http://remco.biapps.com:9704/Application11-ViewController-context-root/jersey/2009

But instead if i pass the value @ runtime then it is not resulting in a value

http://remco.biapps.com:9704/Application11-ViewController-context-root/jersey/{year}

Normally i would pass year value in a braces to give {year}, year in runtime, but when i tried to give the url like above and define parameter with a parameter name like year and value to 2009, it is not taking the value 2009 and it is downloading excel without any values.

How to pass values @ the run time within BI for the year.

Thanks,

Regards,

Saro

Dear Gianni,

Where is this action set?

>> I just created this action set directly and executed it from the saved catalog.

Where does the year come from?

>> As of now im giving the year directly as a value in the parameter box in the action set instead of giving it in the url directly.

You mean you have that in an analysis which also contains the year column?

>> As of now i dint bring an analysis, just checking directly by creating the action set.

You want to use a presentation variable?

>> As now i dint use to pass the value from the prompt, even if i used i dont think we can use presentation variable for my prompt because

the action set parameter values accept either a direct value or session variable or repository variable.

Normally the generated URL as a part of my code compiled in jdeveloper is below

http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/{year}

where {year} is the parameter value where i will normally pass a year while checking it in the browser window like below

http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/2009

Ill replace {year} with the value 2009 in the browser to check whether the download is working fine or not and it works well as the download will happen.

Now in BI i need to invoke the above URL and hence for this like you said i created and checked with navigation to webpage in which i gave the below URL in the URL box: http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/2009

In the above case in BI, I gave the value directly as 2009 and saved the action and while executing the action from my saved catalog, it is downloading the excel with all values related to 2009 and that is fine.

What i did is inorder to check with the run time parameter value instead of hardcoding i changed the url in my webpage actionset in bi to below

http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/{year}

and in the parameter box i specifed parameter name as year and in the value i gave value directly as 2009. After this if i execute this action and check means it is downloading the excel but it is empty and from this it is clear that parameter value is not getting passed.

Regards,

Saro

Gianni,

If thats the case then i need to change the URL interms of accepting query part like something

http://172.16.2.85:9704/Application11-ViewController-context-root/jersey?

so that i can subsitute year paramater for the above query part of my URL. Is my understanding is correct.

Saro

Thanks Gianni,

After changing the URL to below from the webservice side, i can pass the parameter value in the parameter box of my action set and can get the results in the excel download.

http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/excel?year=@{year}

My next challenge is i need to pass this year value from the prompt, in which the action parameter value box has the option of giving(direct value or session variable or request variable). I hope i gotto try with the request variable. Not sure whether the presentation variable will work or not. Gotto check.

Thanks for your valuable idea:-)

Regards,

Saro