Hey Anirban, Any MV you create will show up as a normal table in RPD. Nothing special is required for the same. Regards, Siddharth Dang

Hi Ram, Try this please at your end. Check if the agent that is being scheduled is already scheduled or not by any other user. If yes, then check run as user value. If it is a particular user set, then change it to whosoever is running the agent. I remember we also faced a similar issue. We tried a bunch of different…

Hi Ram, OAC is a multi-noded environment and sometimes the agent session does not show all scheduled or running sessions from all nodes. Try checking after sometime. Regards, Siddharth Dang

Hi Saurabh, This could be because of Credentials expired of the native IDCS user. Please log in to IDCS using the user created and see if the credentials have expired or not. If yes, then reset it. It would start working. The second scenario when this happens is if someone has already opened in cloud mode. Then also you…

Hi Saurabh, Is the alignment of content defined inside tables? if not then the format will change according to the formating of email applications like outlook and web browsers. Defining specific sizes of tables and layouts and putting objects inside tables help you control the layout of the output even in mails. Hope this…

Dear Saurabh, One easy solution to your requirement would be to read the folder path of the object being run and segregate the object based on the project folder path. Exam - A DV, Classic report placed in folder project a would be of project a whereas an object called from folder project B will be of project B. This can…

Hi Saurabh, I am not sure about OAC. However, we do have a document available for OAS. As both the systems are nearly equal, this should help you. https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/predefined-fonts.html Also, you can look at the master CSS file of OBIEE via inspect element…

@Sahithi Kolasani-Oracle We don't want decoded data to be able at the database level. Only specific users should be able to see data through OAC only. Once encrypted not even admin should be able to decrypt data. Can we pass a password-like value from OAC to showcase decrypted results? else everything will remain encrypted…

Changing OJDBC files is not recommended. We need to use the original jar as part of the binaries. Apply buddle patch to upgrade to new OJDBC Jar file. Regards, Siddharth Dang

Hi Wayne, In OAC only classic and DV queries are stored in usage tracking. BIP usage tracking is not stored in the Usage tracking tables. Regards, Siddharth Dang

Dear Saurabh, Please check the OJDBC jar file being used by your ODI. ADW requires at least OJDBC8.jar for proper connectivity. Regards, Siddharth Dang

Dear Ankit, Currently, the recommended way to extract data from CPQ is using data cube extract. It will extract data in a remote SFTP server in the form of a text file. Use any ETL/ELT tool to inject into a data warehouse. Check out the doc on oracle support to help you further. -> How To Set Up a Data Cube Export (Doc ID…

Yes, the breadcrumbs-like functionality should be added. It was the best option while using drill functionality.

For all customers currently looking for dynamic workbook filters, this would make their lives easy.

Example : FILTER(<my measure column name> USING <my dim> IN ('@{<variable name>}{2021}'))

@Michal Zima After reading your comment, I went back to one DV/Classic dashboard combo that we created for one of our customers, and yes you are correct it is not working. We created this scenario in OAC 5.4. Although, post checking the query generated by OAC DV still understands the presentation variable context but we…

You can also use presentation variables in DV. The workaround here is to create a canvas and embed it in a classic dashboard. then create prompts in classic and use them to pass values in DV projects. The only limitation here is that you need to pass the filter in a custom column using the filter function. Regards,…

Indeed a must-have feature. We have multiple OAC instances. Managing OAC resources like backup and migration is a challenge for us. Having rest calls would be a great enhancement to OAC management. Regards, Siddharth Dang

Currently we cannot use presentation variables in DV. This will enable the end user to customize the reports to greater depths. Presentation variables also help in creating dynamic content.lack of them forces us to create the same report in Classic side

this can be used to test reports and their respective data between environments. we can also use this to test reports post upgrades of OAC/OAS