Demand, Project, Resource Plan database view

[Mai Hirokawa]

Hello,

I would like to create a report showing monthly FTE per Demand/Project and try to make a database view combining Demand, Project, Resource Plan, Resource allocation table.

However when I try it, no record is shown.

Would anyone help me with this issue?
Thank you in advance.

[Saurav11]

Hello,

You do not need to create a new database view.

You can just create the report on resource_allocation table and you will be able to access resource Plan-> Project-> Demand.

Steps:-

Create a report on resource_allocation

Then in the fields column using the resource plan[+] you can bring all the resource plan field on the list view

Then in The resource plan you can use the task[+] to get the fields of Project or Demand depending on for what the Resource has been made.

And then you can go from Demand to project fields or Project to demand fields as well,

Please mark answer correct/helpful based on Impact. 

[Mai Hirokawa · Accepted solution]

Thank you so much for your response,

However even when access to resource Plan-> Project-> Demand,

Custom items on Demand/Project tables aren't shown on the list.

I created database view like this and apparently it worked.

[Saurav11]

I see.

Glad you found the answer though.

Thanks.

Mark your answer as correct and close the thread for future readers

[Rajesh_Singh]

You can refer solution referred by Saurav or go to Resources > Resource Reports