Technical: Microsoft – SQL Server – Analysis Services / BIDS – Error – Message – Dimension [xxx] : No key attribute is defined

Technical: Microsoft – SQL Server – Analysis Services / BIDS – Error – Message – Dimension [xxx] : No key attribute is defined

Introduction

Mistakenly removed an Attribute, now when I try to build the SSAS project, I am getting an error message stating: “Dimension [xxx]: No Key attribute is defined”.

Background

Ordinarily the message should not be difficult to fix, but the Business Intelligence Development (BIDS) environment does not allow use to set the Dimension’s key.

Set-Table Dimension Properties

Interestingly enough, BIDS hides and shows various settable attributes based on which Dimensions is selected.

Dimension Properties – Time

DimensionTime

Dimension Properties – Fact

DimensionFactUsage

Dimension Properties

From the screen shots above, we can quickly see that based on which Dimension we have selected, the properties we can set varies.

Here is a quick summary as to which properties are enabled.

Item Name Item Value Explanation
AttributeAllMemberName
Collation
CurrentStorageMode Molap
DependsOnDimension Specifies the dimension that this Dimension depends on
ErrorConfiguration
ID
Language
Name
ProactiveCaching ROLAP/HOLAP/MOLAP
ProcessingGroup ByAttribute
ByTable
ProcessingMode Regular
LazyAggregations
ProcessingPriority
ProcessingRecommendation
ProcessingState
Source
StorageMode Molap Molap
Rolap
InMemory
Type Regular
Time
Geography
Organization
BillofMaterials
Accounts
Customers
Products
Scenario
Quantitative
Utility
UnknownMember Visible
Hidden
None
AutomaticNull
UnknownMemberName If not specified, the default value is “Unknown” is used
WriteEnabled False False
True

Fix

From our list above, we see that none of the properties contain the Key setting.

So how do we set a Dimension’s key:

  • Access the “Solution Explorer” panel
  • Navigate to the Dimensions tree
  • Choose the Dimension
  • Double-click on your selection
  • The Dimension Structure panel is activated
  • Access the “Dimension Structure” tab
  • Select the specific Attribute that you should be the Key Attribute
  • Right click on your selection
  • And, from the drop-down menu select “Set Attribute Usage”\Key

By the way, the options available from the “Set Attribute Usage” option are:

  • Regular
  • Key
  • Parent

DimensionKeyAttribute

Crediting

Crediting Vinuthan from Aditi Technologies

Happy

Happy that I am able to capture drop-down menu options from the free version of WinSnap.

Free version of WinSpan ( 1.1.10) available @ http://www.ntwind.com/software/winsnap/download-free-version.html

Documentation available @ http://www.ntwind.com/tutorials/how-to-capture-a-popup-menu-with-winsnap.html.

References

Leave a Reply

Please log in using one of these methods to post your comment:

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