Implement Dynamic Security by Using Row Filters in SSAS tabular model to which Direct query mode is enabled

See more:

SSAS

Hi every one,

I am using SSAS 2012 to create a tabular model. While creating tabular model am enabling Direct query mode as ON ,to get Real time data from database.

Now actual problem
who ever the user accessing that tabular model should get only data which are specific to his role or his country.
when we enable the Direct query mode we are not allowed to use DAX functions to use USERNAME Function (DAX) and LOOKUPVALUE Function (DAX).

I tried with the help of msdn article http://msdn.microsoft.com/en-us/library/hh479759.aspx[^]
but finally am unable to use USERNAME Function (DAX)
So please help how to acheive solution for this problem

Thanks
RJ