Security at row/record level in Framework Manager model

[Prad]

Hi All,

I have a requirement and the requirement goes like this:

1. There will be only one table and in this table there will be user id's
2. Based on the user id I need to fetch the record and create a report
3.There will different user logs and when they run the report, they should see only there data.
4. I don't want to do this in Report Studio. I want to do this in FM model.

How to perform this task......not sure. So, I need your help.

Thanks,
Prad

[sir_jeroen]

have you tried using a Macro in your fm model?
That should work...

[bdybldr]

Prad,
Have you found a solution to this issue?  Please keep us updated.

[Prad]

Not yet and the requirement is not yet freezed.

Thanks,
Prad

[mrcool]

Hi alll...Hope this helps a little..

Add Data Security
You can restrict the data represented by query subjects in a project by creating a security filter. The security filter controls the data that is shown to the report authors when they set up their reports.

For example, your Sales team consists of a Sales Director, and four Sales Managers. You create a security filter that includes the groups directors and sales managers, and apply the filter to the salary query subject. When the package is available for report authors, and a report is generated for the Sales Managers and the Sales Director, only the Sales Director can see the salary information for the sales managers.

You can base the security filter on existing security filters. If you choose this option, the security filter inherits the filter, and all the filter properties.

When you create a security filter, you can also use existing project filters, or create new filters using the Expression Editor. For more information, see Create a Filter.

For more information about groups, see Add a User, Group, or Role.

Steps
Right-click the query subject you want, and click Specify Data Security.
To add new users, groups, or roles, click the Add Groups button.
For more information, see Add a User, Group, or Role.
If you want to base the group on an existing group, click a group in the Based On column.
Tip: If you do not see the group you want in the list, you must add the group to the security filter.
If you want to add a filter to a group, in the Filter column, click either Create/Edit Embedded Filter or Insert from Model.
Click OK.

[mrcool]

Hi...Please update the status....