Dynamic Dimension Security Limitations And Performance When Using Custom Dll (UDF)

Hi,

I've created a custom dll using ADOMD.net that takes in a few parameters (Username being one of them) and returns a set of Allowed Members to apply dynamic dimension security. Example:





Code Snippet

Security.GetSetList(UserName,1,"SQL Server")

This works fine for users with less than, say, 100 tuples/members in their set....however for users with more an error:

Error ocurred retreiving child nodes: The 'S' attribute in the 'S' dimension has a generated dimension security expression that is not valid. ...


However, if I take the same set and explicitly (ie


Code Snippet

{[S].[1],[S].[2],.......[S].[50000]}) put it in the Allowed set there's no issue!

I noticed that it takes the UDF a couple of seconds longer to return for users with a large security context. Is there a time-out parameter that controls this? Is there a limitation in the amount of members I can add via custom dll (UDF)? (Some users can have up to 70,000 members)

I should also mention that the UDF uses the StrtoSet function to convert the security context string to a set. The string can be as large as 210,000 characters. Is there a limitation on the string size that can be passed in this function?

Any assistance would be greatly appreciated.

Thanks!!