-
To show person image in oracle HCM BI report
Hi Mates, I want to build a report showing employee image with his/her record. Actually when I am just writing SQL like below: SELECT A.PERSON_NUMBER, B.DISPLAY_NAME, C.IMAGE FROM PER_ALL_PEOPLE_F A, PER_PERSON_NAMES_F B, PER_IMAGES C WHERE A.PERSON_ID = B.PERSON_ID AND B.NAME_TYPE='GLOBAL' AND A.PERSON_ID = C.PERSON_ID…
-
E-mail distribution from DV - possible to pick distribution lits (e-mail adresses) from db-table?
In Classic / Answers we use an agent to distribute some reports at a given time. The e-mail reciever and the data they can see is defined in a table (a table with two columns, something like: email (which is the userid) , costsenter this user can see) I want to achieve the same in DV, using workbook email schedules…
-
Printing pop-in is truncated
Hello, When I want to print a dashboard, there are truncated lines. How can I fix it ? Tanks for your help
-
Best way to bring Oracle WMS Cloud data to Oracle Analytics Cloud
Is there any seamless connectors between OAC and Oracle WMS Cloud ? Is there anything in pipeline to connect WMS cloud? If not, what should be the right approach to connect with WMS cloud ?
-
Dashboard Prompt:filter code is unchecked and set up the Limit Value by, the selection does not work
I am having an issue with the Dashboard Prompt. For example, if I set up a Project Manager (PM) prompt and uncheck the filter code on the More tab in the Options section, it is supposed to pass the PM's name (not ID). However, after I unchecked the filter code and set up the limit value by the Profit Center, the selection…
-
Can we use a DDR in filter condition of another report which is built using data model?
I have a DDR created in BI, and I want to use it in filter condition of another report which is built using data model. Is it possible? I am getting error when doing so. Please suggest
-
AI Assistant throws error for column name having the character '$'
Hi Team, We have recently started using the AI assistant in OAC May Update. We did the indexing for a subject area and tried the AI assitant for it. But we have noticed that for all the measure columns where we have the character as '$' in the column name the asistant throws error. I also saw a blog which suggested that…
-
Oracle Analytics Server 7.6 integration with Essbase 21c
Hello All, We are currently in the process of upgrading our EPM from version 2.14 to 2.15, and OAS from version 5.9 to 7.6. We have successfully upgraded both applications, but we are facing various challenges regarding the integration of Essbase 21c. I have searched through the Oracle library and support documents, but I…
-
Need to pass username and password parameter on command-line to runcat
Hi Team or Experts, We have OAS 7.6.0 and need help with the below command:- In runcat.sh to archive the catalog it which needs the credentials to be present in the file but instead we want to use -username and -passwords as we have different credentials for different environments. So let us know how to pass those…
-
OBIEE Report Issue – Incorrect Join Path Being Used in Analytics
Hi Everyone, We have created two join paths in the RPD. When creating an analysis in BI: The first join path is being picked up in Analytics, but it returns no data. The second join path has valid data, but it is not being selected by BI when the report runs. We would like to ensure that the second join path (which returns…
-
can anyone help me to get Supplier opening and closing balance query?
-
When generating report from Analysis the rows are merging
Hello Experts, I am currently having issues when I generated the report from the analysis it is looks okay but when I try to filter the report there are missing details, this is due to merging rows from the excel. Could someone please help me on how to avoid this behavior from the excel, been trying to find some fix…
-
Is it possible to configure a fixed home page with predefined custom groups that are visible to all
Hi, With the new feature of Custom groups we are able to customize the home page but is it possible to configure a fixed home page with predefined custom groups that are visible to all users? As of now after we create the custom groups the user still has to add them on to their home page. Please let me know your inputs.…
-
Oracle Analytics Cloud Data Visualization Issue with Essbase Cube
I'm experiencing a technical issue while working with Oracle Analytics Cloud (OAC) Data Visualization with Oracle EPM Essbase cube as the only source Environment Details: Data Source: Oracle EPM Essbase Cube Data Preparation: Imported through RPD (Repository) Subject Area: Configured with all attributes and measures…
-
DV Desktop won't start
Summary DV Desktop won't start Content I downloaded and installed the latest version of DV Desktop 12.2.2.2.2.0 (or something like that) and ran the install on my laptop. I also ran the Install advanced Analytics. R starts with no issues. but DV desktop won't start up. the cursor spins for a second then stops. Things I've…
-
How to Define JOIN Type in ODV
Content Dear GURUS, I am using the latest Oracle Data Visualization 12.2.1.4. In the previous versions, I was able to define the join type between Excel and DB Table for Data-Mashup. However, in this latest version, I am unable to get the option to define the join-type. Please help me understand how can I define the join…
-
Do someone know the reason that Oracle Analytics Desktop not run in MAC Book Pro with Chip Apple M1?
-
I need to calculate Percentile of 25th, 50th and 75th. Please let me know any calculation available?
I need to calculate based on one column. Table have below information. Facility, Nurse Unit, Count, Avg Hours, min, Max,
-
Report Access Issue
Hi The user is able to access the report, but I am not — I'm getting a timeout error, even when scheduling it. I found an alternative way to make it work, but I still can't access the report directly. The actual issue seems to be with the HRQ_PTCPNT_RESPONSES_V table, specifically the SUBJECT_ID column. I resolved it by…
-
DV Export to Excel Error
Periodically I get the following error when trying to export Active Visual (Pivot) to Excel Anyone know where I can find Logs to show the error? I Checked Diagnostic Logs and do not see anything,
-
Percentile calculation in OBIEE
Hi, I am trying to calculate percentile in OBIEE, used percentile and ntile function..but not getting the desired result. Expected ans In Red color. How to achieve this in OBIEE..???? DateCount of StudentCount of Student scored more than 025 % Percentile of Student Marks who scored more than 050 % Percentile75 % Percentile…
-
I am using OAC DV , is there any way we can change color and Font of Canvas name in Workbook
Dear Experts, Is there any way we can change color and Font of Canvas name in Workbook. In Excel it is easily doable, and I am looking for this functionality below 2. When the canvas name is long, the words get wrap even though we have ample space and just 2-3 canvas in Workbook. is there way I can get it resolved
-
Making a report available company wide without creating accounts for each employee
We have a report in OAC which we want to make it available to all employees (using SSO) without creating their OAC accounts. Details: Our OAC/Analytics have a subset of all employees accounts and we have a report which we want to make it available to all employee but don't neccesarily want to create another 6000 accounts…
-
How can get a custom DM from Oracle SaaS to OAC?
-
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.
So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role_role_mbr' However when I try to query the table SELECT * FROM ase_app_role_role_mbr I get an error: ORA-00942: table or view does not exist This is my…
-
OAS RCU with RDS
Hello All Can we use AWS RDS for OAS installation. Please share if we have any limitation to use RDS for OAS Thank you, NR
-
INST-07545: Unexpected Error. com.oracle.cie.gdr.utils.GdrException
Hello, I am experiencing this error when trying to install 8.2.0.0 version to for our 6.4 upgrade. Here is the full error message: INST-07545: Unexpected Error. com.oracle.cie.gdr.utils.GdrException: Failed to calculate dependencies for superseded featureset BI Internal 6.4.0.0.0 I am looking for your advice. Thanks Larry
-
Conditional formatting is lost during the migration from the Dev/Stage instance to the Production
When migrating from one instance to another (Stage to Prod), we use two approaches: Exporting the Workbook (DVA) and Importing into Production: Downside: Conditional formatting, default filters, and custom column names are lost. Copying XML and Pasting into Another Instance: Downside: Parameters are lost and need to be…
-
What is a functional group in Data Filter?
OBIEE version 12.2.1.4.0 Hi, I'm trying to get information on functional group in OBIEE data filter. (In rpd>Manage Identity>App Role>Permissions>Data Filter). Looking for any examples on how it is setup and used. The documentation did not seem to have detailed steps. Doc:…
-
Displaying data from Dyamic tables (Monthly and yearly) depending on the selected date from Filter.
Hii everyone, In our Database , we store Current 3 Days data in the Main Table and the rest of the data in Monthly and yearly Tables. An Example is shown below: Table Name Data Sales Current 3 Days Data. Sales _2025_Feb February 2025 Data Sales _2025_Jan January 2025 Data Sales _2024_Dec December 2024 Data Sales _2024_Nov…
