OLAP Cubes

[Genius069]

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

 

[Andrew Fergus]

Hi
How about using Access? It sounds like just the tool for the volume of records you have.
Andrew

 

[SydneyGeek]

You could definitely store the data in Access, and then build some filters to pull it down to Excel. This could be achieved either with MS Query or through using ADO.
If you want to check out some open-source products, look here. The bigger OLAP solutions like Microsoft Analysis Services, Cognos, TM1 and Hyperion all cost big money.

Hope this helps

Denis

 

[BC...]

How does it 'crash'? I am trying to do something with a similar amount of data and i keep getting the following error after a few minutes of it trying to create the cube.

Cube file could not be written. Edit cube definition to try again. If updating an existing cube, make sure that the file is not being used by Excel or some other program.