September 5, 2005 at 6:23 am
Hello,
we use SQL-Server2000, SP3a. We access to the Cubes by Excel2003 Pivot Table Service. Creating an Offline Cube via "Offline OLAP" manually out of PTS, Microsoft OLE DB Provider for Analysis Services returns: "Error at Datasource Provider" after 45 minutes. The Cube has a size of 2GB. All of the dimensions and measures were selected in PTS. Then I selected just a part of the dim's and measures t build a smaller offline cube. An 368MB cube on the target client was exported in 45 Minutes. The target disk on my ClientPC had at this moment free space of 20GB, but the cpu- and memory-usage was used nearly 100% during the build of the offline cube. Does PTS cache the whole cube in the Clients memory? Is there any faster (automated) way to create an offline cube? I tried http://www.localcubetask.com/createwithvb.htm whithout success.
Greetings from Germany
Ralf Bohne
September 6, 2005 at 8:29 am
The Error at Datasource Provider message is coming from Excel2003? If so, how many rows are in the Cube, (i.e. is the rowcount larger than Excel2003 can handle/open)?
[font="Arial"]Clifton G. Collins III[/font]
September 6, 2005 at 8:53 am
Hi,
the error comes from Microsoft OLE DB Provider for Analysis Services. The Cube Input is 12,000,000 rows. But in the Excel-Sheet only the upper Dimension-Generations where selected - no Level0-members, so that the Online-Excel-Report had just a few rows.
Ralf
September 14, 2005 at 6:27 am
o.k. I learned from sdgcomputing.com a local cube should not be larger than 200MB, because of the bad performance of a 2GB cube. I'll now use backup/restore...
September 14, 2005 at 11:33 am
That's a really big cube! Why is it so big? How many dimensions and levels? Is there really that much dimensional info, or are you actually storing detail-level data in the cube?
To make the cube more manageable you can look into using virtual cubes, and partitioning out segments or domains of data.
Bis später!
- Rick
September 15, 2005 at 1:32 am
Hi Rick,
we have 12.500.000 records and 16 Dimensions in this cube. The customer an the account dimensions have a large number of members. though we use vitual dimensions I dont't really believe, that the cubes storage can be reduced to less than 1,5gig. we solved the problem in another way. thank you. ralf
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply