 | |
Re: problem creating cube file
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: problem creating cube file -
08-14-2003
, 11:20 PM
|
Hi all! I have a sales cube that has two measures (Quantity and Sales Volume) and several dimensions. For the sake of simplicity I'll only name the two relevant dimensions here: Partner and Period. Partner is a standard dimension and has one level: PartnerID (unique). Period is a time dimension and has the following levels: Year, Quarter, Month, Day. Currently the cube (better: the underlaying relational database) contains the years 1999 - 2003. The cube uses MOLAP as storage type. Now each partner should have his own statistics and charts so my idea was to create a cube file for every partner that he can e.g. save on his notebook and use Excel or OWC pivot table / chartspace to visualize the data. Of course the cube file should only contain the data for one partner so that there is no chance for one partner to see the sales of the other partners. To create the cube file I'm using a Visual Basic tool that I found on a CDROM which was delivered with a book I bought (Microsoft OLAP Services by Gerhard Brosius). The tool is based on the VbAdoCreatCube sample. Everything seemed to work fine until I made some deeper tests. To specify the partner ID for which cube data should be exported I'm using a WHERE clause that looks like that: [Partner:PartnerID] = 'x'. For some partner IDs I get an error message telling me "Error while processing a partition: Processing error [Source data contains no rows] Measures". The seems to be the case if a partner only has a few sales, e.g. some partners only had sales in 2000 and 2001. If I remove the Period dimension from the original cube (not only leave it away when creating a cube file), it works. For testing purposes I added four additional non-time dimensions and there where no problems, but as soon as I include the Period dimension, the error occurs. Can anybody explain me what causes the error and how it can be fixed? If needed, I can provide the source code of the tool or at least post the CREATE CUBE statement. Thanks in advance Markus |
#2
| |||
| |||
|
|
for further diagnosing , please paste complete code. Also if u can do it against foodmart its better. Then I can actually look into it and reply. "Markus Stehle" <markus.stehle (AT) web (DOT) de> wrote in message news:eD2CO2rYDHA.536 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi all! I have a sales cube that has two measures (Quantity and Sales Volume) and several dimensions. For the sake of simplicity I'll only name the two relevant dimensions here: Partner and Period. Partner is a standard dimension and has one level: PartnerID (unique). Period is a time dimension and has the following levels: Year, Quarter, Month, Day. Currently the cube (better: the underlaying relational database) contains the years 1999 - 2003. The cube uses MOLAP as storage type. Now each partner should have his own statistics and charts so my idea was to create a cube file for every partner that he can e.g. save on his notebook and use Excel or OWC pivot table / chartspace to visualize the data. Of course the cube file should only contain the data for one partner so that there is no chance for one partner to see the sales of the other partners. To create the cube file I'm using a Visual Basic tool that I found on a CDROM which was delivered with a book I bought (Microsoft OLAP Services by Gerhard Brosius). The tool is based on the VbAdoCreatCube sample. Everything seemed to work fine until I made some deeper tests. To specify the partner ID for which cube data should be exported I'm using a WHERE clause that looks like that: [Partner:PartnerID] = 'x'. For some partner IDs I get an error message telling me "Error while processing a partition: Processing error [Source data contains no rows] Measures". The seems to be the case if a partner only has a few sales, e.g. some partners only had sales in 2000 and 2001. If I remove the Period dimension from the original cube (not only leave it away when creating a cube file), it works. For testing purposes I added four additional non-time dimensions and there where no problems, but as soon as I include the Period dimension, the error occurs. Can anybody explain me what causes the error and how it can be fixed? If needed, I can provide the source code of the tool or at least post the CREATE CUBE statement. Thanks in advance Markus |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.