Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Renaming the "Unknown" Member

Overview

When Analysis Services processes a dimension, it attempts to match each dimension foreign key in the fact table with the corresponding dimension member's primary key in the dimension table. When no join exists (eg., when a value exists in the fact table but not in the dimension table) then Analysis Services will use "Unknown" in its place.

The "Unknown" member name can be changed through the Edit Dimension dialog.

How to rename the "Unknown" member name

  1. In the database dimensions, right-click the dimension and select Edit Dimension

    mceclip0.png

  2. Provide an Unknown Member Name and click OK .

    mceclip2.png

  3. Deploy and execute your OLAP server

  4. Verify the changes

Published:

Renaming the "Unknown" Member

Overview

When Analysis Services processes a dimension, it attempts to match each dimension foreign key in the fact table with the corresponding dimension member's primary key in the dimension table. When no join exists (eg., when a value exists in the fact table but not in the dimension table) then Analysis Services will use "Unknown" in its place.

The "Unknown" member name can be changed through the Edit Dimension dialog.

How to rename the "Unknown" member name

  1. In the database dimensions, right-click the dimension and select Edit Dimension

    mceclip0.png

  2. Provide an Unknown Member Name and click OK .

    mceclip2.png

  3. Deploy and execute your OLAP server

  4. Verify the changes

For an optimal Community experience, Please view on Desktop