Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
Thanks for explanation.
0 -
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?
0