Enabling the Unknown Member on a Dimension in SSAS.

Do you ever get this error:

  • Warning 5 Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: ”, Column: ”, Value: ’12:00:00 AM’. The attribute is ‘Date’.

It turns out that this error occurs because:

  • Null values in the fact table relationship are converted to ’12:00 A.M.’

So I tried enabling the Unknown Member attribute of the Date table.  (It’s a standard Date table generated by the SSAS wizard for such things.)

No luck.  Still getting the error when the date in the Fact table is null.

It turns out that enabling the Unknown Member is a multi-step process.   (Much thanks to wildh for their post here.)

To enable the Unknown Member on a Dimension follow these steps:

  1. Go to the Properties Page of the Date Dimension you are using, and select UnknownMember visible AND set the UnknownMemberName to something, such as ‘Unknown’:
    Enable the Unknown Member in the Dimension
    Enable the Unknown Member in the Dimension
  2. Now, go to the Cube Definition and click on the Dimension Usage tab:

    Dimension Usage Tab with Date dimension Usage highlighted.
    Dimension Usage Tab with Date dimension Usage highlighted.
  3. Next, click on the button next to the Date dimension usage, and then click the advanced button in the bottom right:

    Select the Advanced button
    Select the Advanced button
  4. Finally, change the relationship Null Processing drop down to Unknown Member:

    Select the UnkownMember option in the Null Processing dropdown
    Select the UnkownMember option in the Null Processing dropdown
  5. Click OK. To get back to the Dimension Usage tab, and change the Null Processing dropdown for any other Date relationship where the date in the Fact table could be null.

One thought on “Enabling the Unknown Member on a Dimension in SSAS.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s