-
OBIEE 12C signin.html - is the file location customized?
We are migrating 12c to OAS and want to put some messages on the log in page of 12c. However when I check the F:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\msgdb\pages\common\signin.html on 12C server, it looks like the layout of the log in page from https:/myserver.com/analytics/saw.dll?BIEEHome is different from…
-
OAS (GBUCS 3.0) to OAC migration
We are from LSGBU Safety Dev team and recently moved to into HDI Our product Argus is a Life Science product and heavily uses BIP/Analytics and DV for the reporting purpose. The product itself is hosted in GBUCS 3.0. We are looking to migrate to OAS and in need of something to start with. Can anyone please help us with…
-
Need HCM Cloud Approver Group Name and Subsequent Approver Group Members table names ...
Hi. I am trying to obtain/find the tables that are in place and that store the approver groups and approver members which are linked to each approver group, used for HCM like transactions which flow into BPM workflows. I have also gone into the HCM Task Configuration UI, but even in there I can not find how approvers get…
-
Oracle Analytics server Embedding in Web pages
Oracle Analytics server 2023, Oracle DB 19c, Oracle Linux server 8, MS Azure AD for user Authentication want to configure in Weblogic console. Oracle HTTP Server I will be configuring SSL with our company CA signed certificates. requirement 1: We want to configure application URL as "companyName.com/analytics" so it…
-
How To Backup the Semantic Model | Metadata Repository (RPD)?
Good day, community. The question arose, whether it is possible to configure an automatic backup of the repository in which I work ? At the moment I just make a copy of the repository and that's all, but it all happens manually, is it possible to automate this process?
-
Why doesn't my Oracle BI Administration Tool have open "in the cloud" option?
i installed the oracle BI administration tool correctly from start to finish but I am not seeing the open "in the cloud" option, how come this is? I need this option to connect to my oracle Autonomous DB in the cloud. This is where I installed it from…
-
extending existing domain to add OAM
I have a setup of OAS installed in a pod. Now we have also installed OAM in same pod for SSO integration. Need help in extending existing domain to add OAM server & clusters. All documents are with instructions for standalone OAM, not got any doc for extending pre existing domain for OAM. Please guide me on the steps.
-
OAS: How do I remove a connection with multiple dependent DV objects I cannot see.
Hi everyone, I've been asked to do some OAS DV cleanup and to specifically remove some unauthorized connections created by users in DV. When I attempt to remove a specific connection, if it has DV objects dependent on it, I get an error. Is there a way to remove a connection and it's dependencies in DV on the server? Or,…
-
Is it possible to use Presentation variable values as input to a stored procedure in the RPD?
I'm trying to use a stored procedure in our RPD. I've managed to be successful at doing so. My issue is... the stored procedure's input parameters will need to be entered by the user on a dashboard. I have NOT been successful in getting this done. I see in this person's blog post (see below link) that the input parameters…
-
Virtualization Tool to remediate old red Hat virtualization solution in OACS
Hi Team, We are being migrated from On-Prem OBIEE 12c to OACS Gen2 platform. We have a DAL (Data Access layer) layer (Redhat Jboss data Virtualization) which we connect from OBIEE RPD's connection pool using jdbc connection. DAL layer connects to underlying databases like Oracle, API data sources and then on DAL layer it…
-
OBIEE reports takes longer time to load and finally gets cancelled.
Most of my OBIEE report is taking longer time to load and then would not load at all. Table indexing everything is already done.. Kindly suggest how can i improve the report performance.
-
Automation of audit reports
is it possible to have the audit reports scheduled to run monthly? or failing that access them via a BI report
-
Help needed for calcultaion of quartiles In OAS
Hello, We are currently developing several reports using Oracle Analytics Server (OAS). As part of this task, we need to replicate reports from another BI platform. However, we have encountered an issue with replicating calculations that involve the PERCENTILE and NTILE functions. Specifically, we need to replicate the…
-
OAC Workbook: Resetting parameter values in filter
When I hit the reset button after making some changes on my dashboard, the fields revert to their default values, but the start and end date parameters do not reset to their default settings. Is this expected or we have any work around for this?
-
Can I see how many users viewed my graph with the oracle cloud analytics API
when i publish a graph to the cloud analytics is there a way for me to get a count of how many users viewed my graph with an API?
-
Microsoft Fabric as Data source in OAC
Hi, we have the ODBC driver from Microsoft Fabric which can be used to connect from other sources to Fabric. Is there a way that we can use this ODBC driver as a connector from OAC- RPD and fetch the data from Fabric warehouse? We tried using the default ODBC driver in call interface and selecting the newly created ODBC…
-
OAS Date in DV manual query - Parameter / Filter
I have manual query like: select x, y, z, count(*) N from table_a, table_b where open_date <= '31.12.2020' and nvl(close_date, '31.12.2020') >= '31.12.2020' group by x, y, z I need to upgrade it so that the user can choose any date in the visualization (instead of the specified '12/31/2020'). I have no idea how, please…
-
How can we effectively fine-tune an OCI AI LLM for Code Generation?
We wish to use a model (LLM) capable of generating code in JSON format. To achieve this, we plan to train the model with a collection of scripts of the types of code we want to generate, which will serve as examples to fit specific scenarios defined by the user. The main issue lies in the training dataset for fine-tuning,…
-
How do you add an 'All' option to Inline List Dashboard filter types?
You should be able to set 'All' as a default Value or pre-select all values in the list. Version OAC May 2024 DV Workbook Searched docs.oracle.com Below is an example of the Inline Filter Type
-
How to conditional format with an attribute as a target?
Hello, I have a columns called "target" with fixed data that i don't want to aggregate, i want to use it in conditional formatting to highlight if the total have reached the needed target but i can't use attribute there. how can i do it? i did a manual conditional formatting and it worked great but the targets are changing…
-
How to attach credential header to OAC Analysis HTTP Data Action REST request
I am trying to figure out to add headers to a HTTP Data Action. This Documentation, "https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-http-api-data-actions.html", states that you can add custom headers, however I don't see an option to add a header. Is it actually possible? I can't imagine that is not…
-
Reporting on Roles and Permissions associated with BIP catalog folders
Summary Reporting on Roles and Permissions associated with BIP catalog folders Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission etc. Need to understand if any report or relevant table names available in Fusion HCM in order to extract list of all roles and permission associated with…
-
Oracle Analytics Cloud - Add Spacing Between Filters
In a notebook in OAC, is there a way to add spacing between filters?
-
Case (IF) Errors with Invalid Expression, Syntax Error, ORA-01722: invalid number
Hello, I'm trying to filter Service Count By 'Free Consultation' and 'Paid Consultation' from Service Type by this Expression Filter CASE WHEN Service Type = 'Free Consultation' THEN Service Count WHEN Service Type = 'Paid Consultation' THEN Service Count ELSE 0 END but I get an error: Invalid Expression. A general error…
-
Rest-API connector able to store header token to use in another request?
We have a an instance of OAS 2023 that we will soon upgrade to OAS 2024. One thing that drives this is that there is an API rest connector included in the 2024 version, and we have a use case that we want to explore. We have another system that we want to request data to a dataset. This system requires a bearer token to be…
-
How can I download Oracle Analytics Cloud visitor demo account workbooks?
I want to download the workbooks which are available in the OAC visitors account, Do I need an OCI paid account to download the sample workbooks, are they available in the paid account, can anyone guide me through that
-
Delete a file/folder from catalog got error 'path not found - Check the input path entered.'
Hi, I was deleting a folder from the catalog menu, and got the following error message ' path not found - Check the input path entered.'. I can't delete it using Catalog Manager too. When there is a special character like '🔥' in the path I got this error. How can I remove the folder/file without using the full path name?…
-
Oracle Analytics Server Achitecture
Hi, Setup Info: 2 Node (Oracle Linux Server 7.9) Oracle Analytics Server 7.0 Node 1 and Node 2 setup OAS and setup as High Availability Follow Official Document setup NFS shared storage and configure SDD and other component files stored inside. Question: In a scenario where OAS Node 1 or Node 2 is non-operational, the…
-
OAS Manual Query Error [nQSError: 10058]
I spent hours, but I just cant see it. Does anyone see what's wrong with my manual query (OAS DV)? WITH RAC_SUM AS ( SELECT SUBSTR(RAC, 7, 11) AS R_CIB, DATE, SUM(END_DAY) AS RAC_STANJE FROM TABLE_A WHERE RAC LIKE 'DS%' AND OZNAKA IN ('X', 'Y') GROUP BY SUBSTR(RAC, 7, 11), DATE ), MAIN_DATA AS ( SELECT DATE, CIB,…
-
Act As and Impersonation functionality in OACS
Summary Act As and Impersonation functionality in OACS Content Hi, Anyone know whether the proxy (Act As) or impersonation functionality is going to get supported in OACS? Thanks! Nil.
