Hi Dilip,

You do NOT need to assign the duty roles. The duty roles are inherit by the job role. Revoke the 3 duty roles you have granted then from the list for this subject area grant the required job role(s). The job roles are required because they contain the data security that give access to data. But as suggested by Praveen you do also need to setup manage data access for users.

They duty roles are listed in the user guide for a subject area for information only so you know which duty roles you might need in a custom role to use a subject area. Here is the user guide for this subject area.

So as you can see you need one of the following job roles to "use" the subject area.

For information only you know the above roles inherit the following duty roles that allow you to query this subject area without error.

If you were not granted one of these job roles which inherit this duty role(s) then when you query this subject area it will throw a database connection error because you are not allowed to use it. Because your query was a success, it did not throw an error, it returned zero rows then you know you have been granted the correct roles. No data found is the expected result for many of the subject areas. That is a successful query.

A role does not give access to data in subject areas in ERP. HCM subject areas are different because it uses data roles. But in a subject area like this one in ERP the job role contains data security policies. These data security policies are used by the subject area to add a where clause to your query at run time for data security. For example, the data security policy for grant on business unit will allow you to see only projects for the business units to which your user has access to for this job role. Assume you have not setup any data access therefore get no rows.

You can view the data security where clause for your user by cut paste your logical query from the advanced tab of you analysis then go to page issue sql then view the manage sessions log to see the physical query(ies) that the metadata repository database sent to the application databases to get the data. To go to this page make sure your bi administrator has granted using manage privileges your user or role "Issue sql directly" and "manage sessions".

Ok so now you know why you get no data! How do you get data? You need to go to the Navigator then in folder My Enterprise select work area Setup and Maintenance. Then go to task Manage Data Access for Users. Here grant your user with the job role, for example, Project Accountant to one or more security context, for example, if the job role has a data security policy for business unit, then grant one or more business units. Sorted?