Forum Stats

  • 3,851,556 Users
  • 2,263,999 Discussions
  • 7,904,778 Comments

Discussions

Create a request to show employees their own records only

Hi there,

In the dashboard i need to get each employee record. Those employees are assigned to security groups. I want to create a request once maybe with a filter and place it in the dashboard i created, once the employee log in he/she can see their own information, the permissions are set already in the Manage Security in the RPD. Any idea?

Regards
Tagged:

Answers

  • 681120
    681120 Member Posts: 17
    Try assinging a filter by the login Id.

    (From OBIEE help)
    To limit queries by setting up a filter on an object for a user or group

    From the Administration Tool menu bar, choose Manage > Security.
    In the Security Manager dialog box, in the tree pane, select Users or Groups.
    In the right pane, right-click the name that you want to change and select Properties.
    In the User or Group dialog box, click Permissions.
    In the User/Group Permissions dialog box, click the Filters tab.
    In the Filters tab, to add an object to filter, perform the following steps:
    Click Add.
    In the Browse dialog box, in the Names list, locate and double-click the object on which you want to filter.
    Select the object and click Select.
    In the User/Group Permissions Filters dialog box, perform the following steps:
    Scroll to the right to view the Business Model Filter column.
    Click the Business Model Filter ellipsis button for the selected object.
    In the Expression Builder dialog box, create a logical filter, and then click OK.
    In the User/Group Permissions Filters dialog box, from the Status drop-down list, select a status using Table 39 as a guide.
    Click OK twice to return to the Security Manager dialog box.
    Table 39. Query Privileges Status Fields Status Description
    Disable
    Status Max Rows or Status Max Time. When selected, disables any limits set in the Max Rows or Max Time fields.
    Filter. The filter is not used and no other filters applied to the object at higher levels of precedence (for example, through a group) are used.

    Enable
    Status Max Rows or Status Max Time. This limits the number of rows or time to the value specified. If the number of rows exceeds the Max Rows value, the query is terminated.
    Filter. The filter is applied to any query that accesses the object.

    Ignore
    Status Max Rows or Status Max Time. Limits will be inherited from the parent group. If there is no row limit to inherit, no limit is enforced.
    Filter. The filter is not in use, but any other filters applied to the object (for example, through a group) are used. If no other filters are enabled, no filtering will occur.
This discussion has been closed.