Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    cRIMSOn
    Adding a new Essbase dimension to the OTBI subject area...
    Topic posted April 11, 2019 by cRIMSOn, tagged Fusion Financial reporting, OTBI 
    102 Views, 1 Comment
    Title:
    Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'
    Summary:
    Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'
    Content:

    Hi All,

     

    Can anyone please provide guidance on whether it's possible to add a supporting attribute (e.g. Journal Source) as a new dimension in the out-of-box Essbase cube provided in OTBI subject area 'General Ledger - Balances Real Time'? 

     

    Thanks,

    Lance

    Comment

     

    • Craig Alderson

      Hi Lance,

      I don't believe any of the OTBI Subject Areas can include additional dimensions but I'd be interested to know if that's not the case. The GL Balances Subject Area is based on the same Essbase cube used in FRS and Smartview which I don't believe is customisable. If you are looking at GL Segment information by Source you can use the 'General Ledger - Transactional Balances' Subject Area which includes all of the coding.

      If you want to bring summary hierarchy information in to the same report we have had to join both the balances and transactional balances Subject Areas together.

      Craig