Post reply

SSAS 2016: How to run a MDX query as a different user?

  • February 25, 2017 at 1:59 am

    #401680

    Hello,

    I am trying to impersonate a user by running a sample MDX, it is important for me to be able to impersonate to have a process in place to check if Security is working well in our Tabuarl cube (we have RLS in place). However, I can impersonate by using EffectiveUserName either by browsing or from Excel, but I would like do the same within MDX so I can automate the process. This is a sample query

    WITH MEMBER [Measures].[UserName] AS USERNAME()
    {
            [Measures].[UserName],
            
    SELECT
        [Measures].[Actual],
            [Measures].[Budget]
        } ON 0,
        NON EMPTY ([Geography].[Area].CHILDREN) ON 1
    FROM [Model]

  • February 25, 2017 at 5:04 am

    #1930313

    This might help
    😎

    Forum FAQ: How do I impersonate another user to test the MDX query in SSMS?

  • February 25, 2017 at 10:42 am

    #1930330

    Thanks Eirikur for the response. However, I am looking for using EffectiveUserName programmatically, not by manually launching SSMS and providing the user alias by using EffectiveUserName. I looked up online to find out an option to run an MDX query with no luck. I am basically looking for similar versino of "EXECUTE AS LOGIN" of SQL in MDX query

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply