Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Renaming the "Unknown" Dimension Member Name



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 from the Edit Dimension dialog.

How to rename the "Unknown" member name

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


2. Provide an Unknown Member Name and click OK .


3. Deploy and execute your cubes

4. Verify the changes





Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments