I tried this.Below is the solution which worked for me.Thank you. CAST('25-JUL-'||CAST (YEAR (CURRENT_DATE)-1 AS CHAR) AS DATE)

Sure.Thanks Gianni. Can we pass any variables as part of http headers or URL query parameters to this Webservice?? Which can later passed onto the Agent.

Gianni, I am trying the find the solution for our scenario.If you think there is alternate way,Please let me know. How can i pass values to agents dynamically? Thanks in Advance. R

Gianni, Does that means i have to create 350 agents and pass 1 prompt value to 1 agent.Call 1 agent from other? Some thing like. Agent 1-->Calls Agent 2-->Calls Agent 3......etc...350 or Do i have to schedule 350 agents??. 1 prompt value in 1 agent. Please clarify. I am trying to achieve with 1 agent by passing prompt…

Giani, Thanks for your inputs.I have total 350 input values. How many agents i have to create 350??. Editing agent with webservices,I do not see it in webservices List.

Gianni, I can't save the static value in the agent.because values are dynamic and has to pass it from 3rd party application based on user selection. Below are the same report prompts.

I think we can Achieve it by passing ODI Variable to BI and call BI agent in ODI Package. I would like to try the below process. https://www.ateam-oracle.com/integrating-odi-with-obiee-how-to-invoke-odi-scenarios-load-plans-from-obiee https://community.oracle.com/message/13858142#13858142

Gianni, Our business used to have solution with BO,They are asking us to provide the same solution using OBIEE. I am trying to find the way to make this happen... Thank you, R

Can any body suggest some inputs on this issue?

We followed/Implemented below Doc.But it is working only for one location ID.We would like to generate all Location ID Pdf's based on Location data(Data Level Security). OBIEE 11g: How To Create and Invoke Enterprise Java Beans (EJB) Using The Action Framework (Doc ID 1610118.1). Appreciated your inputs. Thanks, R

Robert, Thanks for your response.This Prompt variable value has to be dynamic.User wants to select these values dynamically.

Ceresa, Thanks for your inputs.we decided to go with cron tab. It seems in OBIEE 12C the below commands changed.It is not like in 11g. app/oracle/biee/user_projects/domains/bi/bitools/bin/nqcmd.sh -d AnalyticsWeb -u weblogic -p XXXXXXXX Can you provide the correct paths and approaches wit nqcmd.sh method to purge the…

Chris, thanks for your update.I'm looking for different options to find out the soluton. We have 5 different reports and each report has 300 different prompt values.Instead of logging to each report and selecting each prompt value,our business asked us to provide obiee URL's which automatically downloads the reports into…

So that means it is not possible to download the report to CSV with URLS..?

George, that link doesn't work for me. the below is our report URL.When the BI user enter the URL on their browsers it should automatically downloads the report. https://salesforcebi.com/analytics/saw.dll?PortalGo&Action=prompt&path=%2Fusers%2F76694598046%2FRcp_attendance_weekly_test&Format=txt&Extension=.csv

Gianni, We have the export link but instead of login to BI select the report parameters and download it into CSV.Our users wants the direct URL which dowbloads the reports into CSV. Reason is:we have 340 reports which has to be exported to CSV every day Each report size is 15 to 20 MB. Thanks Ram

Chris, Thanks for your response.! It is 50,000 records and It is a OBIEE report(not BIP report). Thanks Mike

Cesar, Thanks for your response.Please explain the steps in detail. Thanks R

Chris, Thanks for your inputs.I found the solution.That dashboard is only for fusion users.Our source is EBS-12.1.3. OBIA 11g - Errors In The Buyer Productivity Dashboard Of The Procurement (Doc ID 1569839.1)

Thomas, Thanks for your inputs. If the cache purges based on the dynamic repository variables then all the cache files(.TBL)has to be purged based the variable frequency.But all the cache files are purging in B/W 3 to 5 PM everyday. And we are using OBIA-11.1.1.9.2 out of the box RPD. Thanks R