PFE_MDX_UPDATE_MEMBER_SCOPE

Details

Product Name

SQL Server 

Product Version

9.x; 10.x

Product Build Number

Any

Event ID

 

Event Source

Not applicable

Component

Analysis Services Microsoft.AnalysisServices.AdomdServer

Symbolic Name

PFE_MDX_UPDATE_MEMBER_SCOPE

Message Text

Only session calculated members can be updated.

Explanation

This error message occurs when the application tries to update a global calculated member. Updates to a global calculated member are not supported by Analysis Services.

User Action

Make sure the Multidimensional Expressions (MDX) statement, UPDATE MEMBER, is used only on members that are created in the context of the current user session. To know whether the scope of a calculated member is global or session, query the MDSCHEMA_MEMBER rowset and verify the SCOPE column.