Answered by:
Issue while creating SSAS offline cubes

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