Unable to build a dataset [message #644591] |
Mon, 13 December 2010 12:18 |
Frank Sun Messages: 2 Registered: December 2010 |
Junior Member |
|
|
Hi Everybody,
I am a newbie.
Recently, I need to learn to use the BIRT to support our project.
Today, I tried to build my first BIRT project. However, after I build the datasource, I met a trouble when building the dataset.
Firstly, I wrote the SQL query like this:
select * from
(
select rank () over (partition by day_period_key order by traffic desc) rk,
bd_usdt.day_period_key day_period_key,
bd_ua.phone_number phone_number,
dmf.device_manufactory_name device_manufactory_name,
dm.device_model_name device_model_name,
bd_usdt.traffic/1024/1024 traffic
from bd_user_appeared bd_ua, device_model dm, device_manufactory dmf, bd_user_session_device_traffic bd_usdt
where bd_ua.user_id=bd_usdt.user_session_id
and bd_usdt.device_model_key=dm.device_model_id
and dm.device_manufactory_id=dmf.device_manufactory_id
and bd_usdt.day_period_key = 20100801
) T
where T.rk<=5;
I can get the correct results by using the SQL query in PL/SQL or SQLPLUS. But I cannot get the output column when I click OK button by using this SQL query. You know, no output columns, no report.
Secondly, I made the SQL query like this:
select rank () over (partition by day_period_key order by traffic desc) rk,
bd_usdt.day_period_key day_period_key,
bd_ua.phone_number phone_number,
dmf.device_manufactory_name device_manufactory_name,
dm.device_model_name device_model_name,
bd_usdt.traffic/1024/1024 traffic
from bd_user_appeared bd_ua, device_model dm, device_manufactory dmf, bd_user_session_device_traffic bd_usdt
where bd_ua.user_id=bd_usdt.user_session_id
and bd_usdt.device_model_key=dm.device_model_id
and dm.device_manufactory_id=dmf.device_manufactory_id
and bd_usdt.day_period_key = 20100801;
I can get the output columns after clicking OK button. However, this SQL query is not what I need.
So, who can explain the reasons to me? Is there any requests to SQL query in BIRT?
3Q!
Best Wishes
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04534 seconds