This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 22%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Hello All ,
Am using the below query to build the offline cube but it is failing saying operation is cancelled and no detailed error.
CREATE GLOBAL CUBE [Test]
STORAGE 'E:\abc.cub' FROM [Cube]
(
MEASURE [Cube].[Unit],
MEASURE [Cube].[Value],
MEASURE [Cube].[Value USD],
MEASURE [Cube].[Counting Unit],
MEASURE [Cube].[Dosage Unit],
MEASURE [Cube].[Molecule Count],
DIMENSION [Cube].[Channel],
DIMENSION [Cube].[Geography],
DIMENSION [Cube].[Period],
DIMENSION [Cube].[Product],
DIMENSION [Cube].[Molecule]
)
However if i comment the Period dimension it is getting executed completed without any issues.
Can you please help me understanding what exactly might the issue be.
Error Message Below.
Server: The operation has been cancelled.
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while processing the 'Cube' partition of the 'Sales' measure group for the 'PH_DDD' cube from the PH_DDD database.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Further have tested for 6 months of data and the above query is working fine,however we include 12 months query is again failing. So my assumption is it is failing due to the size of the data how can we resolve it.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi,
Seems there are internal issue in the cube , have you develop and deploy it in Visual Studio? You could try first develop the cube completely in VS then create the offline cube.
From your description, I would start debugging first at Period dimension. See if it can be processed successfully .
Also as your error info mentioned , the sales - ph_DDD measure could also have problems.
regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
In Period dimension was having some null values for YTD columns after replacing them with 0 was able to extract the cube. So can conclude saying if we are having some null values for columns we will be not able to extract cub file.
Hi,
Did you have further issues? Or have you resolved your issue ?