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

Expose Custom Lookup and Value Sets in Subject Area

Submitted
568
Views
3
Comments
Amitabha
Amitabha Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Description

Often there are needs to enrich reports and analytics utilizing custom lookups and value sets. As custom lookups and value sets are not available in any subject area for use standalone (with exception of value sets used for DFF definition), developers are forced to create data model based reports to meet business requirements, thus loosing lot of features offered through Analysis and Dashboard. If all Lookup and Value Set values are exposed through a simple subject area, then we can utilize a cross-subject area analysis to enrich user experience.

Use Case and Business Need

Use cases for custom lookups and value sets are unlimited, a simple scenario is to contain reference data against master setup or transactional data where no seeded configuration can store the reference data. For reporting purpose a simple join is required with the lookup or value set tables, however that is no longer possible in BI Analysis.

More details

Product does not meet the requirement as SQL based Analysis are no longer supported. Physical query can be utilized to query the view objects in limited scenarios where lookup/value set data can be pushed to WHERE condition, but the values can never be rendered in Analysis.

Original Idea Number: 6379957283

Tagged:
17
Up
17 votes

Submitted · Last Updated

Comments

  • Pat Yap
    Pat Yap Rank 1 - Community Starter

    Hi Oracle Colleauges,

    We have the same need for our reporting requirements. This feature will simplify our reports and we will not need to do funky workarounds to achieve our reporting goals.

    Hope Oracle can deliver this.

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    this would be very helpful

  • Jabeer
    Jabeer Rank 1 - Community Starter

    Organization: JCI Inc,

    Business Use: Have a defined Zip Code for the Branch, Sales Area, and Regional Hierarchy. This hierarchy is maintained in the custom lookup. The sales hierarchy should be added to the OTBI reports.

    However, unless we convert these OTBI reports to BIP, the AR reports can't have the Sales hierarchy.

    Ask: Need subject area for the lookups to derive the details