-
Extra Column in CSV Export
Greetings Community, I've been trying to export this Report into CSV Format: As you can see there are only 4 Columns in OAC Workbook, but this is what CSV looks like: So how exactly Transaction ID showed up? Just FYI, I've tried to add Sum Aggregation and even tried removing it, doesn't help much. Interestingly it doesn't…
-
How to create Conditional Formatting rules with multiple AND/OR conditons
We have a use case to compare 2 measures ($ and %) using the AND condition i.e. both conditions must be met. Is that doable?
-
Second earliest date group by SUB id
Hi , I have a Subject Area containing Sub Id, Meeting Date, Request Date. I would like to create a dataset that contains an extra column : Second Date, that would be the second earliest date from a date = CAse Request Date is null then Meeting Date else Request Date end, grouped by Sub Id. I need a dataset or a workbook.…
-
How to calculate total number days for last 12 month in FDI
-
OAS 7.0: Combining multiple columns into one column to show data in the form of tabular list
Hi Gurus, We have a report with columns that includes attributes: 'X Email ID', 'Y Email ID', 'Z Email ID'. We want to email this report to these three Email IDs when ever there is >0 rows in this report (think of it as re-order alert for inventory or funding alert for bill payment etc.). Therefore, we want to list the…
-
Problems with upgrading accounts
I did an account upgrade on Friday and when I verified my bank card, €93 was debited and has not been returned to date, why is this happening?
-
Oracle Analytics Mobile App connecting with FDI using Intune policy
Dear Team, I have enabled the Microsoft in tune work profile policy to access Mobile app with company provided devices and it is successful. authentication is happening using the active directory as well, however, every time when i open the oracle analytics app it asks me for the credentials is there a way to avoid…
-
OAC: How to suppress rows in pivot table export
In OBIEE you can select to repeat the value of the row instead merge it. This is useful when you are exporting a pivot and you need to repeat the value to allow the user to sort for example.
-
Is there a way to Default to Hide Notes on opening of workbook
Hello. Is there a way to make the default to Hide Notes on opening of workbook? Would rather not have my users have to Hide Notes every time they open a canvas. Thanks
-
How to limit the values of EXP(AVG(log(@calculation("LOS"))))
I was trying to replicate this tableau calculation in OAS How can I limit the scale of the values in the calculation EXP(AVG(LOG(LOS))) to prevent the error "exceeded the maximum allowed numeric size" I was getting the following error: The values generated during the execution of the Log function exceeded the maximum…
-
Logical SQL in calculation validated ok but Query Error in Visualization.
Hi Group, I've tried a Logical Sql in calculation in OAC, it showed validate OK,like below part1, but have Query Error in visualization like below part2. And if we use Valueof function,it shows the message "Cannot find the dataset in this workbook, but actually it's the SQL i copied from developer mode. please kindly…
-
Need help with OACS Data Flow ..
Hello, I am experiencing issues with OACS Data flow. I am trying to create an Assignment table using the HCM Cloud Subject area and then create a Prior Assignment table that stores previous information for the same employees. Now, if I make a visualization I am getting perfect results. Ie. for the first employee assignment…
-
Semantic Model: Refresh OAC physical table structure
Hi community, let's suppose that I have made many changes to a DB table (new columns, changes to column dimensions, name changes, etc.) and I don't want to manually apply these changes to the physical OAC table. Is there any way to automatically refresh the physical table structure to reflect the changes that occurred on…
-
How to filter out or exclude records of a OAC - DV Report based on a Condition/expression filter
Hi Team, Consider I am having a report with 5 dimension columns (A,B,C,D,E)and 5 measure columns (M1,M2,M3,M4,M5). I wanted to filter out or exlcude report records on basis of a condition - (if M1 = M2 then exclude those records from report). How can we achieve this using a my calculation or using expression filter or by…
-
[OAS] Workbook Migration Issue
After copying the workbook from the old OAS instance to the new OAS instance, a popup prompts for credentials to access data from the dataset, even though the same dataset exists in both instances. I’ve observed that a new connection and dataset are being created, despite the same connection and dataset already existing in…
-
Pass Multiple values in Row Level Security in OAC
Hi, As per project requirement, am implementing row-level security in OAC. I have used session variable and initalization block to implement row level security. In initialization block - i have put default initialization string SQL - please find attached snapshot - For Data filter - i have applied in one of LTS - When i am…
-
OAC - DV - Save Filter
Hi, Is it possible to save DV filter similar to saving filter in classic OAC?
-
Basic Authentication - OAS iBot/Job eMail Delivered Agents
Hi Friends! Long time lurker here. We've been an OBIEE/OAS customer for 14 years. We've extensively used delivered reporting via e-mail for that entire time. Microsoft has recently put a proper date on Basic Authentication being deprecated, and that's going to sink our reporting configuration. I've opened tickets with…
-
Export to excel
When a column name is based on a parameter the export doesn't take the column name = value of the parameter, it is using the name of parameter. This is confusing for the users as the name of the column should be related with the values on the column
-
How does oac public show custom shapes for picto chart?
Hi @Philippe Lions-Oracle . We noticed that OAC public has a picto visualization with custom images How was this achieved? We have this requirement but all i could find was this thread mentioning that customization was on the roadmap but no ETA Reference:…
-
OAC Load Testing
Summary How do we perform a load test on OAC Content Is there any software/tool to perform a load testing in OAC environment ? Wondering open source software like jmeter will work if OAC deployed with IDCS. Appreciate your comments.
-
REST/SOAP Webservices for Customer Relationship
I am looking for web services provided by Oracle that can create a relationship between customers. From the Oracle Customer screen, I can create the contact relationship using the below navigation. I am looking for the same relationship creation via web services. Note: Creating the below relationship creates an entry in…
-
Giving access to workbooks but not datasets
I have the following use case: -I want to share a workbook in a catalog folder with some consumers. -These consumers may have author access in other folders -Currently, if they can see the workbook, they will see the underlying dataset in their "Data" tab and be able to create their own workbooks. Is there any way to give…
-
Picto viz in 18.3.3 /DVD 5
Summary How to customise the standard images Content Hi experts, I have upgraded DVD to v5 and see a stack of great new functionality. In the new standard Picto viz can you customise the shapes to use? If so, please indicate how this is done and where the custom images should be located in both OAC and DVD. cheers, John…
-
How to take integers from a column which are in different positions in each raw in OAC?
Eg : first raw value is 'abcdefgh, (2291)' and 2nd raw is 'abcde, (8124) abcdefg' and 3rd raw is 'abc, (1030) 2lmnop'. I need to take the first 2 integer after bracket. Substring is not working bcoz each raw integer is in different position. Is there any other way in OAC?
-
How to sync data between EDMCS and oracle fusion cloud
I have a requirement to automate the dimension sync from EDMCS and oracle fusion. could someone guide me with steps. thanks in advance
-
Connection for pool has been closed is coming in Admin server and there is no exception. Any fix?
<[STANDBY] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <b5a345> <173765739614> <[severity-value: 64] [rid: 0] > <BEA-001128> <Connection for pool "XXX Data Source" has been closed.> Please guide on this how to fix this, there is no exception/error in the logs also.
-
Advanced Tab - Disable Logical Table Source (LTS) for a given analysis
Hello - Can anyone advise if you can exclude a given LTS in the advanced tab in a given analysis - Im sure i've seen some secret undocumented reference to it in the past. Thanks!
-
Dataflow stopped running and no longer possible to run (OAS 7.0)
Hi, We have 7 dataflows that have been running for year, but suddenly they just stopped. All of they orignanly schedulled to run daily until july 2025. When i look at job history i just seems as they have stopped running without any error message, and when i manually try to run them the job starts but never ends (and does…
-
Embedding OAC Dashboard into EPM Navigation Flows
Hello OAC experts, I'm wondering if anyone has tried embedding an OAC dashboard into an Oracle EPM Cloud Navigation Flow. I know EPM Cloud Navs support some web interaction, like running a Google Sheet in a navigation, but I can't seem to find any documentation on embedding OAC dashboards. Any references on this? Thanks!…
