substring on physical or logical join in obiee 11g rpd - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

substring on physical or logical join in obiee 11g rpd

Received Response
342
Views
12
Comments
2»

Answers

  • S R Battula
    S R Battula Rank 4 - Community Specialist

    Thanks for explanation.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    S R Battula wrote:i think we won't get situation to join dimension and Fact using Opaque view.

    Why? Because every data source is a perfectly modeled star schema? Because every table out there is automagically supposed to work with all others over resolvable keys? That's an extremely daring assumption.

    S R Battula wrote: if you see the actual query by Amol Palkar it is having join between 2 dimensions and join condition is sub sting of VAR CHAR Data type

    a) That's ONE use case and

    b) read above and

    c) well yeah...ever heard of snowflaking?