General OBIEE

Get Involved. Join the Conversation.

Topic

    Gopinath Kartheesan
    Using Parent-Child Hierarchy values defined for COA segments...
    Topic posted March 11, 2016 by Gopinath KartheesanBronze Trophy: 5,000+ Points, tagged BI Publisher Data Models, Data Models, OTBI 
    190 Views, 1 Comment
    Title:
    Using Parent-Child Hierarchy values defined for COA segments in OTBI
    Summary:
    Using Parent-Child Hierarchy values defined for COA segments in OTBI
    Content:

    We have Parent- child hiearchies for the COA segment values especially for BSV, Natural account, Department.  These are available in OTBI as well.  There may be multiple account hierarchies in the system.  We would like to know if we select any of the Parent values, will the results show based on all the Chile values underneath in OTBI?

    Also, how can we achieve the same in BI Publisher reports as well?

     

    Thanks

    GK

    Comment

     

    • Arun Raj

      Hi,

      You can use FND_TREE_NODE and fnd_tree_version_vl tables to get the hierarchy data in BI report.

      Thanks,

      Arun