Does 'REGR' function work in Data Visualizer (OAS version 7.0)?

Dhaval Parikh Stantec

We are trying to use 'REGR' function in Data Visualizer (OAS version 7.0) but it does not seem to be working. It is working fine in BI Answers (Classic) though. Can someone please comment if this function is supported in data visualizer (OAS 7.0) and if not in this version, is it supported in the current version of OAC?

Mostafa Morsy-Oracle

Are you getting Error Like

Failed to download metadata for
'USERID'.'obiee.Regression'

Dhaval Parikh Stantec

@Mostafa Morsy-Oracle Yes that's exactly the error we are getting

Mostafa Morsy-Oracle

This will not work in data visualization according to known bug : 34982574  But you can try the following workaround it may work

1- Install R and R package according to the following OBIEE 12c documentation in
OAS7 .1 Installing R and R Packages https://docs.oracle.com/middleware/bi12214/lcm/BIEIG/GUID-9094BFE3-0B41-40AD-83F5-23E0A2D7229F.htm#BIESG9377

2- Make Sure The obiee.Regression.xml file is existing in following directory in OAS.
ORACLE_HOME/bi/bifoundation/advanced_analytics/script_repository/obiee.Regression.xml
The R packages can be see from /usr/lib64/R/library/OBIEEAdvancedAnalytics directory.

3- install Libraries required for ML https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/installing-product-software.html#GUID-8CF4BF0C-2888-4D86-BB02-713006EA6963

Dhaval Parikh Stantec

@Mostafa Morsy-Oracle Thank you so much for the workaround! Will try this and reach out to you if I come across any issues