Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Unable to build a dataset(I'm not sure whether the BIRT has some rules to the SQL query)
Unable to build a dataset [message #644591] Mon, 13 December 2010 12:18 Go to next message
Frank Sun is currently offline 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

Re: Unable to build a dataset [message #644592 is a reply to message #644591] Mon, 13 December 2010 12:23 Go to previous messageGo to next message
Frank Sun is currently offline Frank Sun
Messages: 2
Registered: December 2010
Junior Member
digg!
Re: Unable to build a dataset [message #644658 is a reply to message #644592] Mon, 13 December 2010 16:36 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Did you get this to work?

Jason

On 12/13/2010 7:23 AM, Frank Sun wrote:
> digg!
Previous Topic:BIRT + javabridge... HELP!!!!!!!
Next Topic:Scripted dataset problem
Goto Forum:
  


Current Time: Wed Sep 17 19:47:08 GMT 2014

Powered by FUDForum. Page generated in 0.01676 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software