Hi Andrew Mc We will be able to create OTBI report from 2 subject areas provided there are confirmed dimensions (common folder). For example, we can create a report from Workforce Management - Worker Assignment Real Time and Workforce Management - Person Real Time. Both these subject areas, we can create a report based on…

Hi Mr H Please create a hidden column called Rank and apply logic given below. Please change the column names as per your analysis. Rank column logic rank("- Inventory"."Item Revision Control" desc by "Orchestration Order Lines Details"."Order Number" ) After that, please apply a filter on the Rank = 1 With this solution,…

Hi, I don't think there will be like for like reports in Fusion considering the amount of customizations applied at EBS side, unless those reports are based on standard functionality. FAW gives pre-built reports based on standard functionality. For the customizations, same thing to be brought into FAW as well. We have used…

Hi Dharmendra Shukla We need to create separate metrics in the analysis tab itself. For example create 3 metrics like Sales, Cogs, Gross Income (which is a calculated column Sales - Cogs), etc. and use formatting of a cell to highlight Gross Income in a different color. Sample OTBI xml attached. You need to create a new…

Hi @Joshua C. Stewart Not able to open the blog. Can you please post the url once again? Regards Sahithi

Thank you! @Federico Venturin and @Michal Zima for your inputs.

Hi @ Federico Venturin I have created a dashboard prompt (using classic OAC) and used Accounting Date <= as the operator. Data is not getting anchored from 1st report to the dashboard prompt. Am I doing something wrong?

Agree with Bharath. Please check the column datatype length in RPD.

Thank you Lalita

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/faqs-power-bi-connectivity.html

Thank you Subhakara. It worked like a charm!

Hi Amrita, Yeah, looking for the export of these joins into a csv or xls file. As of now, when we copy and paste, it comes like below which is not the format we are looking for. -DECLARE FOREIGN KEY "Data Warehouse".."ADW"."Fact_W_SITE_PROTCL_DEVTNS_F"."Fact_W_RXI_SITE_PROTCL_DEVTNS_F_Foreign Key#7" AS…

Thank you for the response.

Hi SiddharthDang-Oracle Do you have encrypted and decrypted data in different columns of the same table/different tables? If yes, we can write an opaque view in the physical layer something like this select * from decoded_table_data where upper(user_name)=UPPER(:USER) union all select * from encoded_table_data where…

Also you might have to create policy to access the storage bucket. Have you given the group permission to manage buckets? If so, then you also need to grant the group permission to manage objects. sample: Allow any-user to manage object-family in compartment <Compartment>

Hi Have you used same user while creating the storage bucket and also while logging into OAC Analytics? The user you created the signing key for must have read-write access to the storage bucket. Thank you!

Hi Have you specified the output format of the BIP report as csv? Please go to View a list -> Output Format -> Select Data (CSV) and unselect other formats. you should be able to get the output as a csv file. Thank you Sahithi

Agreed. We are manually resetting the last extract date from fusion BIACM whenever we need to do a full load.

An idea is submitted under OAC for the same https://community.oracle.com/customerconnect/discussion/657512/option-to-hide-column-in-data-visualization#latest

As of now, this functionality is not available.