Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Using Parent-Child Hierarchy values defined for COA segments in OTBI
GopiKAutomus
Rank 3 - Community Apprentice
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
Tagged:
0
Comments
-
Hi,
You can use FND_TREE_NODE and fnd_tree_version_vl tables to get the hierarchy data in BI report.
Thanks,
Arun
0
