Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Submitted
21
Views
1
Comments
Shince Francis-18657
Shince Francis-18657 Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Idea Lab

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

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • Shince Francis-18657
    Shince Francis-18657 Rank 2 - Community Beginner

    I noticed from the query log that there is an explicit condition which limits the hierarchy version based on current date which if removed can rectify this issue