Hi Asim, I have added tns details in tnsnames.ora file and I am able to ping TNSNAME and it is getting connect. In RPD level I have called this TNSNAME as DSN name in connection pool. And I have added entire tns name as DSN name but it is not working. Thanks, Ramesh

Hi Gianni, Schedule time is 10:00 AM only but if the file size having more than 400 KB , that mail I am receiving at 10:00 PM. I didn't find any logs because agent trigger successful.

Dear Asim, it is already increased. Thanks, Ramesh

Hi, I have applied below filter condition Filter Condition 1 "TIme.Date" BETWEEN TO_DATETIME('@{From_Date}{2017-09-10 00:00:00}','YYYY-MM-DD HH24:MI:SS') AND TO_DATETIME('@{To_Date}{2017-09-20 00:00:00}','YYYY-MM-DD HH24:MI:SS') Filter Condition 2 AND abs(TO_DATETIME('@{To_Date}{2017-09-20 00:00:00}','YYYY-MM-DD…

thanks it was resolve

Thanks Gianni, Will you pls provide any sample document links? Thanks,

thanks for your support

Thanks for your help. Almost it reached, but it is showing only 6 days data. Thanks, Ramesh

Hi, My requirement is, If I select any date in the calendar, it should fetch 7(one Week) days back data from selected date. For example If I select 8-JUL-2017, the report should show from 1st July To 8th July. The below condition providing 7 days back data and up to current data. "Times"."DATEMAKE"…

Thanks, Christian and Sanket

Hi Sanket, Yes , I am giving rpd password not weblogic user password. I will try with weblogic password once. Thanks, Ramesh

bitools> data-model-cmd.cmd downloadrpd -O liverpd.rpd -SI ssi -U webogic -P Admin123 Thanks, Ramesh

Yes I am using only weblogic user

Hi MM, Thanks for your update. But I need more clarification or if u share any doc also it will helpful. Where I will get that "Invoke a web service" option in BIP jobs. actually it available in while creating new data model we can select web service. Please provide some clarity on this. Thanks Ramesh

Hi Sagar, How can I get script?. "The schema set up script should help identify the expected contents of the tables." Thanks, Ramesh

Hi Joel, Yes. It was working when we create new job. We are facing this issue only in old jobs but it was not continuously. Thanks, Ramesh.

Hi Sagar, I have just rename that agent, it was trigger successful. All agent running from 2015 on wards but recently we are facing this issue randomly. We have around 350+ agents. those agents trigger daily and monthly. How to avoid this issue permanently?. Thanks, Ramesh

Hi Thanks, Final Query TimeStampAdd(SQL_TSI_SECOND, "ServiceDesk"."A_Call_req"."open_date" , TIMESTAMP '1970-01-01 00:00:00.000')

Hi, I have tried but I am getting below error Function TimestampAdd is called with an incompatible type TimeStampAdd(SQL_TSI_SECOND, "ServiceDesk"."A_Call_req"."open_date" , '1/1/1970 05:30:00 AM') Thanks, Ramesh

Hi Christian, Thanks for update. Please suggest how to restrict those things(recent and most popular) and how to restrict that dashbord, because I have verified dashbord level permissions but I didn't found anything. Other AD ID's not accessing that dashboard but only my AD ID getting that dashboard. Thanks, Ramesh.