Not sure if this is the right area
Anyone here use them on a regular basis? I just started and need a good starting point. I went through most of the stuff that comes up from google.
I am looking for advice, suggestions on a good site/book and programs you use to create the cubes. Just to give you an idea, I am currently using excel and pivot tables and I can barely trim the data down to less then 65K rows. I would like to look at 300K+ rows of data to start with and then move to about 2million rows of data if possible.
I used the OLAP cube maker in MS Query editor but it keeps crashing on me, I think it has to do w/ the amount of data I am pulling in (300K lines)
I have a P4 3.0 ghz, 1gig ram and XL 2K and enough storage on the desktop and network.
TIA
Anyone here use them on a regular basis? I just started and need a good starting point. I went through most of the stuff that comes up from google.
I am looking for advice, suggestions on a good site/book and programs you use to create the cubes. Just to give you an idea, I am currently using excel and pivot tables and I can barely trim the data down to less then 65K rows. I would like to look at 300K+ rows of data to start with and then move to about 2million rows of data if possible.
I used the OLAP cube maker in MS Query editor but it keeps crashing on me, I think it has to do w/ the amount of data I am pulling in (300K lines)
I have a P4 3.0 ghz, 1gig ram and XL 2K and enough storage on the desktop and network.
TIA