Top 20 of count

daveschultz

Well Known Member
I am using BI Publisher Enterprise edition. I would like to get a list the units that have the top 20 number of work orders. I am trying to use a SQL statement like this
select * from (
select count(F4801.DOCO) as DOCO,
F4801.NUMB as NUMB
from JDE.F4801 F4801
group by F4801.NUMB)
where rownum <= 20

It works when I run it through TOAD, and it works in BI publisher if I run it without the outside select and rownnum. Any idea how to accomplish this?

Dave
E8.12, Tools 8.98.1.4, Oracle 10g
 
Connect your BIP EE directly to the database instance, not via a DAS server, and this probably will work.

DAS server, I believe, supports only the same queries as the JDB interface, which has no provision for nested select and such.
 
Hi Seg.

I am not using a DAS server, but I am using the JDE data access jdbc driver. Does this have the same limitations?

Thanks

Dave
 
I tried this out with just the Oracle jdbc driver rather than the JDE one and it worked.

Thanks
 
Back
Top