The PRJ_RESOURCES table has a field called PRPARENTID which is the parent role of a role. I cannot find that field in the DWH. It is also not possible to check the box to Include in Data Warehouse. Is it available in the DWH?
You are correct, the Parent Role field is not available to be included in Data Warehouse. You could do the following:
The workaround should work in the meantime whilst Product Management are evaluating your suggestion.
Hope this helps -Nika
Thanks for the response Nika.
I did attempt option 2 but I do not see the Parent role field in the dropdowns to be selected in a calculation . I guess I am left with option 1.
Try to create the Calculated attribute by specifying the column. Here is an example:
This will allow you to get the value to Data Warehouse. Please note though that the value will be the internal ID so when you build your reports you have to create a join over it to get the Role Name in text.
The calculated field solution worked! Thanks for your help.
Retrieving data ...