Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

When you import the cube into the RPD the SubVars for that cube will show up as Dynamic Variables I usually create a separate database and connection pool with imported cubes just for SubVars and have the Service Account get the values. then delete the variables for the cubes that are for the dashboards since that…

in Extracting Substitution Variables from cube using RPD Comment by Wayne Van Sluys Oct 23, 2024 5:34PM
Usage tracking is tied to Answers and Dashboards. It will tell what was run and by what user. BI Publisher has its own tracking which is what was discussed in the link you provided.

in Is there a SQL query that will show when last a BI Report has been run by a user? Comment by Wayne Van Sluys Oct 18, 2024 10:11PM
For BI Publisher you need to enable monitoring and auditing then you can query the tables as the post indicates.

in Is there a SQL query that will show when last a BI Report has been run by a user? Comment by Wayne Van Sluys Oct 18, 2024 10:08PM
Unfortunately no way that I know of. I do not think Session information is going to log files in weblogic or fusion middleware.

in Is there a SQL query that will show when last a BI Report has been run by a user? Comment by Wayne Van Sluys Oct 18, 2024 9:55PM
Do you have Usage Tracking Enabled?

in Is there a SQL query that will show when last a BI Report has been run by a user? Comment by Wayne Van Sluys Oct 18, 2024 9:39PM
Are you doing this in DV or Classic Answers?

in Oracle Analytics - Line + Tabular Combined Chart Comment by Wayne Van Sluys Oct 10, 2024 3:19PM
In your Pivot duplicate the column you want to have Running Sum, then on duplicate Select Display as Running Sum

in How to get a running aggregate for the last 12 months Comment by Wayne Van Sluys Oct 3, 2024 3:41PM
Thanks Mike. Good stuff.

in Announcing the Oracle Analytics Developer's Guide Comment by Wayne Van Sluys Oct 2, 2024 5:52PM
There is Usage Tracking There is also Audit Logging Check these blogs from Oracle Logs to ADW - May 24, 2024 https://blogs.oracle.com/analytics/post/insights-of-oracle-analytics-cloud-usage-via-oci-logging Logs to JSONADW - March 21, 2023…

in Can I see how many users viewed my graph with the oracle cloud analytics API Comment by Wayne Van Sluys Aug 22, 2024 9:12PM
there is usage tracking and audit logging Logs to ADW - May 24, 2024 https://blogs.oracle.com/analytics/post/insights-of-oracle-analytics-cloud-usage-via-oci-logging Logs to JSONADW - March 21, 2023 https://blogs.oracle.com/analytics/post/access-oac-logs-with-oracle-cloud-infrastructure-logging Logs to .csv - June 13, 2022…

in Can I see how many users viewed my graph with the oracle cloud analytics API Comment by Wayne Van Sluys Aug 22, 2024 4:37PM
check out these three blogs from oracle Logs to ADW - May 24, 2024 Logs to JSONADW - March 21, 2023 Logs to .csv - June 13, 2022…

in OAC Audits logs for workbook deletions Comment by Wayne Van Sluys Jul 12, 2024 4:06PM
The July update allows for it. See here https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/#GUID-CFF90F44-BCEB-49EE-B40B-8D040F02D476

in How can I conditional format totals and subtotal amounts in OAC? Comment by Wayne Van Sluys Jul 8, 2024 9:32PM
What date will be in the Email_Date, Person_Date and Student_Date?

in How to create new filed using date column in obiee Comment by Wayne Van Sluys Jun 18, 2024 3:20PM
Then based on your statement... "If the condition is not satisfied then it shouldn't bring the data which doesn't satisfy the date condition" This logic should be in the data model query not in a report rendering. What is source database as SQL logic is different?

in Good Morning, I have to handle certain date logic in the RTF template. Comment by Wayne Van Sluys Dec 11, 2023 4:53PM
When you created the instance you should have created a SSH public/private key. use that in your ssh tool with user opc

in after creating a new oracle 8 linux instance, it asks to login Comment by Wayne Van Sluys Dec 8, 2023 7:00PM
Logging into OAS or Logging into the Linux instance?

in after creating a new oracle 8 linux instance, it asks to login Comment by Wayne Van Sluys Dec 8, 2023 6:22PM
This is great. Is there a Rest endpoint that we can connect to download or connect to via OAC Rest connector?

in Monitor OAC through the OCI Logging Service Comment by Wayne Van Sluys Nov 30, 2023 5:29PM
This is great. Is there a Rest endpoint that we can connect to download or connect to via OAC Rest connector?

in Oracle Analytics Cloud log insights via the OCI Logging Service Comment by Wayne Van Sluys Nov 30, 2023 5:28PM
Would Data Actions work for you ?

in Creating a table column as a hyper link Comment by Wayne Van Sluys Nov 29, 2023 9:14PM
One option is to create a new dataset via Data Flow. There is Union within Data Flow

in Union Reports build in OAC Data Visualization Comment by Wayne Van Sluys Aug 24, 2023 3:51PM

More Comments

MFA for Oracle Community

Welcome to the Oracle Analytics Community

Wayne Van Sluys Mod

Comments