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
OTBI : ability to create OTBI Index on DFF Attributes
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
Comments
-
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.
0