DBA: Oracle Discoverer 1

2008 November 5 at 4:07 pm Leave a comment

untuk mengetahui jumlah : Business Areas, Workbooks, Reports Run dll

select ‘Business Areas’ Metric,count(*) “Total”
from EUL5_bas
union all
select ‘Workbooks’ , count(*)
from EUL5_documents a
union all
select ‘Modified Folder Items this Week’ , count(*)
from EUL5_expressions i
, EUL5_objs f
, EUL5_ba_obj_links l
, EUL5_bas b
where f.obj_id= i.it_obj_id
and f.obj_id= l.bol_obj_id
and b.ba_id= l.bol_ba_id
and i.exp_updated_date between trunc(next_day(sysdate-7,’SUNDAY’)) and sysdate
union all
select ‘Modified Folders this Week’ , count(*)
from
EUL5_objs f
, EUL5_ba_obj_links l
, EUL5_bas b
where 1=1
and f.obj_id= l.bol_obj_id
and b.ba_id= l.bol_ba_id
and f.obj_updated_date between trunc(next_day(sysdate-7,’SUNDAY’)) and sysdate
union all
select ‘Reports Run’, count(*)
from EUL5_qpp_stats

Entry filed under: DISCOVERER. Tags: .

Teruntuk para suami dan calon suami… DBA: Oracle Discoverer 2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories


%d bloggers like this: