nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

SQL query in obiee report

Chandra kanth

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.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

In OBIEE you don't write SQL queries - you create business models which then will automatically spawn SQL!

Felipe_Idalgo

Hi,

Do you have these information available trought RPD?

cesar.advincula.o

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

Chandra kanth

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.

Felipe_Idalgo

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

How-to: Direct Database Request Configuration OBIEE 11g ~ Ask John OBIEE - Oracle Business Intelligence Guides, Tutorial…

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

[Deleted User]

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

rmoff

 
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?