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

OTBI : ability to create OTBI Index on DFF Attributes

Submitted
11
Views
1
Comments
Xavier Cuinier
Xavier Cuinier Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Idea Lab

Description

Please review the original post for the ER and vote for it !


https://cloudcustomerconnect.oracle.com/posts/a959727cd5


 


 

Use Case and Business Need

You are allowed to create and publish to OTBI as many DFF atributes as you want but once you want build analysis that filter on these DFF, you may face severe performance issues since no DFF attributes are indexed in OTBI. Hence this is a huge limitation for using OTBI

More details

The idea here is to enable the OTBI index creation in the DFF attribute setup page, so once the DFF are published again, you can take advantage of much higher performance


Original Idea Number: 4dfdd78083

1
Up
1 votes

Submitted · Last Updated

Comments

  • Andy May-Coates-Oracle
    Andy May-Coates-Oracle Rank 1 - Community Starter

    I personally feel the architecture for OTBI is very limiting for larger organisations. Oracle have so many cutting edge technologies in their kit bag that could vastly improve OTBI performance, but most are all sold as separate products instead of being utilised to make the core Fusion/OTBI product better for all. This includes things like federating queries (OLTP for intra-day changes, and pre-aggregated data/star schema for history), use of partitioning in key transaction tables, use of in-memory indexing etc etc.