SQL Server Performance

Write-Enabled feature?

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Jan 5, 2005.

  1. Joozh New Member

    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.
  2. satya Moderator

    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.
  3. Joozh New Member

    Thanks for the reply. Unfortunately the article is not for public viewing <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br /><br />Anyway, I will try to play around with the feature and read from BOL etc.<br /><br />Appreciate your reply.<br /><br />Regards.

Share This Page