Tuesday, July 5, 2016

Advanced Analytics in Oracle DV

Yes, Oracle DV gives you advanced analytics literally at the click of a button. Advanced analytics operations such as clustering, outlier detection, trend lines and forecast are built-in, and they can be simply dragged dropped on to your charts.

However access to advanced analytics is not limited to these functions exposed in the UI. You can leverage the advanced analytics framework to invoke any custom R function and seamlessly blend its results with rest of your analysis. The EVALUATE_SCRIPT function of Oracle DV can be used to execute an R script registered in the script repository.  Its powerful and easy to use.
For example, this video shows an example of using custom R script to decompose a time series data to its seasonal, trend and remainder components.




Following video is another example where use R to perform market basket analysis (rule mining) on fast foods transactions data.



Take a look at some of these examples downloadable from Oracle DV samples page on OTN.

Are you an Oracle Analytics customer or user?
We want to hear your story!
Please voice your experience and provide feedback with a quick product review for Oracle Analytics Cloud!
Posted by at

2 comments:

Unknown said...

the graphs show me a query error:
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
(HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)
State: HY000. Code: 47092. [nQSError: 47092] The value of R_EXECUTABLE_PATH is set to C:\Program Files\R\R-3.1.1\bin\x64\R which is invalid. (HY000)
SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT
0 s_0,
XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP" s_1,
EVALUATE_SCRIPT('filerepo://obiee.TimeSeriesDecompose.xml','seasonal','metric=%1;series_date=%2;',XSA('weblogic'.'ORCL_STOCK')."Columns"."CLOSE",XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP") s_2,
REPORT_AGGREGATE(EVALUATE_SCRIPT('filerepo://obiee.TimeSeriesDecompose.xml','seasonal','metric=%1;series_date=%2;',XSA('weblogic'.'ORCL_STOCK')."Columns"."CLOSE",XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP") BY ) s_3
FROM XSA('weblogic'.'ORCL_STOCK')
FETCH FIRST 5000001 ROWS ONLY

do you know why? i saved the .xml file in the correct folder anyway.

March 12, 2019 at 6:50 AM
lost_in_woods said...

nice blog , very helpful and visit us for VISUALIZATION SERVICES in USA

July 9, 2019 at 10:50 PM

Post a Comment