Finding my SQL statement
I have created my first visualization in DVD and I want to see what my sql statement looks like. Is this available in DVD and if so can someone point me towards where I would find this information?
Thanks!
Hi,
Have a look in C:\Users\<your username>\AppData\Local\Temp\DVDesktop\logs\OBIS
You have the logs of DVD there and in one of the files the queries (the file with the queries is obis1-query.log )
It's well hidden
But it's also there that you find all the logs with more info when having an error somewhere ...
If you got what you looked for you can maybe close the thread as it will help others too.
Thank you! I looked everywhere, except the folder
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
