Ashwik, You can use Data Augmentation to bring the additional fields from Suppliers and use Semantic Model Extensions to add them in FDI. Let me know if you are facing any issues with the same.

Can we look at drilling from GL Balances to GL Journal and then to Configurable account analysis ? We can use action links to drill from a Balance amount to the underlying Journal and from Journals to Configurable account analysis.

The Column properties are present for all the columns when you edit the pivot. if you cannot find it, then can you log a SR for the same.

Please go to criteria. Column properties and data format.

Kindly check the number format options that will allow to display in % Symbol in DV Projects. Attaching screenshot

Thank you for the update. We are looking into the possibility of adding support for comma-separated values. Thanks

Are you using FAW Connector and can you let me know can share a screenshot just showing the issue ?

Thank you for the clarification.

The drill is configured on the Segment Code. For example, I am attaching a screenshot where we can drill on Natural account Level 30 Code.

Are you not able to drill using the existing Natural account Dimension/Hierarchy in the out-of-the-box?

We do not allow modifying the existing SA. You can create a new SA based on the existing SA and then use the same to reorder (add new folders) it based on your requirements.

Below are additional details https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/apply-different-filter-types.html#GUID-367ADE2B-0D9D-44BB-9CCA-70D31787FD89

You can review the permissions for the Folder which provides information on the Duty roles assigned to secure the folder. You can then decide to remove those duty roles from your Job role in FAW to remove access to the out of the box folder/Object. Below is a screenshot for the Accounts Payable Folder.

You can add columns to the filter like Natural Account Level 31 Code etc.

You can use the Hierarchy Column in the Fusion Analytics Warehouse. Below is a screenshot.

I would recommend you raise a Service request and work with the Support Team to understand and identify the Mismatches.

Currently, we do not support Data Validation for Configurable Account Analysis. But you can do the following: Create a report against CAA and GL Details Transactions. The GL Journal Information should match between Configurable Account Analysis and GL Details Transactions.

Are you looking for Data Validation for Configurable Account Analysis?

Thank you for the details. Fusion Team will review this and update on this.

If you need to see DFF in OTBI, then you need to ensure that BI Enabled Flag is checked for the DFF and run Import Oracle Fusion Data Extensions for Transactional Business Intelligence Process in Fusion.