error while deploying dimension for dimcustomer table

Question

0.00/5 (No votes)

See more:

hi,

this is my first ssas project.

i've created 3 dimensions for adventureworksDW database.

dimproduct, dimdate & dimcustomer by using respective tables.

But first two dimensions are deployed & processed successfully.

but while deploying dimcustomer dimension, i'm facing lot of errors. i couldn't figure out why?

please help.

Errors:

1. server: the operations has been cancelled.
2. internal error: the operation terminated unsuccessfully.
3. oledb or olebc error , operation cancelled hy008.
4. errors in olap storage engine: an error occured while the dimension with the id of 'dim customer', name of dimcustomer was being processed.

Posted 1-Oct-13 10:00am

Member 10299303

Updated 1-Oct-13 10:14am

Richard C Bishop

v2

Add a Solution

Comments

Mubin M. Shaikh 2-Oct-13 14:34pm

Hi,

Have you tried to process your dimension dimcustomer seperatedly? Please try to look into detailed error and send? when you expand + tree view of dimension processed you can see more details of error.

Member 10299303 6-Oct-13 13:17pm

Mubin, thanks for your response.

Yes, I processed dimension dimcustomer separately but still i'm facing the same issue.

Below are the detailed errors, when i expanded the tree structure:

1. Processing Dimension Attribute 'Customer Alternate Key' failed. 10000 rows have been read.

(i) Server: The operation has been cancelled. Errors in the OLAP storage engine: An error occurred while the 'Customer Alternate Key' attribute of the 'Dim Customer' dimension from the 'secondSSAS' database was being processed.

2. Processing Dimension Attribute 'Geography Key' failed.
(i) OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

3. Processing Dimension Attribute 'Middle Name' failed.

(i) OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

FYI - I've also searched for customeralternate key in dimcustomer table for duplicates. But i didn't find any duplicates.

Also, I'm facing this issue only with Dimcustomer table which is having around 18000 records.

Please help with this case.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10299303 · Answer 1 · 2013-10-08T07:26:00

Hi Friends,

Somehow I managed to solve my issue.

The issue exists with the coloumns i've selected for dimcustomer table while creating dimension, which is having duplicate values.

To solve this, I've choosen key coloumn & value coloumn of the dimension/attributes. Ofcourse, I've choosen the keycoloumn to be multidimensional one.

Thanks,
Subbu.