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
Analysis based on Direct Database Query
Comments
-
This is sometimes the only way i'm able to figure out the sql logic for a certain attribute/measure that's delivered in a subject are to use in BIP. I will update my post with specific examples that would have been almost impossible to figure out on my own.
This is also how we have been able to work through some SRs with Oracle Support.
0 -
Agree 100%
0 -
Dear Ling,
This feature really does wonder. We can create report using BIP as well but OTBI is very power in terms of look and feel. In BIP we cannot have same look & feel as in OTBI.
Additionally, in BIP we generally tend to write different sql for different view but same data. E.g. summary vs detailed whereas in OTBI with single query, we can achieve multiple views.
It would be in fact better, if analysis created through Direct query can be made available to BI Consumer role as well.
I can very well appreciate the fact that there could be security leakage but at the end of the day it would be customer's responsibility to use secured views in query similar to what they do in BIP sql.
Thanks
Regards,
Ashish0