Demand, Project, Resource Plan database view

Mai Hirokawa
Giga Contributor

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.

 

find_real_file.png

1 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.

 

find_real_file.png

View solution in original post

5 REPLIES 5

Thank you so much for your response,

We need to recreate our client's Excel report on servicenow and

Resource Reports doesn't meet their requirements.

However We will think of using them for different purpose.

Thanks