Can't add a sibling or child to a member in a dimension

Following the Foodmart tutorial, I get to a point where I create a parent-child dimension and I browse data. Then I have to add a sibling or a child by right-clicking a member and selecting "New member" (all in the Dimension Editor). However, nothing happens on my right-clicking, no context menu at all. Could it be a versioning issue? I'm using SQL Server 2000 Standard edition. I already found out I can't use the writeback feature in this version...

Thanks and happy holidays!

Ale

Hi Ale,

I think that you need Enterprise Edition, since the right-click menu is only available after the dimension's Write-enabled property is set to True:

http://msdn2.microsoft.com/en-us/library/aa198057(SQL.80).aspx

>>

Analysis Services

Write-Enabled Dimensions

...

Note This feature is available only if you install Analysis Services for Microsoft? SQL Server? 2000 Enterprise Edition.

...

To write-enable a dimension, set its Write-enabled property to True in the properties pane of Dimension Editor (if the dimension is shared) or Cube Editor (if the dimension is private).

>>

|||That makes a lot of sense, thanks Deepak!