Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Caroline, not facing any issue while copying the canvas. Some cases if there are any links, we faced issues. In those cases, we just clicked on 1. Present tab → 2. Data tab → 3. Visualize tab. If some issues related to caching, got resolved with these steps.
-
Hi @Benjamin Arnulf-Oracle This feature has become a show stopper for two banking customers we are working with. Is this feature under review and can be delivered in near future? can you please check. Thank you, Sahithi
-
Our customer is also looking for a custom font. Can you please update when this can be added to product feature?
-
Thank you @GayathriAnand-Oracle and @EzequielC-Oracle
-
Hi @Srinivas Pothuganti There are no out of the box adaptors available to pull data from EBS into FAW. Our team created a framework and created adapters for retrieving data from EBS R12 for GL, AP, AR areas. Regards
-
Yeah, can you please attach the archive file? It's going to be useful.
-
Thank you Rajesh for sharing the details
-
We need to check the reports running slow and analyze case by case basis. If we are creating reports using multiple subject areas and not restricting data to specific criteria, performance is going to be slow. If the reports are analytical in nature which require cross-functional capabilities, customer can be suggested…
-
And one more thing, we used the deep links in OAC. So the solution given is for Fusion.
-
Hi Andy Harding Yes, we have implemented deep links for one of the customers. We used to manually update all deep link urls when changing from one environment to other. I too agree to your point if there can be some automated way for it, it is going to save time. Regards Sahithi
-
Hi @Tudor Hanga Please refer to the support notes given below. OTBI Analysis Report - Scheduling Agent With Default SQL Prompts Not Working As Expected (Doc ID 2502027.1) OTBI Filter Or Prompt Not Working In Agent (Doc ID 2717748.1) Thank you!
-
Thanks for sharing @Gaurav Bharadwaj-Oracle
-
CAST("Expense Report History"."Event Date" as TIMESTAMP) But, I'm afraid it will show 12:00:00AM for all records as the data type must be selected as DATE instead of TIMESTAMP in the RPD, which we will not have control to change.
-
Hi @Nisha Italiya The back end query for Top 10 Spend Supplier is given below. Based on inv_dist_match_status and invoice_type_lookup_code Addressable Spend and Non-Addressable Spend columns are derived. SELECT invoicedistribution.amount, invoicedistribution.invoice_distribution_id,…
-
Competency Name column is causing the error. if we remove this column, report works fine. In OTBI, we will be able to create a cross subject area report only if the underlying dimensions are joined to the fact tables and the grain is supported. Otherwise, this error "No fact table exists at the requested level of detail…
-
Can you please check the support note OTBI - General Ledger - Balances Real Time Subject Area not Returning Data; More Information on General Ledger Subject areas (Doc ID 2177122.1) if it is relevant?
-
Hi Harminder Banga-283414 Are you looking for Saved Columns in OBIEE? Though it is for OBIEE, it's going to be similar for OTBI reports as well.
-
Hi, I don't think it is possible to join these two subject areas as there doesn't seem to be a confirmed dimension. It is erring out when I tried combining. One way is to create a BIP report if we know the backend base tables. Thank you!
-
I think supporting references data type is VARCHAR, so it's a kind of free text. So unless until it is restricted at the data entry level, we won't be able to cast that as date in the report. One option is just show that as a free text in the report as well. But there may be inconsistency in the date format. We need to…