Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
sql to obiee
Answers
-
Hi,
found something...subqueries can be modelled as views in rpd n then those n tables can used to create original sql n with this i can create hierarchies also not exact rpd modelling but will give access to all bi features
regards,
0 -
We never said it's impossible but that you have to go through the RPD in order to get hierarchies. Opaque views are a possibility, yes, but be aware that you eliminate all intelligence of the BI Server in terms of query optimization.
The view SQL will always be executed as-is so don't expect things to run fast if the BI operations (hierarchies, analyzing NULLs, slice/dice, drill, pivot etc) will spawn off spaghetti code on your views. And apart from "don't expect" also be aware that there won't be any point blaming the system/the tool - it's the way its being used that's wrong.
0 -
i never blamed anyone for anything... i m just n implementer...selling is not my part ....its sold like that so we will implement it like that...
0
