Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- 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