Cube processing error

Question

Cube processing error

contact_arc

Mr or Mrs. 500

Points: 582
More actions
February 10, 2017 at 6:33 am

#146338

Hi all,
I have create a cube with measure "Order Quantity" in measure group and dimensions "product" and "due date". Due date dimension has date key of type Date and Product dimension has product key column of type ID. When I process a cube it returns error:
Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 2. Errors in the OLAP storage engine: An error occurred while processing the 'Internet Sales' partition of the 'Internet Sales' measure group for the 'Adventure Works DW2012' cube from the SSASStepByStep database.
Please help if someone knows how to resolve it.
Thanks and regards,
Archana Singh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

FridayNightGiant SSCertifiable Points: 7151 More actions · Answer 1

Most likely a data type mis-match. Check the SQL being generated (it should be available in the details of the processing screen). Column four should be suffixed _4

contact_arc Mr or Mrs. 500 Points: 582 More actions · Answer 2

Thanks for your response. It was good to know that column four is the one suffixed_4. I have observed the query in the processing screen. It is :

SELECT [dbo_FactInternetSales].[OrderQuantity] AS [dbo_FactInternetSalesOrderQuantity0_0],[dbo_FactInternetSales].[ProductKey] AS [dbo_FactInternetSalesProductKey0_1],[dbo_FactInternetSales].[DueDateKey] AS [dbo_FactInternetSalesDueDateKey0_2]
FROM
(

SELECT [dbo].[FactInternetSales].[OrderQuantity],[dbo].[FactInternetSales].[ProductKey],[dbo].[FactInternetSales].[DueDateKey]
FROM [dbo].[FactInternetSales]
WHERE DueDateKey between '20060701' and '20060701'
)
AS [dbo_FactInternetSales]

The query is returning all integers. I think I am doing mistake in SSAS settings somewhere.

contact_arc Mr or Mrs. 500 Points: 582 More actions · Answer 3

I created the dimdate balanced hierarchy with MonthNumberOfYear at top and then DateKey. In the cube dimension usage tab, I defined a regular relationship with granularity attribute DateKey, for dimension columns in hierarchy with DueDateKey. Coming back to dimension, the datekey attribute had two key columns MonthNumberOfYear and DateKey. MonthNumberOfYear had type unsignedtinyint. I changed it to Integer and the issue got resolved.

contact_arc Mr or Mrs. 500 Points: 582 More actions · Answer 4

Next error I received was:

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_FactInternetSales', Column: 'DueDateKey', Value: '20050713'; Table: 'dbo_FactInternetSales', Column: 'DueDateKey', Value: '20050713'. The attribute is 'Date Key'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Date Key of Dimension: Due Date from Database: SSASStepByStep, Cube: Adventure Works DW2012, Measure Group: Internet Sales, Partition: Internet Sales, Record: 1. 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 'Internet Sales' partition of the 'Internet Sales' measure group for the 'Adventure Works DW2012' cube from the SSASStepByStep database.

Solution: In the dimensionusage tab I should have mapped monthnumberofyear of dimdate with calculated column 'month' of the fact.