-
Parameter in Data Flows
Hello, How can we use a parameter in a data flow please ? Or is there any workarround to achieve the need of using a variable (like a week) in a data flow ? Regards. Jean-Pierre
-
Moved: Need Input to fetch info on salary changes for an employee
This discussion has been moved.
-
Filter part of column values based on another column
Hello everyone, I'm new to the data field and would appreciate some guidance on an issue I'm facing. I have a column named "Service Type" with three values: "Paid Consultation," "Free Consultation," and "Service," and "Service Description" column. I need to filter the "Service Description" column to display only the top 10…
-
Essential Best Practices for Efficient Data Flow Management in Oracle Analytics
Data flows in Oracle Analytics Cloud (OAC) streamline data preparation by automating complex data transformations, enabling efficient handling of large datasets. They enhance performance and scalability, allowing users to seamlessly integrate, clean, and analyze data for actionable insights. Refer to the video below to…
-
How Can I Identify Active User Sessions in OAS?
Where in /em or /console or /analytics can I find info on currently connected OAS users ?
-
How to Install and Configure Oracle Analytics Server (OAS 2024) With An ATP-S RCU Database.
Announcing the following KM doc on how to install and configure Oracle Analytics Server (OAS 2024) with an ATP-S RCU Database. The document provides step by step instructions on how to successfully perform the installation and configuration. How to Install and Configure Oracle Analytics Server (OAS) With An ATP-S RCU…
-
How to import application roles from one environment to export to another environments
We recently set up one new OAC environment in that I need to have the existing application roles from production. users and groups were in place in new environment but application roles were not there. can you some please assist how import roles and map to groups as bulk. in manual process it will long time to create all…
-
Vision AI API - /20220125/actions/analyzeDocument is giving 500 error
Hi Team, We are using Vision AI API to analyze document, but it's giving 500 error, so need help in resolution of this error. { "compartmentId": "{{compartment_ocid}}", "document": { "namespaceName": "paas", "bucketName": "nonprod-intg", "objectName": "DocAI/abc.pdf", "source": "OBJECT_STORAGE" }, "features": [ {…
-
Where is the Aggregate(SUM) option of an attribute in OAS 5.9
this is an image of OAS 7.6 where I make an aggregate sum of the attribute within the chart with no calculated field used, I want to do the same in OAS 5.9 aggregate the attribute without creating a calculated field. can anyone guide me
-
How to switch binding to different parameters in filter bar.
I have number of parameters defined with different Logical SQLs. This logical SQL fetches Email IDs belongs to different product groups. Few employees Email IDs are common in each Logical SQL. I have created a filter and Bind email attribute with one of the Parameter. It works well. No issues. But I want end user should be…
-
Facing issue while try to use Explore as Workbook option from classic for any DV views
Hi , This is happening or observed after the recent July 2024 update, all the DV views referred or used in classic dashboard is throwing error like "Failed to load workbook from specified path" when using "Explore as Workbook" option. Though I see a Oracle SR raised for similar error for Retail Science Platform, does…
-
EPM 11.2.8 to PBCS , local ebs system/ oracle data source to cloud fdmee
hello all, we are planning to upgrade to cloud. Right now our source system is EBS system through which we get our metadata and data for Essbase and planning application. and we are using essbase data load rule and essbase dimension load rule. If we upgrade to cloud version of EPM can we use on premise ebs system/ oracle…
-
Your account upgrade is in progress.
12 months ago I tried to upgrade my Oracle Cloud account to a paid account. The credit card was accepted, but I never received a confirmation email, and the website https://cloud.oracle.com/invoices-and-orders/upgrade-and-payment?region=ap-singapore-1 stays in the state that your account upgrade is in progress. Who do I…
-
Column level total sort and filter
Hi , I have pivot, that has Column level total select. I want to filter the column level total. Is there any way to get the column level total filtered? I know that it's already the pivot result data .. but wondering if there's any way to make column level total as a measure from criteria. thanks~
-
Prompt before opening option in OBIEE, how to change dashboard messaging
When using the "prompt before opening" option in Oracle BI it generates a message on the dashboard screen that says "Opening this dashboard page may take a while. Select prompt values and click Continue if you want to open this page." Is it possible to change both the wording and the formatting of this messaging? There is…
-
Prompt before opening option in the dashboard settings creates a message for users, how to change?
Using the prompt before opening option that is found in the dashboard settings in Oracle BI populates a message for the users on the dashboard that says "Opening this dashboard page may take a while. Select prompt values and click Continue if you want to open this page." Is there a way to change both the message and the…
-
Errors uploading any excel spreadsheet in OAS 7.6
We are currently on OAS 7.0 and are testing the newer OAS 7.6 version in one of our test environments. We have been having issues with uploading any excel spreadsheets in OAS 7.6. Below is the query error we see whenever we upload any excel spreadsheet. Has anyone else experienced similar issues, and could anyone shed…
-
Semantic Model SMML export as documentation
Hello, We would like to produce an XML or XLS file with the documentation present in our presentation layer of our semantic model. How can we achieve this please ? Regards. Jean-Pierre
-
Schedule a publisher report
Our goal is to create a publisher report to schedule, in order to send the report via email to a group of users. We have successfully configured email delivery in the appropriate administration section. However, when trying to schedule the report and going to the job report history, an error of this type is observed:…
-
Reverse Hybrid access for OAS
Recently our bank has merged with some other bank let say "ABC" and now we have requirement to configure Reverse Hybrid Access provides "ABC Bank" employees access to our web applications from their ABC working station or desktops, without access right to Our legal entity systems. can someone suggest how to provide access…
-
- oracle support <Failed to initialize the application asyncadminservice [Version=11.1.1] due to
-
Oracle Analytics Cloud Physical Layer Mapping with Complex Join
I am looking for examples of complex join expression in the physical layer of the semantic Business Model. I've searched for over an hour and only found one example, and it did not work for me. I hope someone can help me with this as I have run out of ideas. I'm using Oracle BI Administration Tool version 12.3.7 I have two…
-
Exclude option in Dashboard filter giving strange results.
Exclude option in Dashboard filter giving strange results after May 2024 updates. Does anyone come across it? For example Total is 500. When Select Austria , it shows 45 which is correct. But If I check Exclude Button, it is giving 500 or some other strange value than 455.
-
Moved: FDI: How to hide/restrict access to "Oracle" folder under Catalog > Shared fold…
This discussion has been moved.
-
OAC Dataflow Formula
Hi! I'm hoping someone can shed some light on this (apologies if this is the wrong forum!). I'm trying to do something very simple with 1 dataset, but it doesn't seem to be working. My dataset has 2 columns I need to check - Person Number and Manager Person Number - and what I'm trying to achieve is to check if the Person…
-
Does any one know how to bring the obiee12c scheduled jobs from ACS to OAS?
Does any one know how to migrate the obiee12c scheduled jobs from ACS to OAS? we have a lot of jobs in ACS, now we need to migrate to OAS. thanks a lot!!
-
OAS 7.0 - unable to download RPD
Hi, a few days ago, we have successfully migrated OAS 6.4 to OAS 7.0 in OCI (customer manager OAS server from OCI marketplace). Since then, we cannot download RPD from the server with datamodel.sh (we are running datamodel.sh on the server). All we get is: "Error - both Trust Store (TS) and Trust Store Password (TSP)…
-
Data Integration (Analytics & AI)
Good day, I am busy with a very simple Data loader task(Object storage load to ADW). 1.I have created the worksheet with the necessary policies 2. Created the data assets Source(OBS) and target(ADW) 3. Created a project 4.Created a data loader task 6. Created and application 7. Published the task to the application and…
-
How to create Hierarchy Columns
Need Guidance on How to create hierarchy columns in Oracle Analytics Server Goal: Currently, I am trying to make graph that can drill up/down the values. For instance, if I drill to attribute in x-axis from year to quarter to month, and so on. Current Progress: I tried to import dataset from excel or csv (or even create a…
-
OAS 6.4 stuck in signing in, after moving to exadata
We recently moved to exadata. In a day at least 3 times, users cannot login in. It shows signing in. There is no crash report.
