Thanks Robert, I tried something like below using presentation variable set to Prompt1 and using it in Prompt2 it works, But in this case when a value is selected in Prompt1 it will not reflect in Prompt2 unless clicked on Apply button and the report starts loading data before Prompt2 gets applied. SELECT distinct…

I did try using presentation variable and its not working as expected, In here the 2nd prompt have to be mandatory field if i use presentation variable. My requirement is Prompt1 Prompt2 Can Can 2003 IND Can 2018 UK Can 2001 IND 2000 IND 2012 So Once a region Can is selected in Prompt1, Prompt values should be related to…

Hidden request is something like conditional reporting i have to implement is it ? or How to set main request to use the hidden request as a filter ? Am sorry i didn't get.

Thanks Thomas for you insights. The requirement is Main report has a drill down report or a detail report. Users will be able to view the report through email as recipients of Agents/i bots and not through login to obiee every time. As a result Users want to see both reports(main and detail) during export pdf/excel or…

How to handle the drill down reports when Agents/iBots are scheduled to the Main report to the Users emails ? As only Main report gets delivered pdf/html.

Is there a way if i can get the drill down report (the 2nd report as mentioned above which is my detail report) to the dashboard along with Main report split by 2 sections. ?

Oracle Business Intelligence 12.2.1.2.0 and it didn't prompt for any shortcut during installation. For now i dragged shortcut and pinned it to start Menu as per the doc you shared me. Thank you Syed

Can anyone please guide me if i can get the OBIEE 12c services start, stop, runcat.cmd etc as shortcut in All Programs Windows system.

Thanks George, I found it in the installation folder with below location and am able to open it through runcat.cmd C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin Could you please tell me if there is a way to use this cmds as shortcut in All Programs.

Thank You @Gianni Ceresa

Thank you @P G

I worked fine after the system restart!! Thank you all for the replies!!

When i tried to upload a different RPD it gave me this error. Also nqsserver.exe has stopped working and i had to closed it. Which log i need to check now?? C:\OBIE12C\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin>data-mode l-cmd.cmd uploadrpd -I D: \12c_RPD\OBIEE.RPD -SI ssi -U weblogic Password: RPD…

Thanks for the response!! I got the message which RPD download completed successfully. Please let me know which log files i need to check.

Hi All, Can any one please help if there is a workaround for this cache issue during sorting or is it OBI BUG. I am working on OBI 11.1.1.7.150120 version. Thanks in advance LonaD

I now could debug on above explained behavior as why the dates hit cache, because every time when the report results data in table or pivot format. The report on mouse hover the column has a ascending/descending option. If for any Eff_to date value i do an ascending/ descending in the report, and then clear the prompt…

I thought since those have specific error code we have a set of solution involved to solve them. Do we have something of that sort? If yes could you please help me on that??

This helped, now its working fine. Thanks a lot Chris.