pls help

Hi I'm a newbie on SASS so pls have patience with me.

Sales Sales Amount Item Code

Items Item code Item description buyer code

Buyers Buyer code Name

sales refers to items -- items refer to buyers to get the buyer name.

I currently have 1 measure & 2 dimensions. My problem is, the items dimension contains buyer codes that doesn't exist anymore in the buyers table. I tried to set the NullProcessing property of the buyer code attribute in the Items dimesion to "Unknown Member". I've also set the Unknown Member property of the Items dimension to Visible. However, once I process the Items dimension, an error occurs.

Error message:

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 the 'Items' attribute of the 'Items' dimension from the 'HMAX2Trial' database was being processed.

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: The attribute key cannot be found: Table: dbo_Buyers, Column: Buyer_x0020_Code, Value: 201.

Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Items of Dimension: Items from Database: HMAX2Trial, Record: 85852.

By the way, I just used the default Error Configuration and didn't make any changes to it.

Does anybody have an idea on how to solve this? I need some help on this.

Thank you so much,

JOP79

JOP79

Keep One Row for Unknown Buyers in Buyers Table

Buyer Code

Name

0

Unknown

And durring ETL replace Buyer Code with 0 not found in Buyers Table. Then you will find your result.

Bhudev

|||

Hi,

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Buyers, Column: Buyer_x0020_Code, Value: 201."

This is your mainly problem.

we can define it with : Your buyer dimension didn't have member with value 201 in column "Buyer Code"

solution : You must reprocess dimesion Buyer before process fact, but ensure your dw had this value

or you must change setting processing,

you could find it when Process windows appear.

"Change setting" have 2 tab, click Dimension key error,

change to "Use custom error configuration"

ensure "key error action" : Convert to unknown

You can change when "key not found" setting to ignore error.

Finnaly all of your "not found" key, converted to unknown.

but for accuracy data you must add this value to your DW

akhukum

Indra P

|||

Hi,

Thank you so much for your suggestions. They were really helpful!

JOP79