Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Stuart Hibbert
    OTBI Cost Centre lists all parent values
    Topic posted February 9, 2018 by Stuart HibbertGreen Ribbon: 100+ Points, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, OTBI, Reports 
    247 Views, 1 Comment
    Title:
    OTBI Cost Centre lists all parent values
    Summary:
    Cost Centre in OTBI returns all parent values as well as the lowest level
    Content:

    Hi all,

    Hoping someone could point me in the right direction.  I am attempting to build reports in OTBI and need to reference different levels of our cost centre hirearchy in a number of reports.  We have an Cost Cente Hierarchy in Fusion, this has been published and column flattening carried out on it - the tree is linked to the appropriate GL Segment and label applied to this segment is showing in OTBI.

    I've followed all guidance in https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=1980180.1%3ACONFIGUREKFFSEG&action=inline

    My issue is that out of our 5 level based hierarchy they all show under Cost Centre when I try and use OTBI there is no seperation or availabiliy to work with the other levels.  Is there somthing obvious I am missing as I cannot find anyway to get OTBI to pull through the hierarchy as it really should i.e. show Directorate/Division/Group/Cost Centre.

    Regards

    Stu

     

     

    Comment

     

    • Linda Wong

      Which subject area are you trying to build the OTBI report on?  You should be able to see the full hierarchy in the General Ledger Balances Real Time subject area.