Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

General Ledger Balances Real Time- Natural Account Segment Hierarchy not showing data

Received Response
154
Views
4
Comments
FDI_USER
FDI_USER Rank 4 - Community Specialist
edited Nov 13, 2024 5:02PM in Oracle Transactional Business Intelligence

Team,

Need help on General Ledger Balances Real Time subject Area. As per description, this subject area is based on Multidimensional Cube. When we create report to see data based on Natural Account Segment Hierarchy, we are not getting result. Seems the hierarchy values are not getting populated. Cross checked in ERP system and can see hierarchy information. It is active. Need help to know which cube the query is hitting and how to refresh the cube. How to confirm if hierarchy values are populated in cube and how can it be used on report.

Tagged:

Answers

  • FDI_USER
    FDI_USER Rank 4 - Community Specialist

    Just an update- Account Hierarchy is set up and published in ERP. Create General Ledger Balance Cube process is also run Still hierarchies are not visible in the General Balances Real time subject Area

    Hierarchy.JPG Publish.JPG Account_Hierarchy.JPG
  • John Hung-Oracle
    John Hung-Oracle Mod
    edited Nov 18, 2024 5:04PM

    Hi, To better serve you, I have moved your post to the Reporting and Analytics for ERP forum since its specific to financial subject areas/use cases. Thank you.

    Moved to: https://community.oracle.com/customerconnect/discussion/824141/general-ledger-balances-real-time-natural-account-segment-hierarchy-not-showing-data

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    Hi,

    In analysis design, in order to view I know there are mandatory filters.

    https://docs.oracle.com/en/cloud/saas/financials/24c/faofb/General-Ledger--Balances-Real-Time-SA-14.html#Duty-Roles

    General Ledger -Balances Real Time subject area is based on Essbase cube -- where there are two mandatory filters to be added -- Chart of Accounts and Period Set Name.

    ^^^I find you need this filters (and I also use filter on currency). These I found you will need (these are the formulas for the filters)

    Currency: "General Ledger - Balances Real Time"."Currency"."Currency"

    Ledger: "General Ledger - Balances Real Time"."Ledger"."Ledger Name"

    Accounting Period Set: "Time"."Fiscal Calendar Name"

    Chart of Accounts: "General Ledger - Balances Real Time"."Ledger"."Chart Of Account"

    Natural Account Tree Filter: "Natural Account Segment"."Natural Account Segment Tree Filter"

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    also see the attached - this give quite a bit more info

    image.png
    OTBI_Fin_Reporting_Tips (1).pdf