Share via

Issue while creating offline cubes in SSAS

Bharath Ram 1 Reputation point
2020-09-10T11:44:45.947+00:00

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.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-11T05:40:55.32+00:00

    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.

    0 comments
  2. Bharath Ram 1 Reputation point
    2020-09-14T16:24:13.163+00:00

    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.

    0 comments
  3. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-17T06:24:36.643+00:00

    Hi,
    Did you have further issues? Or have you resolved your issue ?

    0 comments