Creating a Data Analysis view with Custom field and EPM Timesheet

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top