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
SQL query in obiee report
HI,
Please suggest me ...i have report which shows
I have 100 employees. there are CEO and subordinates
My report should display data in the follwoing way
EMployee Sal
CEO 10000(CEO only)
Subordinates (99 employees) 80000 (sum of 99 employees)
All CEO salary + 99 employees salary
I have written query with union ....i should not use that ...some restriction in logic. I am strugging in writing sql query. Please help me out.
Regards,
Chandra kanth.
Answers
-
In OBIEE you don't write SQL queries - you create business models which then will automatically spawn SQL!
0 -
Hi,
Do you have these information available trought RPD?
0 -
Hello Chandra, you can create this report by usingOBIEE in IL: OBIEE - Calculation between results of a union after it put the filters to get the ceo and the subordinarse un each unión, if it give tou some problema, can you put the rpd estructure to get an idea of how to develop the sql lógica query forma obie answers
0 -
Hi,
Thank you so much for the response. I understand that we don't write SQL queries in OBIEE. I am trying to build sql query in sql developer. Is it possible to build a query to get the above result, without using UNION. Request you please suggest/guide me.
Regards,
Chandra kanth.
0 -
Chandra,
You can write SQL queries in OBIEE but it's not really a good way to make your reports by many points.
If you want to create a report using directly database requests follow this:
Directly Database Request Config
About and How-To Create a Directly Database Request
https://medium.com/red-pill-analytics/pardirect-database-request-6fa4d668bab8#.maa112ues
https://medium.com/red-pill-analytics/direct-database-request-714f76d274eb#.bw63n8dt7
Felipe Idalgo
0 -
If you mention this, then also mention that DDRs are severly limited in terms of functionality compared to real analyses created on top of RPD business models. No dimensional hierarchies, no LBMs, no re-usability etc etc etc
0 -
Thank you so much for the response. I understand that we don't write SQL queries in OBIEE. I am trying to build sql query in sql developer. Is it possible to build a query to get the above result, without using UNION. Request you please suggest/guide me. Regards, Chandra kanth.
If you're not using OBIEE then you're in the wrong forum ... try or maybe?
0