Dynamic Filtering

[Francis aka khayman]

I have FM model that have a security filter in a data item/fact table. Basically it takes a value from session parameters,username, and filters my fact table against that username. This is because the functionality I want is to let the user see his/her own data only when running a report.

Now I want to implement the same functionality in a cube for better performance. My initial attempt is that when I generate my cube, the data is filtered against my user name.

I was wondering how this could be done in the cube just like in FM model

Or is my best option to filter on the report itself?

[bdbits]

In my experience, cube security is normally accomplished with custom views (using apex, suppress, summarize, etc.) to which you assign users/groups. These custom views and who has permissions to them are hard-wired into the cube at the time it is built. At runtime, the cube results are filtered through the views according to who Cognos thinks you are (authenticated) and what group memberships you have that match the view permissions in the cube.

So if you want to filter data to the user, you would need to create a set of custom views for that user, then assign them access privileges to those views. Hopefully you do not have too many users.