Data Analysis views from the 3 Timesheet cubes using Customized Fi

[Tom B]

PS 2007 SP1,
OK, I have built project plans, created and submitted timesheets with hours
reported, then built Data Analysis views from all three timesheet cubes...
1) MSP_Project_Timesheet (project specific, no admin time, but has
customized fields available (if built from lookup tables, this is the cube I
want to build Data Analysis views from)

2)EPM Timesheet(project specific work, includes standard timesheet class, no
customized Project, Task or Resource fields)

3) Timesheet(Includes all time, both standard and other timesheet classes,
includes a project plan called Administrative time (which I call 'below the
line' from the timesheet view).

Of these 3 cubes only the MSP_Project_Timesheet cube provides Project
specific data, AND any customized enterprise fields for Project, Task and
Resource. I want to build a Data Analysis view using the customized
fields(that have lookup tables)..but when I build the view, and filter, or
organize the rows or columns in a pivot table, using one of the customized
fields, my view goes blank with no data, if I simply use the standard
timesheet data fields, my data comes back into view...I know I have tasks and
resources that use the specific customized fields and values! just can't get
them to display.

I have tested with one project plan, where resources have reported timesheet
data against, let's say 100 hours... I get the 100 hours in my views...it
balances to what I expect, that is a good thing...but the moment I try to
organize the 100 hours now by one of the customized fields for Project, Task
or Resource...the view goes blank.
I have verified that I have a task using customized values from a lookup
table and resources see that task on their timesheet and they report time
against it, I just can't get those customized task values to display in rows
or columns of my Data Analysis views?

Any suggestions to remedy this? Am I missing something?
Thank you for your time in reviewing this and responding.
TomB

 

[Mike Mahoney]

PS 2007  SP1,
OK, I have built project plans, created and submitted timesheets with hours
reported, then built Data Analysis views from all three timesheet cubes....
1) MSP_Project_Timesheet (project specific, no admin time, but has
customized fields available (if built from lookup tables, this is the cube I
want to build Data Analysis views from)

2)EPM Timesheet(project specific work, includes standard timesheet class,no
customized Project, Task or Resource fields)

3) Timesheet(Includes all time, both standard and other timesheet classes,
includes a project plan called Administrative time (which I call 'below the
line' from the timesheet view).

Of these 3 cubes only the MSP_Project_Timesheet cube provides Project
specific data, AND any customized enterprise fields for Project, Task and
Resource.  I want to build a Data Analysis view using the customized
fields(that have lookup tables)..but when I build the view, and filter, or
organize the rows or columns in a pivot table, using one of the customized
fields, my view goes blank with no data, if I simply use the standard
timesheet data fields, my data comes back into view...I know I have tasksand
resources that use the specific customized fields and values!  just can't get
them to display.

I have tested with one project plan, where resources have reported timesheet
data against, let's say 100 hours...  I get the 100 hours in my views....it
balances to what I expect, that is a good thing...but the moment I try to
organize the 100 hours now by one of the customized fields for Project, Task
or Resource...the view goes blank.
I have verified that I have a task using customized values from a lookup
table and resources see that task on their timesheet and they report time
against it, I just can't get those customized task values to display in rows
or columns of my Data Analysis views?  

Any suggestions to remedy this?  Am I missing something?
Thank you for your time in reviewing this and responding.
TomB

Hi Tom

Your analysis is correct. Your only option is to build a custom cube
wich has the correct joins or to use SSRS and create your own query.

regds

Mike

 

[Tom B]

Thanks Mike, I was afraid of that. Appreciate your feedback so quickly.
Tom