2007 OLAP Cube

[Michael Brown]

We've begun working with our OLAP cube data and Excel - so far so good. Many
of the reports we need for finance are based of the TIMESHEET cube and/or
tables. There is much good information there, but the one thing that seems
to be missing in the resource list information in particular - are the custom
fields we've set up on the resource list.

For example, we've defined fields for organization, team, vendor (for
contractors), etc. These attributes don't appear to be accessible in the
cube. I can dump the entire resource list and pick off individuals, but I
don't have a way of filtering that list by team, organziation, etc. when
viewing timesheet data. These dimensions ARE available for Project data
(assignments, etc.), but not timesheet data. Am I missing something? Is
there a way to expand this cube?

 

[Mike Mahoney]

We've begun working with our OLAP cube data and Excel - so far so good. Many
of the reports we need for finance are based of the TIMESHEET cube and/or
tables. There is much good information there, but the one thing that seems
to be missing in the resource list information in particular - are the custom
fields we've set up on the resource list.

For example, we've defined fields for organization, team, vendor (for
contractors), etc. These attributes don't appear to be accessible in the
cube. I can dump the entire resource list and pick off individuals, but I
don't have a way of filtering that list by team, organziation, etc. when
viewing timesheet data. These dimensions ARE available for Project data
(assignments, etc.), but not timesheet data. Am I missing something? Is
there a way to expand this cube?

Michael

Custom project and resource attributes though apparently in the main
timesheet cube are not available. I believe its a "join" issue. You
need to build a custom cube to make this happen.

regards

Mike

 

[Michael Brown]

I think you're spot on. Have you ever ventured into this? Any idea's on how
this might be accomplished?

 

[Mike Mahoney]

I think you're spot on. Have you ever ventured into this? Any idea's on how
this might be accomplished?





- Show quoted text -

Michael

The data you require is available in existing olap views in the
reporting database. It's simply a matter of creating additional views
based on these but with the correct joins so all data is available in
your view. You can they create a custom cube based on this data. Use
the construction of the Project Server cubes as a guide to doing
this. You will then need to ensure the cube is built when required.
Many people do this programmatically. Because you don't need to create
new data tables it is possible to take a manual approach and work
within the Analysis Services interface to get a result.

regards

Mike