Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to apply segment value security in FDI?

Received Response
33
Views
2
Comments
User_BB57H
User_BB57H Rank 1 - Community Starter
in Oracle Fusion Data Intelligence

Hi,

Where segment value security is enabled in the chart of accounts, what is the best approach to mirror this within FDI? We have users who are restricted on cost centre segments within all business functions and we want to replicate this access to reports ran in FDI.

Thanks,

Adam

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    You might want to use Oracle Fusion’s Access Control Framework (ACF) and Data Roles

    • The Access Control Framework (ACF) governs data security in Fusion Applications including segment value security.
    • Assign users to Data Roles that restrict access to particular cost center segments.
    • FDI can consume these roles and ACF context via security predicates or user attribute mappings to filter data accordingly.

    Hope it helps!

  • Victor H
    Victor H Rank 6 - Analytics Lead

    You will need custom security contexts:

    https://blogs.oracle.com/analytics/post/implementing-custom-security-context-in-oracle-fusion-data-intelligence-fdi

    FDI can automatically bring security assignments from Fusion but only for a predefined subset that includes Business units, ledgers, asset books.

    This subset does not include GL segments, this leaves you with 2 options:

    1 - Custom security using session variables, init blocks and ADW tables: Configuring Custom Data Security in Fusion Analytics Warehouse in Nine Steps

    2- Using the recent Custom Security Context feature (first link)

    Option #2 is easier to maintain. However, you would also require a manual effort to bring the user-to-cost-center relationships, you could use the autosync tables to upload them into FDI:
    https://docs.oracle.com/en/cloud/saas/analytics/25r3/fawag/update-security-assignments-automatically.html