SQL Server Performance Forum – Threads Archive

Write-Enabled feature?

Hi, While reading (I have come across what seems to be maybe a powerful and useful feature) available in MSAS and thus this related question: Can someone briefly explain the use of this feature and how it can come in handy. So far I have skimmed through BOL and it says that "Only parent-child dimensions support this dimension characteristic" i.e. Write-enabled feature.
Thanks.

One of the MSDN article refers:
A write-enabled dimension allows end users to modify the contents of the dimension and see the immediate impact on the cube. This ability provides added analytical options to end users. For example, in an Employee dimension, an end user can move the employee members beneath different managers to assess the changes on measures such as Budget and Staffing Level. Only parent-child dimensions support this dimension characteristic. Be aware this feature is only available with Enterprise Edition of SQL.
Write-enabled dimensions and write-enabled cubes have different but complementary features. A write-enabled dimension gives end users the ability to update members, whereas a write-enabled cube gives them the ability to update cube cells. Using these two features in combination is optional. http://www.windowsitpro.com/SQLServer/Article/ArticleID/39887/39887.html for your reference. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for the reply. Unfortunately the article is not for public viewing <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> Anyway, I will try to play around with the feature and read from BOL etc. Appreciate your reply. Regards.

]]>