Analytics Software

Hi,

I have a query that should show 3 records but when I execute the request in OBIEE I only get the first record. When I have a look at the executed SQL in the database I see that OBIEE added something like :
ROW_NUMBER () OVER (PARTITION BY t34.department_code, t34.description ORDER BY t34.department_code ASC,
t34.description ASC) AS c6
and WHERE (d1.c6 = 1) to only return the first record.

Except for this the statement generated is correct.

My dimension is the following :
-- Division
-----Department
---------Project Type
-------------Project Code
------------------Employee Code

Things start getting wrong as of the Projct Type Level.
Running the same query and skipping project Type the correct SQL is generated, no more partition by and restrictions in the SQL but I still only get to see the first row when looking at the result in OBIEE.
Very strange as the executed SQL is correct :

SELECT DISTINCT t34.department_code AS c1, t34.description AS c2,
t220.project_type AS c3, t50.project_code AS c4
FROM t_employees t24,
t_organization t34,
t_prestaties t50,
t_projects t220
WHERE ( t24.department_code = t34.department_code
AND t24.employee_code = t50.employee_code
AND t50.project_code = t220.project_code
)
ORDER BY c1, c2, c3, c4

I suppose it has to do with the setup of my dimension but cannot find the solution. Thanks for your advice!

Kris