Hi Prakash. Sometimes we change the default data source connection of the Data Model but the Data Set may still point to a different one. Just checking. Fernando

Hi Prakash. If you edit the data model and click View Data how many records return (if you set the Rows = 200)? 81 or 94? Can you see the active connections on the database side (A and B) ? Like querying the V$SESSION table? Cheers. Fernando

Hi Carlos. Suggest investigate BI Publisher logs. Maybe increase the detail of the logs for a short period of time. Configuring Log Files Let us know if you find something. Cheers. Fernando

Hi Carlos. Just checking. What about the Data Sources used by those reports that are failing? Do they have the Allow Guest Access checked? Is the last item on the doc you provided Grant access to the data sources used by data models in your Guest folder. See Setting Up Data Sources for information on granting Guest access…

Hi Reddy. I don't think it is possible to add Conditional Watermark on RTF templates. I can see two options. 1. Use a conditional construction (if-then-else) to Add the information in BOLD on the header of you document OR 2. Use a combination of conditional and SubTemplates to build the desired output. Cheers. Fernando

Hi Patrick. It is possible to change the data model of a report yes. Edit the report and select the new Data Model on the top left corner. Just a very important note: - The New Data model must have the same output as the previous one or your template will get lost when reading the data. Cheers. Fernando

Hi Lenin. Ok. From the troubleshooting PDF you can see the following on Troubleshooting section "What do I do if the app can't connect to the server?" If the page doesn't open in the browser, then use Oracle WebLogic Scripting Tool (WLST) to verify whether the BI Majel application is running. If the application isn't…

Hi Lenin. Can you elaborate a little more on what doesn't work? It doesn't open or connect? Did you check the Troubleshooting part of the PDF you added in your post? Especially these points. * What do I do if the app can’t connect to the server? * What do I do if search doesn’t auto complete search keywords or display any…

Hi Lenin. I did an OAC trial consuming data on premisse. The best option for me was to use VPN as a Service. Setting Up a VPN Connection Using VPNaaS You first need to create the VPN and configure inside a cloud IP Network. After that you have to create a new OAC instance inside that network. As far as I know is not…

Hi. Another message on the RCU.log file. Was the database up and running? Tue Sep 4 13:43:33.590 UTC 2018 ERROR assistants.rcu.backend.action.JavaAction: oracle.sysman.assistants.rcu.backend.action.JavaAction::perform: ERROR - RCU-6131 Error while connecting to the database.CAUSE - RCU-6131 An error occurred while…

Hi Lenin. Quick look at setupBICS.log and you can see on line 2854 the following error. "RCU-6131 An error occurred while connecting to the database" it was while executing Repository Creation Utility. Make sure the user and password provided are correct. Question. On which database version are you creating your OAC? I…

Hi Lenin. You can also find more details navigating to your cloud storage and downloading the provisioning logs. Follow this link Troubleshooting Let us know your findings. Cheers. Fernando

Hi Luke. If this is a BI Publisher Report inside an OBIEE Dashboard you will need to apply the changes described by Yguttikonda. If I understood correctly, based on the image, part of the parameters are not being populated right? If it is a standalone report then some questions for you. Does the same behavior happens when…

Hello Robert. I don't think you can do that with Oracle DV Desktop. If you are using Oracle DV in the Cloud you can embed your VA project in a Dashboard and use agents to deliver based on a condition. Another way is, maybe, develop a plugin for it. Here some examples Data Visualization Extensions Best Regards. Fernando

Hello Satya. I think this question should be in another forum. You should try to move or post this question on this forum Developer Cloud Service Forum Regards.

Hi Bhanu. I'm assuming you will transform your Prompt to bring NULL if ALL is selected. If that is the case check the post below Handling null values in bi publisher rtf template Hope it helps. Cheers. Fernando

Hi Bhanu. The issue is clear. You are passing to many values as parameters. Try the following construction. 1. Modify your parameter to pass NULL when ALL is selected. 2. Modify you WHERE clause to work with the NULL this way. WHERE (<table_column> in (<yourparametername>) or (<yourparametername> is null)) Save and let us…

Hi Joe. I think if you have your instance within an IP network and that network integrated with VPNaaS you will be able to achieve that. Search for this. OAC: How To Setup a VPN Connection for Oracle Analytics Cloud Using VPNaaS (VPN as a Service) (Doc ID 2355623.1) I did an OAC trial consuming data on premise and started…

Hi Pradeep. Interesting information on that DOC. Which version are you in OBIEE/BI Pub? Please let us know if you applied the workaround and if that worked. Best Regards. Fernando

Hello Pradeep. Just checking. Did you added the Roles or Users to the new Data source in the security tab when creating it in production? Edit the data source and go to the bottom of the page, Security section. Regards. Fernando