Oracle Analytics Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› Oracle Analytics Idea Lab

Categories

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

OBIEE Imported EXCEL Join With P6 Measures returns null

Delivered
31
Views
4
Comments
VDOT
VDOT Rank 1 - Community Starter
in Oracle Analytics Idea Lab

 OBIEE Imported EXCEL Join With P6 Measures returns null


t.gif


Can OBI Development look into defining relations to external data?

- One to many

- One to zero (Outer join)


- One to one is there and works

1
1 votes

Delivered · Last Updated

With OAC, you can create blend between the Subject Area column and Excel and then control which rows to show. The other option is to add the dimension extension to the DB/source and update the Subject Area/ RPD with this lookup.

Comments

  • VDOT
    VDOT Rank 1 - Community Starter

    31528504891

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Unclear what the idea is for. Can you provide more details? If you are experiencing a product issue, please contact support, if you have a product question you can also use the forum.

  • Mary Wiedenman-Oracle
    Mary Wiedenman-Oracle Rank 1 - Community Starter

    Issue details are documented in the SR number mentioned by the customer in the comment added when posting the idea on January 5. Note: Please add '3-' in front of the SR number mentioned

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    This appears to be looking for a way to add a dimension extension. I think you have two choices. Add it to the subject area as a dimension extension or create a dataset and do blending.

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/work-workbooks-datasets.html#GUID-366E6952-2B1A-4729-8CD0-129003672EB5