Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

sql to obiee

Received Response
102
Views
13
Comments
2»

Answers

  • Rank 4 - Community Specialist

    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,

  • Rank 10 - Analytics Guru

    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.

  • Rank 4 - Community Specialist

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

Welcome!

It looks like you're new here. Sign in or register to get started.