Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 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
Improving Organization Hierarchy Presentation Table
Rob F
Rank 4 - Community Specialist
Organization Name
Ipsos
Description
Add an index to the Tree Code and configuring the Tree Name to filter by code to improve performance when filtering against the organizational hierarchy and user experience when filtering by Tree Name.
Use Case and Business Need
We have organized our departments into trees for business reporting and would like to use them for grouping business metrics and OTBI analyses.
- Having an index should increase performance.
- Filtering the Name by the Code value should improve the User Experience
More details
When we try to include or filter on the Organizational Tree all analyses slow to a crawl and essentially become unusable. This is preventing useful analytics from being developed in OTBI.
Original Idea Number: 501d9ea1a0
1