Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DATA BLEND OPTION IN OAC DV for XSA - Subject Area

Under Review
52
Views
3
Comments

Organization Name

TEKTRONIX INC

Description

Currently, Data Blend option in OAC DV is only available for XSA - XSA, requesting for a similar feature while working with XSA and Subject Area

Use Case and Business Need

Currently, Data Blend option in OAC DV is only available for XSA - XSA, requesting for a similar feature while working with XSA and Subject Area

 

SR 3-26515554321 : unable to see blend data set option in oac dv 6.1

 

From the SR, we have been requested to create an enhancement request

More details

Currently, Data Blend option in OAC DV is only available for XSA - XSA, requesting for a similar feature while working with XSA and Subject Area

Original Idea Number: 783d7824ee

6
6 votes

Under Oracle Review · Last Updated

Comments

  • Pravin Janardanam-Oracle
    Pravin Janardanam-Oracle Rank 4 - Community Specialist

    This feature is currently under review.

  • Sarah Spicer
    Sarah Spicer Rank 1 - Community Starter

    I would love to see this functionality. This issue has come up multiple times for our end users.

    As an example of a business use cases, we have a subject area that users often join their own files to. Sometimes those files may contain values of a joining dimension that do not exist in the subject area because the associated fact they are pulling from the subject area has a value of 0. Despite it being 0, they would still like it to be present in their visualization, so other users know that it exists. Because the blending between the subject area and XSA file resorts to an inner join, the row drops out entirely. In order to have ALL values of the dimension shown, regardless of whether they're present in both files, these users need to be able to control the blending options and set the XSA file to show 'All rows' instead of just 'Matching rows'. See attached images for the example I just described (values have been changed to protect sensitive information, but this is a real example).


  • User_BKW4K
    User_BKW4K Rank 1 - Community Starter

    Yes!! This is critical functionality that our team is attempting to work around for a current client. Any updates on this would be immensely helpful!!