jesselavaca
asked on
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
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
ASKER
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
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
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
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/sample__cub_file.asp
good luck
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?