Access 2000: OLAP queries, Excel, and PivotTable conversions
Posted on 2004-10-01
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...