sql to obiee

User538247

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,

[Deleted User]

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.

User538247

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...