OLAP stored procedure error RRS feed

  • Question

  • I created a stored procedure with C# as a DLL and added it as an assembly in an OLAP database. I am trying to use one of the functions in the Dimension Allowed Member Set for a Role I created. The function returns a set of members. But whenever I try to check the syntax for the MDX, I get the following error:

    Check MDX script syntax failed because of the following error:

    An error occurred in the MDX script for the dimension attribute permission's allowed member set: Execution of the managed stored procedure FunctionName failed with the following error: Exception has been thrown by the target of an invocation.Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed..

    I tried different Security Settings for the Assembly, including:

    Impersonation Mode: Default
    Permission Set: Safe


    Impersonation Mode: Service Account
    Permission Set: Unrestricted

    But it doesn't make any difference.

    Any ideas? 
    Wednesday, February 18, 2009 7:59 PM