-
OAS 2024 - View Display Error - Exceeded configured maximum number of allowed output rows.
A table view is throwing an error "Exceeded configured maximum number of allowed output rows" with the below instanceconfig.xml file. When the generated sql ran on the database, the record count is 42978. The error does not disappear even after increasing the number in the instanceconfig.xml (Version 2) file. The report…
-
Data Action not behaving the way I expect, what am I doing wrong?
Hello Oracle Analytics Community. Would anyone be able to help me with the following issue? I have what I call a main visualization with data actions. The visualization is an attempt to migrate what is currently an OAC Classic Dashboard Page to DV. I have a data action set up as follows What I'm expecting with this set up…
-
OAS Prompts in Dashboard
HI All, We have a dashboard /analysis with month and Year prompt, but when user selects a month prompt, Analysis should display data for the selected month and previous 3 months too. we are using OAS 7 on Linux with Oracle DB 19c. Please help how we can achieve this.
-
OAC Indexing Crawl - Default Datamodel Crawl fails
Hi, We use RPD in our OAC instance. When create BI reports using Subject Area, search function works fine where as while creating a Workbook it does not work. When we checked the Indexing, Default Datamodel crawls fails even when we run the crawl manually. We are not sure Crawl fails is the issue for search in DV. Is there…
-
Starting OAS 2023 (7.0.0) server failing
Hello, We have OAS 2023 (7.0.0) deployed in OKE, and from past few months, starting bip server node failing with this error plz suggest. … Creating BI Service Instance [CONFIG] [Oracle_Analytics_Configuration] [Add default service instance]:2025-02-18T06:35:26.792+0000 See log file:…
-
Looking for FYI details in Backend Table
Hello All, I am trying to search the details for FYI notification in the backend table, but I didn't such info. Please help to identify. Thank you!
-
BICC frequency recommendation
Is BICC recommended approach for frequent scheduling?
-
Does BICC supports any other encryption option other than GPG?
We have created BICC reports and using UCM as a delivery location for the generated extracts. We are able to configure encryption on top of it and getting files generated with '.gpg' extension. We are curious to know if there is any other encryption option available for same like 'pgp'.
-
How to find the username who modified an OAS analysis
How to find the username who modified an OAS analysis? NQQuery log is the only way? Is there a SQL or some other way to figure out who modified a report? Appreciate any help Thanks pa
-
Export Chart from a Workbook
Goodmorning, is it possible to download directly in excel a chart from a workbook in order to change terms of colors, text and chart type without exporting it as csv? Thank you
-
Expressions function (Case switch or Case if)
I want to populate Amount_2020 at year 2021 with 1.02 ratio. I tried to use expression case switch or case(if) on Workbook or on analysis. case when Year =2021 then Amount_2020* 1.02 else Amount_2020 end. but failing to getting the amount_2020 at 2020 to year 2021 using the case expression.. any idea?
-
Is it Possible to use OR condition while joining dataset with Oracle DW Table
Hi All, I am trying to create a report based on the File and Table, and over there, I need to use an OR condition while joining multiple columns. Is it possible to achieve that in OAS/OAC? My Condition is: In File, we have Customer_name and Passport columns, and I need to join the file with the customer table based on…
-
Required PVO name for OSS_PRODUCTS_XM table
Hi Team, We are trying to extract data using BICC. We are unable to extract data as we cannot find PVO for OSS_PRODUCTS_XM table. Can you please help us in providing PVO name Thanks
-
In the 'My Calculations' area of DV can there be an option to create folders to group measures?
Not having this ability makes it quite hard to find and keep track of what measures have been build. Also when there are multiple subject areas it would be good to be able to create folders for the calculations that corresponde to each subject area.
-
When there are more elements in the chart, the bars become cluttered
When there are more elements in the chart, the bars become cluttered. Any feature is available in Oracle DV. Could you set the default bar size according to pixel height and add a scroll bar on the right side of the chart for better navigation?
-
Unexpected policy error saving analysis - even for admin with full rights or to "My Folder"
Hello, it's been a while. OBIEE 12.2.1.4 has been cruising along without much interaction/update. All development is on another platform, so this is just in maintenance mode and we cannot upgrade or migrate to any other products. A few months ago, users requested a new catalog folder to house their team's analyses. I used…
-
How Does Automatic Caching Work with Row-Level Security in Oracle Analytics DV?
Oracle Analytics DV automatically caches the most frequently queried data to improve performance. However, if a dataset is sourced from a subject area with row-level security (RLS) applied, the query results can vary for each user. Given that the dataset output differs based on user access, does the automatic caching…
-
Truncating characters while importing the spread sheet into dataset.
I have a spreadsheet where one column is having numbers and alphabets as values. When importing , it is truncating the values. Is it known issue? Workaround: Modify the data to have more characters than number characters. Example: "na" should be replaced by "naaaa"…
-
OBIEE Alert issue
Hi ALL, PFB alert based on it can possible to modify alert in obiee As-is To-Be
-
How to restrict access to Customer Page based on Customer Class
Hi All, We would like to restrict access to Customer Page (Both 'Create Customer' and 'Manage Customer') based on 'Customer Class'. We have many 'Customer Class' defined in system such as 'Clinic', 'Pharma' etc. The requirement is for some users to have access to customer's only that Customer Class 'Clinic' and for some…
-
How to create a policy for a bucket based on compartment?
-
No data actions in the mobile app, but available in chrome app
I have data actions set that allow a user to drill to a detail page in the same workbook. However, data actions is not available in the mobile app. I can highlight the field, but no options show to use the data actions set for it. What is strange is, if open the workbook on the chrome app instead of Oracle's app a little…
-
Semantic modeler for Essbase issue
I'm trying to create a subject area for an ASO Essbase cube using the Semantic modeler. I've followed the instruction in the video, basically just dragging the application through the various stages without changing any settings. The subject area is created but does not work in OAC when creating a Workbook. Only the top…
-
OAC Saving error for PNG file in canvas.
Hi Group, we found an error when we upload a png file in our new environment, but it's ok when we upload the same png file in another environment. The message is: "An error was encountered while saving the workbook: Unexpected file extension type PNG found" Please Kindly help!
-
Has anyone experienced an issue with custom map layers disappearing?
I have a custom GeoJSON map layer file that was uploaded and working fine for the past year. However, in the last several weeks, it has sporadically disappeared (but some days reappearing) essentially rendering multiple visualizations that use the map layer as unusable. Perhaps there was a change in the most recent update…
-
Connecting Mobile Analytics to OAS server
Hi, We have an OAS server configured with SSO using OCI IAM Enterprise application. We have followed below document to configure the Analytics Mobile. After successful steps mention the document trying to scan QR its not working. https://blogs.oracle.com/analytics/post/oa-mob-app-for-oas-with-ag-sso Thanks,
-
Combining 3 columns and get unique values out of it
Hi, I am trying to combine 3 attributes named S1,S2,S3 which has the person number and then need to find unique values out of it. Can help please help me understand how can we do this ? For ex: if there is below values under column: S1 S2 S3 A1 A2 A3 A1 A4 A1 so, I need to have unique values from these 3 columns i.e. A1,…
-
Suppressing all zero rows in OAC analyses without using Selection Steps?
I want to suppress rows in my analysis that show zeroes in all the wrong places. In the screenshot of the analysis's table below, I'm referring to rows showing the columns highlighted in red. Ideally, since every row in it contains only zeroes, the entire "Other Revenue" section should collapse. Each of these three measure…
-
is there any configuration change which can restrict report run time in BI analytics on Application
Hello, does any know if there is any configuration change which can restrict reports run time in BI analytics on Application? Currently our scheduled reports run many hours which cause all kind of performance issues, we would like to see if there is any thing we can do to terminate the reports (like run more than 3 hours)…
-
Oracle Analytics - Calculated Variables - Different colors for different visualizations.
Hii….In my Oracle analytics canvas ,under my calculations i have created some calculations(Ex:Total Revenue,Count etc ) . I'm using these in different visualizations in my canvas . But the color of a calculated variable is same in all visualizations .If i change the color (Color →Manage Assignments) then it changes the…
