B
Bonnie
My goal is to generate a report using timesheet data that summarizes totals
by a custom task field.
I had created a custom enterprise field at the task level that contains a
text code. These codes are used throughout various projects.
I know that there is no out of the box solution and that this data is not in
the EPM Timesheet cube. I currently have a way of using SQL queries to join
the Task information to the custom field (thanks Rod!) and export standard
data out to an excel spreadsheet. But, it is not a great solution since it
requires an intermediary to run any type of data rather than allowing the
end-user exec or finance to be able to view the data.
Anyone know how I can customize a view so that this pivot report can be
generated like any other under data analysis?
by a custom task field.
I had created a custom enterprise field at the task level that contains a
text code. These codes are used throughout various projects.
I know that there is no out of the box solution and that this data is not in
the EPM Timesheet cube. I currently have a way of using SQL queries to join
the Task information to the custom field (thanks Rod!) and export standard
data out to an excel spreadsheet. But, it is not a great solution since it
requires an intermediary to run any type of data rather than allowing the
end-user exec or finance to be able to view the data.
Anyone know how I can customize a view so that this pivot report can be
generated like any other under data analysis?