Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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