I am looking for an user entity which is used to fetch all the balance details that is, balance dimension and balance feed details. Is there any user entity? Please suggest.
If you have a 'user entity' on the transactional side that can fetch all the payroll balance details, the same should be possible on the FAW side.
To get started with FAW and configure users see: https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawag/typical-workflow-administer-oracle-fusion-analytics-warehouse.html#GUID-1048B245-10BD-46B4-A558-F57CF3E3433F
Out-of-the-box security setup is defined documented here: https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawag/add-security-configurations.html#GUID-059F0DEA-C054-48FF-8544-AEAB36372E3D
Customized security setup is defined here:
https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawag/set-custom-security.html#GUID-5E2C7560-34DB-42DE-902A-E36DE600625E
and here:
https://blogs.oracle.com/analytics/post/configuring-custom-data-security-in-fusion-analytics-warehouse-in-nine-steps
Payroll Balance is a pre-built offering available in FAW ( Under Preview )
Please refer link - https://docs.oracle.com/en/cloud/saas/analytics/23r2/fahia/chapter-introduction.html#GUID-4E3923A3-0778-4CA7-ABFA-444119715B91
