Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Yes, it's working for me now.
-
Similar to Dawn, when I click the link I get this message
-
Here's a link to a previous post/discussion about using EVALUATE. It also contains a link to a website with some examples
-
here is an example showing a fully worked demo in SQL You'll see the code used to convert UTC to local in the SELECT SQL> CREATE TABLE imported_events (event_date TIMESTAMP(0) WITH TIME ZONE); Table created. SQL> BEGIN 2 INSERT INTO imported_events VALUES ( '10-JAN-08 2:00:00 PM UTC'); 3 INSERT INTO imported_events VALUES…
-
Great example of what's possible.
-
Great video demoing whats possible
-
If the inbuilt function doesn't give you what you want, then you'll need to explore one of the other options (see previous posts) to see which works for your scenario.
-
Great work on the video
-
yes use the PERCENTILE functions can be used or use the pl/sql package DBMS_STATS_FUNC.SUMMARY()
-
This is the plug-in that is needed for what's shown in Ben's blog post:
-
As others have indicated, you'll probably need to use other tools first before bringing in the results for presentation in OAC. Depending on the complexity of analytics you want to do, some of those might be available in the Database (stats, ML, graph, spatial, etc). If you need to do more, you could use OCI Data Science.…
-
Nice addition
-
Highlighting the importance of the User Community on this Oracle Analytics Community website, as well as User Groups, Corporate and other Knowledge Sharing events.
-
Great achievement. Maybe an interactive map for the next milestone update
-
Have a look at this previous post, which seems to cover something similar https://community.oracle.com/products/oracleanalytics/discussion/21283/upgraded-from-obiee-to-oas-scheduled-job-running-but-cannot-find-it
-
Can the poll be altered to allow us to select multiple data sources? Snowflake, Redshift, Databricks
-
Good, clear, well-spaced layout. As others have said, the QR code is a useful addition.
-
Try this SELECT NEXT_DAY( TRUNC(to_date('21-MAY-2025'), 'MM') - 1 , 'Sunday' ) FROM dual And depending on your version of the DB you no longer need the 'FROM dual' 😀
-
The Redwood Theme can be enabled by following the steps in this https://docs.oracle.com/en/cloud/saas/applications-common/24d/oaext/configure-redwood-themes.html
-
Check out this video https://youtu.be/TcB4sfE7H9U?feature=shared