How to enforce row level security on MSAS Cube

[Former Member]

We have to enforce row level security on MSAS Cube based on BOUSER.

We are using a security table which contains BOUSER ID and Location ID

We need help in joining the security table with MSAS Cube.

Thanks

[Former Member · Accepted solution]

HI,

I haven't worked with cubes. But the will the knowledge I have in Universe, could probably help you.

As you already have a table which maintains BOUSERID and location id, you could probably join location id with MSAS cube id.

If you don't want to use this userdefined security table, you can use the inbuilt Row level security option.

Go to Tools -> Manage access REstrcitions --> Create a new restriction --> Rows tabe ---> give a expression with BOUSER

Hope this helps.