Re: Cube and roll up

The January issue of the Pipeline Newletters has tips and articles for using Oracle's ROLLUP and CUBE functtions:
http://www.revealnet.com/newsletter-v2/newsletter_0101.htm

Best wishes,

Cam White
RevealNet, Inc.

Dan White wrote in message <9bd53q028g4_at_enews1.newsguy.com>...
>Hello all,
>
> I have a PL/SQL process the creates a top 50 report for all trafic on a
>website where visitors have clicked 10 times or less
> I need to see the pageid and page_name and number of hits for the fifty
>most visited clickpaths
>
> What I was woundering is could I create this report using the new cube
>or roll up functions
>Thanks in advance,
>
>Dan
>
>I have 2 tables page_dim, and page fact
>what I need to see is the ,count of hits page_id_source, and page_name
>SQL> desc cdm_page_dim
> Name Null? Type
> ------------------------------- -------- ----
> PAGE_ID NOT NULL NUMBER(9)
> PAGE_FAMILY_ID NOT NULL NUMBER(9)
> PAGE_TYPE_ID NOT NULL NUMBER(9)
> PAGE_ID_SOURCE NOT NULL NUMBER(9)
> PAGE_NAME NOT NULL VARCHAR2(300)
>
>SQL> desc cdm_page_fact
> Name Null? Type
> ------------------------------- -------- ----
> PAGE_ID NOT NULL NUMBER(9)
> TIME_ID NOT NULL NUMBER(9)
> TIME_DAY_ID NOT NULL NUMBER(9)
> PAGE_FACT_ID NOT NULL NUMBER(9)
> PAGE_VIEW_CNT NOT NULL NUMBER(7)
> LOGGED_IN_CNT NOT NULL NUMBER(7)
> VISITOR_CNT NOT NULL NUMBER(7)
> AVG_DURATION_SEC NOT NULL NUMBER(6)
> INSERT_DT NOT NULL DATE
> UPDATE_DT DATE
>
>
>
Received on Sun Apr 15 2001 - 18:23:27 CDT