Thanks @Philippe Lions-Oracle. When adding the column in Expression Filter, the filter value exceeds 1000; I am getting the error because of that.

Hi @Conor Murnane, For the above scenario, you can create the Custom Groups in FDI and assign the required FDI duty roles to the customly created group. By assigning the custom group to the users will have access to the reports and subject areas. Note: You need to assign only the FDI duty roles and not the data roles. I…

@Jun Deguchi-Oracle, nope it is not possible as per the current architecture. Because at the time of instance provisioning, we need to provide the Fusion source instance URL and the user details for loading the data. For now, we can able to provide only one instance detail. Regards, Sathya

Hi @User_3512R, Yes, you can filter other visuals from the canvas using a visual available in the same canvas. For that, you need to enable the use as filter option. Once the use as filter is enabled, then the value selected in the visual will be filtered in other visuals. To enable use as filter? Right click your visual…

Hi @asmith223258, In the above screen select the link type as Static URL and provide your FDI-OAC url. Once you save the sandbox, goto preview mode and check whether the link is working correctly. If everything is fine, then you can publish the sandbox.

Hi @JohnW-Oracle, I have checked the BIP datatype in the data augmentation page and it is in the timestamp format. Could you please help how to load these data type into FDI?

@Sumanth V -Oracle - Initially I had set the timestamp format in the BIP Connection and after that I did the metadata refresh and data extraction

Hi @JohnW-Oracle, I have attached the screenshots above, from BIP report, I am trying to extract the DATE_FROM column and it is in timestamp format. In the BIP Connection, I had given the timestamp format as yyyy-MM-dd'T'HH:mm:ss.SSSZ and after the data augmentation, the timestamp column values are showing null value and…

Hi @Manideep Boddu, You need to have OCI Admin access to grant roles to the user. Could you check with your OCI Admin to assign the required role to that user. Changes will get reflected immediately in FDI Console → Security page.

yes @Ashish-Oracle , I have raised an SR and got an strange reply like, this is an expected behaviour and there won't be any fix for this. So the users need to select the Business Unit which they have access.

You can use the Pivot view to generate the report in the above output format.

@Sumanth V -Oracle, nope, that doesn't help me. I am not able to see any prompt under the comments section.

@Sumanth V -Oracle, not able to find the option to mark the answer. Do I need to change any settings?

@Sumanth V -Oracle, Thanks!

Thanks @Sumanth V -Oracle, could you please let me know the best approach to load the 2nd Fusion cloud ERP data into existing FAW instance?

@Sumanth V -Oracle Thanks for the update. Could you please let me know the possible ways of loading data from the Multiple Fusion cloud? → We can load 1 ERP instance data directly to the ADW. → Please let me know the best possible way to load the data into the same ADW with a custom schema.

Hi @Manu R-Oracle Please use the below column formulas: Solution 1: Supplier Name New: CASE WHEN ATTRIBUTE(RANK("Financials - AP Transactions"."Facts"."AP Cleared Invoice Amount (Document Currency)") BY "Supplier"."Supplier Name") <= 10 THEN "Supplier"."Supplier Name" ELSE 'Others' END Payment Amount: "Financials - AP…