-
OAC-Overlay chart -Tooltip removal from Tile and Conditional Formatting .
Hii OAC Community…….we have created a KPI using overlay chart as shown in image below ,when we hover on it , we see Tile Data and Conditional Formatting Rules (also shown in image below ). Pls advise how to remove these tooltips on hover as we cannot find any option in the properties ,Thank you.
-
Tile Visual Capabilities
In OAC, we'll be using a tile visual to display measure values. Along with that, I also want to show the associated attribute value in the tile as a secondary label. For example, let's say I have monthly values and I'm displaying the highest monthly value in the tile graph. Below that value, I want to show the…
-
Oracle Analytics Server Implement
Dear Concern, We are currently using Oracle BI Discoverer 11g, but since Oracle has stopped supporting it, we are planning to implement Oracle Analytics Server (OAS) from scratch. We have the following questions related to the implementation process: Can we install the latest version of Oracle Analytics Server (OAS) on…
-
jazn-data.xml no longer available in authmodel > jazn folder
Hi, 'just want to confirm if policystore.json replaced the jazn-data.xml. Do we have a documentation about this and when was this implemented (OAC March 2025 or May 2025 update)? Thank you. 🙂
-
How to find employees not in specific two months.
How to find employees not in specific two months. I have employee's data of each month. I want to find the employees not in specific two months. Example data like below. Emp ID FYQ Month Capacity 9060 FY25 Q1 Oct 2024 0.40 9060 FY25 Q1 Oct 2024 0.05 9060 FY25 Q2 Jan 2025 0.40 9060 FY25 Q2 Jan 2025 0.05 100799 FY25 Q1 Oct…
-
Selecting Hierarchy Columns in Calculated Columns with Case Statements (OAC DV + Essbase)
Environment: Oracle Analytics Cloud (OAC) Data Visualization Source System: Essbase EPM Issue: Dynamic hierarchy column selection in calculated columns I am trying to create a calculated column that dynamically selects different hierarchy columns based on a parameter value using a CASE statement. While the hierarchy…
-
How do you set up a URL Navigation in a Data Action? Easy in OAC Classic, but not in OAC
I have the following setup in OAC Classic where a user will click on the value of an invoice and invoke a URL that will take them to another site and pass values from the row click on. I'm trying to do the same in a DV workbook, but getting an error: From this documentation,…
-
Oracle Analytics Cloud - SmartView Capabilities
I'm looking to export reports into Excel for purposes of refreshing the report frequently for most up to date data. I have experience doing this with TRC and FCC, but am unsure of OAC's ability to do this. Some articles say that the refresh capability is doable, but you have to build/recreate the report in excel (no export…
-
Count number of weeks from a specific date
Summary Count number of weeks from a specific date Content Hi, I'm trying to create a measure which would tell me the number of weeks between a specified attribute (e.g. Week End Date) and a fixed date. I tried to use WEEK_OF_YEAR but this function becomes an attribute! - so it's useless Any help on this please? It sounds…
-
Migration Process for OAS 2025
Version 2025 I have recently completed a fresh installation of OAS 2025 in a test environment. Now, I'm considering the best approach to migrate this setup to higher environments (e.g., staging, production). I have a few questions regarding this process: What is the recommended approach for migrating OAS 2025 to higher…
-
Maximize table on load of a canvas in Oracle Analytics Cloud
I have use cases where the table visual should open full-screen(maximize) by default when a user clicks on the canvas. Ideally, the table would be maximized automatically, and users could close it to return to the other visuals. Is there a way to have a table maximized as soon as the canvas loads?
-
Alternative to OBIEE SQL Expression filter.
In OBIEE classic, I use SQL Expression in filter. It is very useful to filter out the columns data. Image is like below. But in OAC , we don't have this option. Workaround/ Solution for this is Parameter with Logical SQL. But OAC Viz is showing listing only 1000. Please see below image. Where as OBIEE SQL expression will…
-
NSAW - Error in Semantic Extensions - Subject Area Validation Error in SME – No Whitespace Found
I'm encountering an issue while working in SME. (see screenshot) indicating an error. "Subject Area attributes have leading/trailing whitespace character. Please check subject area name/description/folders/columns for possible whitespaces." I’ve reviewed the subject area name, description, folders, columns, and even the…
-
OAS 2024 - Data flow aborted after 2h 40min
Hello community, We have a newly installed OAS 2024 on a RH8 and we have migrated to production yesterday from an OAS 2023 installed on a RH7. We are currently facing an issue when executing a long running flow, that it gets aborted after 2h 40 minutes. I was not able to find any configuration that might state that exact…
-
Adjust the pivot table analysis to the window without expand fields
Hi, I'm creating a new obiee analysis and I need to adjust the table so that all the fields can be seen clearly without the horizontal scroll bar. If I change the table width to 1000 for example, the table fields and table is expanded but the horizontal scroll bar still appears. I don't want to expand the table and fields.…
-
BICC connection external service
We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container name ?? aws says that's my repository is https://mynane.s3.amazonaws.com/FILENAME we tried to use 'mynane' as service name , but we got BIACM0123 bad request error.
-
The Portal Path Variable Does Not Populate The Start Page In Oracle Analytics Server (OAS)
Hi Team, I see it in the Doc ID 2911374.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=479425835871802&id=2911374.1&_afrWindowMode=0&_adf.ctrl-state=2plabzyqe_4 that "The Portal Path Variable Does Not Populate The Start Page In Oracle Analytics Server (OAS)". we upgraded to OAS, now as this feature is…
-
OBI Union report is getting error.
Hi Experts, We have a report from same subject area having 8 union report combination. When we are trying to run the report (final format of report is in pivot table) is getting error out. Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError:…
-
How to Extract Data from EPM Cubes in NSAW?
Hi everyone, I was able to successfully connect EPM Cloud to NSAW and can now see the four cubes. However, I’m trying to understand the best way to get data out of these cubes for reporting. Netsuite.Plan, Netsuite. Detail, Netsuite.Rpt Netsuite. Workforce I attempted to use them as datasets for report creation, but the…
-
How to Invoke OAC From OCI -Document Understanding
HI we have few invoices that we have read through Document Understanding by following this blog: https://blogs.oracle.com/analytics/post/register-and-invoke-custom-document-understanding-models-in-oac now how can i access OAC From OCI to get the data like this below is an Example
-
How To Visualize A Dataset Based On Filtered Results from the Visualization of A Different Dataset
My apologies upfront for being very new to OAC, which we are using as a part of a NetSuite Analytics Warehouse implementation. We would like to do the following. Create a workbook for filtering companies based on various company attributes and past sales data — this part is easy Create a workbook for filtering the contacts…
-
OAC-Simple workbook not displayed on language switch
Hello, I have a simpleOAC workbook with one canvas (one dashboard filter + one table). It was created having English as principal language in Google Chrome. When I switch the Chrome language to French the workbook doesn't open (the page is empty, the Modify button doesn't work). I change back to English and replaced all…
-
Cast a date field in UTC to LOCAL time zone with OBIEE
Hi, We are using FTI (fusion transport intelligent in OTM) with OBIEE and we need to transform the date field in UTC to local timezone. How to perform the formulas to transform the data on the criteria formula? Thanks and regards. Pablo.
-
OTBI Parameter - formula of numeric number of the month
Could anyone help me with the formula to get the numeric number of the current month and previous month to use in parameter of OTBI Report Example: If current month is June, then I should get the value as 6 for current month and values as 5 for previous month If current month is July, then I should get the value as 7 for…
-
OCA -Different Auto refresh intervals for different charts/visualization in a canvas .
Hii OCA Community….We have created a Canvas consisting of 10-12 charts/visualizations . We have set the auto-refresh Data enabled with refresh interval of 5 mins for the Canvas.However we have some KPI's in this canvas which we want to auto refresh every 20 seconds and rest of the charts to be auto refreshed in 5 mins .…
-
OAC-Tile Visualization - Category chart -Default tooltip hiding/removing.
Hii OAC Community….We have created a Tile visualization and using category chart included a line chart into it . However while hovering on this line chart it displays values like :First value,Last Value,Low Value etc.How to hide/remove these values on hover ?Pls advise .Thank you.
-
I have created few calculation I want to use them in another calculation but its expanding the who
I have created few calculation I want to use them in another calculation but its expanding the whole formula which is making its mess and I am not able to write big complex logic, any way I can prevent the calculation from expanding to formulas?
-
How can I change the context to consider ALL the history
Hello Oracle folks! I've been trying to calculate if the purchase made by a customer this month (the context is given by a report filter) is his/her first purchase and count them, but I haven't found the answer nor ChatGPT, Claude or the docu to do so, here how my calculation is going, I tried Evaluate function (but…
-
How to setup OBIEE classic login page on OAC ?
Hello, I am migrating OBIEE 12c to OAC, and I wonder whether it is possible to enable the OBIEE classic login page in addition to the OAC one? In other words, I am not trying to bypass IDCS authentication; all OAC users will be registered in OCI, and their rules will be assigned in OAC. I mean when OAC users access the new…
-
OAC-Overlay chart - Line Graph -Colour change.
Hii OAC Community…….we have created a KPI using overlay chart as shown below ,can anyone advise :1) how we can change the color of line in Line graph (Currently black). and 2) Is there any option to remove the X-axis (horizontal) Line.
