locked
Issue while creating SSAS offline cubes RRS feed

  • Question

  • 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.

    • Moved by litdev Thursday, September 10, 2020 3:35 PM
    Thursday, September 10, 2020 11:39 AM

Answers

All replies

  • The project runs correctly when I use a connection string for output cube that points (and hence writes) to another database on Analysis Services. But when I execute the project using the following connection string that points to the local cube file to be created, it gives me errors depending on the version of ADOMD library referenced.

    conn.ConnectionString = 
    string.Format( "Provider=MSOLAP;Data Source={0}", "c:\\output\\mycube.cub" );

    Microsoft.AnalysisServices.dll

    Thursday, September 10, 2020 1:37 PM
  • From "PLEASE READ BEFORE POSTING" : 

    This forum is for all things to do with programing with Small Basic, NOT Small or Basic questions on other topics.

    Jan [ WhTurner ] The Netherlands


    • Edited by WhTurner33 Thursday, September 10, 2020 1:57 PM
    Thursday, September 10, 2020 1:46 PM
  • I'd try asking for help over here.

    https://docs.microsoft.com/en-us/answers/topics/sql-server-analysis-services.html

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Guido Franzke Friday, September 11, 2020 6:03 AM
    • Marked as answer by Guido Franzke Friday, September 18, 2020 6:56 AM
    Thursday, September 10, 2020 7:00 PM
  • THank you Dave . Have posted there also .

    Regards,

    Bharath

    Friday, September 11, 2020 4:27 AM
  • Thank you will learn to read .

    Regards,

    Bharath

    Friday, September 11, 2020 4:28 AM
  • You're welcome.

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Friday, September 11, 2020 8:32 AM