Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 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
Ability to see all hierarchy versions regardless of date effectivity in OTBI (similar capability ava
Shince Francis-18657
Rank 2 - Community Beginner
Organization Name
Blackstone
Description
A GL segment related hierarchy can have multiple date effective versions. All these versions are available within SmartView. In certain cases around allocations, it is easier to manage one tree with different versions when you have several rollups. Otherwise, for every single rollup you have to create a base and current version which results in excess maintenance
However in OTBI, the hierarchy version that is active within the current date is visible. This is inconsistent behavior and causes severe reporting limitations
Use Case and Business Need
It is for ease maintenance of hierarchy and consistency in reporting behavior between SmartView and OTBI
Original Idea Number: 1380ae7dc7
1