-
Critical Patch Updates (CPU) and Bundle Patches have been released for Oracle Business Intelligence
Hello Community , The quarterly Critical Patch Updates (CPU) and Bundle Patches have been released for Oracle Business Intelligence 12c ( 12.2.1.4 ) release. Please see: Critical Patch Update (CPU) Advisor For Oracle Business Intelligence - Updated for October 2023 (Doc ID 2832967.2) The patches include critical fixes, and…
-
How to display searching message while Direct Database Query based analysis?
Hello, Wondering if anyone can suggest some ideas to let users know that the Direct Database Query based analysis is still running and they should stop clicking 'Apply' button in dashboard prompt section. We are using on-prem OBIEE 12c. Thanks Amit
-
Disabling Screenshot on Oracle Analytics Cloud.
I have client who have lots of employees from various LOBs who are part of the OAC BI Consumer Group who are taking screenshots of the Reports and dashboard. We would like to disable screenshot on the reports and dashboard. any Setting we can change for this ?
-
how to fetch latest record query in oracle fusion hcm
-
Unable to plot endpoints on LineOnMap plugin on OAS
Hi there.. We have used the Lines on Map Plugin / extension in our project and are able to plot the lines on the map with source and target lat/lon. However, we have the following issues with this plugin, In the LineOnMap Plugin we are unable to mark the endpoints with a separate circle or color. There is no auto zoom…
-
Hierarchy Ordering
Hi Team, Im using OAC and building hierarchy like below I need to sort the above order to below ROOM DEPARTMENT OTHER OPERATING DEPARTMENTS(OOD) F&B DEPARTMENT Is it possible to sort the order or control the order of the nodes in OAC? Regards
-
Can we increase BIP Maximum report data size for online reports
Hi Team, As part of the requirement, payment approval was not being initiated due to the large volume of data. Could you please confirm if we can increase BIP's "Maximum report data size for online reports" from 300 MB to 500 MB? If yes, kindly provide the steps to proceed. Thank you in Advance,
-
Oracle Analytics Server - Installation Failed
Hi, I'm installing OAS 7.6 in RedHat 8.10 but the config.sh script failed at 77% of the installation process. I would appreciate any help you can give.
-
Incorrect Difference from Two Calculations
Hello, I am using Oracle Analytics Desktop and attempting to get the difference of two calculations as follows: Calculation 1: COUNT(CD_CUSTOMER) = 1,064,910 Calculation 2: COUNT(CUSTOMERNUMBER) = 526,568 To get the difference of these two, I am dragging and dropping them into a new Edit Calculation window which pastes as:…
-
Different type of Bar Chart Visualizations
Hii Team, Hope you're doing well. We have a requirement to create Bar charts visualization like below . Is there any way to create visualizations like this in our workbook . If yes,Can anyone please advise how to do it ? If possible,Kindly send learning resources for the same. Thank you in advance…..
-
Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 I
Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error Unable to launch the Analytics page after the installation of OBIEE 12C Need help.
-
OAC Professional Edition and on prem databases
Hello everyone I am new to OAC and all articles I have read were written for Enterprise Edition. I have to deploy an OAC instance, professional edition (no private access control available) on private network (no public access allowed). Databases are on-prem and OCI VMs (Oracle, Mysql, Mongo) running on linux and windows…
-
OBIEE 11g Agents not Working with Impersonate Error
We are experiencing and issue with Agent on OBIEE 11g , when we try to run an agent we got the following message Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW). Error…
-
How to enable the saving of workbook in OAC Shared Folders?
Hi, Good day! We have encountered an issue in our Oracle Analytics Cloud wherein we cannot save our workbook in the shared folders. As you can see in the image the save button is disabled.
-
Migration from OAS to OAC
If we leave our data warehouse on-premises but move from On Prem OAS24 to OAC, what additional functionality would be available? Obviously we would get updates more frequently - but I’m thinking more about the ML/AI features. We are in a competitive situation with other BI providers and moving to OAC seems a simple…
-
With OAS 2024 installation do we get the AnalyticsRes file for customization of styles and skins?
With OAS 2024 installation do we get the AnalyticsRes file for customization of styles and skins?
-
Oracle Analytics Server Integration with EBS R12.2.11
Can you Pass values from OAS report to EBS R12 form. If we have AR Transaction report and want to get the transaction detail in EBS AR transaction form. We have detailed data stored in DW but user wants to check the EBS screen.
-
How to improve perfomance oas bi from flutter mobile app ?
I am calling oas bi dashboard's link from a flutter mobile app using web view.But it's taking more time to load from the app than from the web.Is there any way to improve the performance in mobile app
-
exportarchive.sh failing ....java.io.IOException: No space left on device
Hello friends , Trying to export a massive production environment and its failing with 'java.io.IOException: No space left on device' Linux filesystem has plenty of space. We have set custom temp folder at request of Oracle Support but still no luck (set 'system-temp-dir' in xdo.cfg) I can run the export with a…
-
Oracle Analytics cloud - Custom Application Role
Hi All, I have OAC new environment… Like to know if it is possible to customize the custom application role.. like in OBIEE 12c … EM we can add policies for custom application Roles (to add or remove privileges)… is it possible in case of OAC … I think its not possible… expert if you are aware please share how to if…
-
Patch set to upgrade OAS2023 to OAS 2024
As OAS 2023 and OAS 2024 are based in WLS 12.2.1.4 Server, is there a way that we get an set of patches to upgrade this versions until we move on to the next WLS. If we choose the out of place upgrade it is a complete workload even if we don't have to upgrade the WLS part. If a patch set is available for enhancement/error…
-
Extracting Substitution Variables from cube using RPD
Hi all, I would like to use a substitution variable from Essbase within our OAC dashboard. However, I can not get the substitution variable to pull through correctly. I have tried two separate options. Using the default Repository Variables that were created on import and pulling in the variable with The VALUEOF expression…
-
grid(11.2.0.4) installation in oracle linux 7.9. /u02/app/oraInventory/orainstRoot.sh error
when i execute the /u02/app/oraInventory/orainstRoot.sh script in the root user i got this error.how can i solve it??? [root@db1 ~]# /u02/app/oraInventory/orainstRoot.sh Changing permissions of /u02/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing…
-
Invoke BI Publisher from DV
I have seen posts about invoking a BIP report from an OBIEE classic dashboard and passing in a parameter from a prompt. Is a similar level of integration possible from a DV workbook?
-
Handling CLOB data in Oracle Analytics Cloud(OAC) and BI Publisher
Hi, I have a CLOB field in which one of the values has maximum of 18000 chars in my Oracle database. Basically, this CLOB field will have some notes, some links, or more than 1 link (using space / [\n] new line characters). So, now when I query this in OAC and export the report to an rtf template, the CLOB field is coming…
-
DV stacked bar Graph label tip.
Is there any way we can make the label stays on stacked bar graph? Excel has this Add data label feature. I am wondering if that can place the label anywhere user wants to place.
-
Action Links not working
Summary: In the below report, I have 3 columns (2 with column selectors & 1 hidden), and one hierarchical column. The 2 columns with column selector are hidden by default. There are action links do not work when we just have the hierarchical column visible, and, the other 2 columns hidden. However, when we add one of the…
-
Can we create OAS DV user with create dv report permission without upload file option in dataset
Can we create OAS DV user with create dv report permission without upload file option in dataset. so user can only build dataset and report reports from subject area assigned it to them.
-
Mass replacement or renaming of presentation objects
In the process of redesigning our RPD over many years where we have setup areas with repetitive picklists. In our redesign and in the example below, all contain the same objects but are copies of each other with a "#1", "#2", or "#3" after them. Business Categories#1 Business Categories#2 Business Categories#3 Calendar#1…
-
Tying to add MAX to Value Column Name
Hi all, I'm trying to add MAX to Value Column Name but get an error anyone have idea how to do this?
