Cube and or roll up

From: Dan White <dwhite_at_icimail.com>
Date: 16 Apr 2001 07:58:18 -0700
Message-ID: <9bf1aa029ck@drn.newsguy.com>

Hello all,

I have a table (described below) that I need to create a daily top_fifty report from. We are doing click stream analysis for a website. What I need to know is for a session on the site what are the top fifty click paths FOR 10 clicks or less. Can cube or rollup help here?

The report should liik like the following RANK,HITS
PAGE_NAME1,PAGE_TYPE1,PAGE_FAMILY1......PAGE_NAME10,PAGE_TYPE10,PAGE_FAMILY10 SQL> DESC CDM_STG_TOP_FIFTY

 Name                            Null?    Type
 ------------------------------- -------- ----
 SESSION_ID                      NOT NULL NUMBER
 PAGE_ID                         NOT NULL NUMBER
 CLICK_SEQUENCE                           NUMBER
 TIME_ID                         NOT NULL NUMBER
 PAGE_NAME                                VARCHAR2(300)
 PAGE_TYPE                                VARCHAR2(80)
 PAGE_FAMILY                              VARCHAR2(80)

thanks in advance

Dan White
programmer/analyst Received on Mon Apr 16 2001 - 09:58:18 CDT