Access 2000: OLAP queries, Excel, and PivotTable conversions

Experts,

I was given some cube files (.cub) and would like to import them into Access...

The OLAP query in Excel makes a PivotTable that's great...but the underlying problem is the speed.  I have one PivotTable running on a dual procesor server, and it hasn't completed in the past several hours.  I was then given a cube file 1/50 the size, tried narrowing down the fields, and ran it on a coworkers laptop and it hasn't completed in the last ~20 minutes.  

If I could get the file in Access, I feel like I could slice and dice it better than Excel is right now...

Thoughts?

-Jess
LVL 1
jesselavacaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
moduloConnect With a Mentor Commented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0
 
Rey Obrero (Capricorn1)Commented:
if you can work the data in excel then

1. you could import the excel file to access.
2. you can create a link to the excel file.


how do you open the file in excel?
0
 
jesselavacaAuthor Commented:
The file opens as usual, and opens a pivot table with a lot of variables that can included.  I keep drilling down on a pivot table and adding more variables and it slows to a crawl (I have yet to drill down where I need successfully)...I think it's because a .cub is a flat file (not relational) but I'm not positive...

If I could get *all* the data to show, I would just export it to CSV or something and pick it up in Access, but so far no luck.  (I'm up to 3 computers processing this stuff in different ways)...

oh, and my new deadline is Monday @ 5.  uh oh.

-Jess

0
 
Rey Obrero (Capricorn1)Commented:
you might get some idea here, not sure though, haven't got the time to browse

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/sample__cub_file.asp

good luck
0
 
jesselavacaAuthor Commented:
I let Excel try to calculate the values for 1/7 regions all weekend on my high performance desktop, and it crashed.  I don't know why it's so hard...

Anyhow, I had to learn how to use ProClarity, it worked well for analyzing the data cube (but also crashed twice).  I then exported to Excel and got the values I needed.  

Thanks,
Jess
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.