-
Using the client "Catalog Manager" on OAC
Hello, May we still use the good old "Catalog Manager" with an OAC instance and if yes what are the connection parameters to use ? Best regards. Jean-Pierre
-
How to hide filter selections when exporting to Powerpoint in DV
Hi all, We recently upgraded to OAS 2024 and one thing we've noticed is that it's not possible to hide the prompt filters selection when exporting to Powerpoint. I think this is due to the fact we're forced to have the canvases in the "Present" portion of the workbooks now. Previously, consumers (non-authors) could export…
-
How to configure external storage using BICC
Summary Configure external storage using BICC Content Hi, I am trying to extract Fusion expense data using the PVOs available. By default the extracts would be in the UCM. But I want to extract it in to external cloud storage like Azure. Is there any way to configure external storage in BICC for storage other than oracle…
-
How to get a running aggregate for the last 12 months
Hi everyone, I have an analysis where I calculate the win and losses (in percentage) for every month. The screenshots are the criteria and the results of my analysis. Is it possible to somehow create another column (called "aggregate") to get the running aggregate of the last 12 months? If yes, how should I proceed? Thank…
-
Deploy semantic modeler error
HI, after upgrading OAS 7.0 to 7.6 (2024) on Oracle Linux we wanted to start using Semantic Modeler. After creating a simple model and running Advanced Check everything is without error. But when I want to deploy SM it starts to deploying and fails. Everything I get from log is: ERROR: Failed to deploy RPD to BI server Any…
-
I want to label my features, but the labels are unavailable for selection
I want to label my features, but the labels I uploaded are unavailable for selection on my GIS Dashboard.
-
License for Oracle Analytics Data visualization
One of our client wants to implement the Oracle Analytics Data visualization for their HCM solution. Would they need separate license for the same, as i understand it is a middleware. If no, then how do we enable it.
-
How to compare data in OAC
how to compare data in OAC from a data set and a subject area which is having a primary key connection (eg: project number). DO you have any related document for the same?
-
number of parallel export excel jobs dependancy on OCPU configuration
Hi, We are trying to use the export to excel feature in OAC Sep 2024 version. But we are encountering the below error very frequently. The server is currently busy executing other requests. Please try again later. A related document - Doc ID 3024821.1, suggests that- Based on the customer's OCPU configuration, number of…
-
Getting ACL entries limit error.
Hi Team, While updating the ACL entries in OBI instance Catalog I am getting below error response. SoapFault Object( [message:protected] => Exceeded number of allowed ACL entries. Path: /shared/XXXX. I have almost up to 1000 user entries that needs to be updated in the Catalog. Is there any way we can increase the ACL…
-
Oracle Analytics Data Visualization
We are exploring Oracle Analytics Data Visualization for one of our clients and I'm reaching out to see if anyone in the group has implemented HCM solutions for their clients. Any insights on your experiences, challenges, licensing woud be greatly appreciated.
-
Moved: Excel Template Scalable Mode to true from Runtime Properties?
This discussion has been moved.
-
Problem when running custom Python Scripts on OAS 2024 DV - Failed to download data from XSA Server
Hi Everyone In my company we wanted to test the OAS DV capability to run Python code for ML models in Data Flows as a proof of concept in order to offer the capability to clients. To do this I followed the steps in the blogpost here https://www.rittmanmead.com/blog/2022/11/leveraging-custom-python-scripts-in-oas/ . When…
-
REST API Connection (Preview)
Hi, The September release of OAC included the preview for a REST API connector. When my non-prod environment was updated on September 16th I could see the new connector. Early this morning (Oct 3rd) my prod instance was updated to September release. Here's where it gets a little weird. The Rest API connector is not in my…
-
Oracle Integration: we are moving our integration from gen2 to gen3 version i am getting an issue
#gen3 when we are moving our integration from gen2 to gen3 version i am getting an issue .The comparison to a variable against a file read response is not giving a correct comparison output.But this is perfectly working fine in gen2. The other thing noticed that if i assign file read response to a variable and do the…
-
Oracle Analytics Server, sorting direct sql results
When you drop columns from subject area, there is sort option appear (picture 1) but if you use Direct sql, there is no option for sorting (picture 2) . If you put "order by" clause to direct sql text, no change is there any way to sort direct sql results
-
OBIEE 12.2.1.4 - Adding Microsoft LDAP as Auth provider - not all AD users retreived
Hi, after configuring MSAD as alternative auth provider, i have a strange situation where I can't see certain LDAP users (i see more than 1000 AD users but some users missing) in Weblogic users tab. On the other hand, a search through the Microsoft AD using Active Directory Explorer tool neatly displays users that I do not…
-
Sort by column by direct query in obiee
When creating a report by direct query, the arrows to order the table itself by a specific column do not appear next to the name of each column. On the other hand, when creating the report by subject area, the arrows appear by default. Is there any way that, by direct query, you can see the sort arrows?
-
OAS SPB Update Path
Hey Folks - long time lurker, first time'ish poster. Currently running OAS SPB 6.4.0.0.230715 Patch 35607281 - Do you recommend going to Patch 36823847 - 7.6 directly (OAS 2024) or making a stop along the way of Patch 36823859 - OAS 7.0 then going to 7.6? I'm having a difficult time finding this answer within the…
-
Why does extract day change the date?
Why does extract day change the date (like in first row from 03/29/2023 to 03/28/2023)? Shouldn't it stay the same? I also tried that: But in this case all the values disappear. I think I have the correct data type: What can I do to keep the date as it is, except to delete the timestamp (12:00:00.000 AM)?
-
Which FMW Infrastructure (including Weblogic) version is appropriate for installing OAS 2024 (7.6)?
can anyone please tell me which weblogic server version is appropriate for the installation and rpm version also. thank you .
-
OAC Direct Connection to On-Prem Essbase - Slow Workbook Initialization
We have created data visualization reports in OAC using On-Prem Essbase as a source. When a user first goes in and opens up a workbook it takes 2-3 minutes for the workbook to open. It sits on the fun fact page and spin until everything is loaded. After Metadata is loaded and queries are sent to essbase cube and returned…
-
Was the OData Connection removed from the delivered OAC connections?
We have a project to connect data using the OData connection which previously appeared in the connections menu, but is no longer there.
-
OAS 7.6 2024 skin customizations
We have been using Skyros as our skin since we started using OBIEE/OAS. Since that will no longer be available in this version, can we simply copy the master.css contents for Skyros to the custom.css file to still get the same look? We have not really done much in the master.css files, so not sure of what will work and…
-
Include the Statistic MODE function as a native function
This function seems to be missing from the list of functions.
-
which is the most stable rhel os version for oracle database 19c?
is there any compatible matrix doc available from oracle? if anyone have that link please help me by giving by that link.also waiting for the answer. thank you.
-
OAC - DV Dataset - data file size limitation
Hi Team, I am looking for OAC - DV dataset - data file size restrictions/limitation I have a usecase, where customer to upload 3 GB of data file using OAC - DV dataset for analysis and keep refreshing it on weekly basis. This usecase is limited to 3 power users only for now. please suggest if there are any limitation to…
-
which is the most stable rhel os version for oracle analytic server 7.6?
is there any compatible matrix doc available from oracle?if anyone have that link please help me by giving by that link.also waiting for the answer. thank you.
-
OAS 2024 Row-level Security Authorization
Hi All, For New OAS 2024 (Linux, Oracle 19c DB) environment is Initblock authorization allowed, What are all the ways we can setup RLS to implement on Classic BI. For DV as per my understanding RLS is still not possible, only role based filter. Please let me know if you require any other information.
-
Is there an option to use values from other visualizations in calculations?
Is there an option to use values from other visualizations? For example I want to calculate the ratio between these two (calculation or manual query does not take into account, so I wonder if I can use these two numbers (253,385/355,373) in the further calculation?)
