Cube and roll up

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