-
Suppress value of a custom aggregated column
Good Day, is there a way to suppress the value of my custom aggregated column? I tried to set the property to 'Suppress' instead of 'Repeat' but it still return repeating values. The custom aggregate column I want to suppress have this formula: MAX(Completion_Date by Person_ID) Thank you.
-
pick date
I have a 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') Can someone please help me?
-
Is there a way to add custom fonts into OAC DV, like we do for Custom plugins?
-
OAS Login Report
Is there a way I can run a report that will give me a list of users that login the OAS application during specific dates?
-
Is there a way to export the search results (name, path, etc.) to excel or csv file?
Hi, I am using the Search icon in the catalog manager toolbar. How can I export the search results as a excel file with the name and Folder path?
-
How to show upcomig milestone based on date in Canvas
I have a table like below. I want show only upcoming milestone based on current date. For example, My canvas should show only RC2 Content Complete Oct/25/2024 Any ideas?
-
Filter Non-Measure Column
Greetings, so my Data looks somewhat like this: with 1 FAW_DATE for 1 YEAR, Now I'm trying to put FAW_DATE into workbook via simple calculation, it's throwing this error: I understand the logic behind the same, but what I expect is to show "Month" out of FAW_DATE where Year = '2024'. Your insights will be highly…
-
Want to undertand difference between Aggregate BY through UI and Calculation.
Want to understand difference between Aggregate BY through UI and Calculation. Example: I want weekly Sum values against ID. It is working fine using “Aggregation By” ID through UI as per below image. But I want to do this with My Calculations and don't want to use UI option Aggregation BY. I tried it using AGGR BY , SUM…
-
OAS Dataset Upload Fails With "Cannot read properties of undefined (reading 'inputColumns')"
Hello Gurus, I have a problem while creating a data set from an excel file. When I try to upload excel file; it gives an error below. Do you have any idea about this issue? "Cannot read properties of undefined (reading 'inputColumns')" Our version is: Version 6.4 Regards, Dilek
-
Email Excel Copy | Multiple Email Address in "To" and "CC"
Greetings Community, can anybody confirm if there is an inability to send "Excel" versions of NSAW Workbook via Email I mean we can regularly Export Excel out of Workbook Secondly, Multiple Email Addresses in "To" and "Cc" doesn't work either. I'm applying the right format to separate by ";". Please share your insights on…
-
Flip tiles in OAC
Hi I want to add two measure in Tiles viz of OAC. If I click/mouse hover then the tiles will flip and show another measure. Please let me know if it is possible in OAC. Thanks Kaushik
-
How to remove Fact Joins
Greetings, I'm trying to remove couple of Joins (previously made by another party): Out of these 11 Joins, I would like to remove the Date Join: Neither can I click on dropdown nor can I click on "x". When I hit "Delete All Matches" and hit OK, it still remains as is. I would suspect if it would be because of this: Please…
-
OAD: Best Practices for Calculating Averages Across Different Time Periods
Hello, I have a calculated column in the database that shows the average total per day, (sum patient invoices total / number of patients). This results in all rows for a given day displaying the same value in the column. I now need to reuse this calculated column to aggregate the average totals on a monthly or yearly…
-
Announcing The Oracle Business Intelligence 12.2.1.4 Installer for Fusion Middleware 12.2.1.4
The Oracle Business Intelligence 12.2.1.4 Installer for Fusion Middleware (FMW) 12.2.1.4 is now available. Support for Oracle Business Intelligence 12.2.1.4 on Fusion Middleware 12.2.1.3 is coming to an end. Details can be found in the following My Oracle Support Document: Oracle Business Intelligence Enterprise Edition…
-
Number of Days in Month
Greetings Community, is there any workaround possible that returns "Number of Days" in a Month. For ex, March = 31, April = 30 and so on and so forth. I've tried many combinations from here: but nothing seems to work.
-
Using Dashboard Prompts with Custom Analysis
Hello, I have a custom OTBI analysis which I created using SQL. Has anyone used Dashboard prompts with a custom analysis? Any advice would be much appreciated! Thank you, Julia
-
Different Display in Column Prompt
Hi, I get a different display in default and list of a column prompt: Choice List: SELECT CONCAT(CONCAT(cast("Subject Area"."Pur. Fiscal Month" as char) , ' - '), "Subject Area Date"."Pur. Month Name" ) FROM "Subject Area" ORDER BY "Subject Area Date"."Pur. Fiscal Month" FETCH FIRST 65001 ROWS ONLY Default Value: SELECT…
-
Oracle DV reports integration in classic dashboard where lightweight SSO is disabled
Hi Team, Is there a way that we can integrate DV reports in classic dashboard in a setup where lightweight SSO is disabled. For a requirement we had to use external table authentication for OAS to integrate with other applications and we have disabled the lightweight SSO for the same. Thanks Bharath
-
Help: Question for a regular user on the website
As a regular user (non admin/non moderator), do you see the 3 options to create a question, an event and a discussion in the forum or only one option?
-
Pivot Table Header and Formatting
Greetings NSAW Community, I'm developing a Workbook Visualization and has selected Pivot (rather than a Table because need Merged Common Rows). Now, I cannot see Headers (similar to what we see when we select Table Visualization), also, I cannot scroll down (I know there was data when I selected Table Visualization).…
-
Can we connect to google sheet without connecting to Google drive in OAC
We are connecting google drive through OAC google connector and trying to get the files from the google drive in to OAC. Is there a way to connect direct ly to google sheet without connecting to Google drive.
-
OTBI and OBIEE
Using soap service, trying to delete a report. For example used the below path which exists in the OTBI report in that location. But keep getting "Object or shortcut expected: /shared/Custom/Financials/Test Workflow Notifications/Budgetary Control/Budget Override Taken Notification.xdo". Which ever report I try getting the…
-
OAS Controlling visibility of a presentation layer object in RPD - 'HIDE OBJECT IF' WHEN AVAILABLE?
hi - I have a use case where this would be prefect e-g - filters on an analysis using session variable but i don't want to show the same column as a visible object to some users in Classic BI who are BI authors in answers with access to same subject area. The linked doc suggests the RPD screen Hide object If is a…
-
ACT AS feature not found in OAC
Hi Team, I wanted to check ACT AS feature not available in OAC - classic home page. Is there any way we can know what data are fetching by particular user. I do have administrative privilieges. Thanks in advance. Regards Saroj
-
Getting Error code: 17012 when querying data from Oracle database
I am preparing a dataset and getting this error code: 17012. No more details showed about this error.
-
oracle rest api connector - Please help me to add "body"(data) to endpoint request.
Hi I am struggling to find documentation on how to add body to json file for oracle analytics cloud dv rest api connector. I was able to successfully retrieve data for basic api which requires no body to the request. I would like to someone help to understand where to add the body. Postman version: OAC DV connection: DV…
-
Oracle Business Intelligence Sample App v607
Is there a correct link to download obiee version v607 or later. Existing link throws a page 404 error: https://www.oracle.com/business-analytics/business-intelligence/technologies/obiee-samples-downloads.html Thanks
-
Automate OAC catalog mgr script
Trying to come up with an automated way to move catalog artifacts from a catalog on server 1 to a catalog on server2. Would need a list of the items in the shared folders from server 1 where you could pick what items you want to move Then a way to copy each item from one server to the other. Has anyone kicked this around…
-
OAC - show values with 2 different granularities in the same viz
Hello, There is a way to display the pourcents of a quiz on the same visualisation (Regional vs National) to avoid to duplicate them? I have many question to represent and putting all side by side it's not very pretty. I would like to display the red values on the left graph also. Make a text box for each value (with a…
-
Can we create a semantic model in OAC using multiple connections?
