| Doing queries.... [message #114222] |
Tue, 24 January 2006 09:50 |
Eclipse User |
|
|
|
Originally posted by: jan.tanis.coas.com
Hi all,
I'm trying to set up a demo bussiness case with BIRT to demonstrate
drill-through linking. However, with the first report I encounter a
problem. When I enter the query, it gets the metadata, but it does NOT
collect the normal data. The query is fine as I tried it in an Oracle
developer application. So does anyone has an idea why this goes wrong?
SELECT
OFE_ID AS ID
,OFE_NAME AS NAME
,OFE_COUNTRY AS COUNTRY
,REVENUE AS REVENUE
FROM
(SELECT
OFE_ID AS OFFICE_ID
,SUM(ACY_BENEFIT) AS REVENUE
FROM
DEPARTMENT
,ACTIVITY
WHERE
ACTIVITY.DET_ID = DEPARTMENT.DET_ID
GROUP BY DEPARTMENT.OFE_ID)
,OFFICE
WHERE
OFFICE_ID = OFFICE.OFE_ID
Thanks in advance, Jan.
|
|
|
Powered by
FUDForum. Page generated in 0.04467 seconds
Home