Custom Cols not showing data in data analysis/cubes

[Terminator]

Hi,

We have created custom cols at task and project level but we are not able to
extract info for these cols in the data analysis cube... can anyone help?

Thanks

Terminator

 

[Gary Chefetz]

Have you added your custom totals and dimensions to the cube configuration?

 

[Terminator]

Yes.. we have.. I can see the custom cols in the cube but when I select these
cols in MSP_Project_Timesheet cube along with Actual Work Billable column
then the Actual Work Billable column does not show any value.

Thanks for your response!!!

Terminator

 

[Gary Chefetz]

Do they behave the same way in the Portfolio Analysis Cube? Trying to get to
the bottom of this in a NG post is a potential rat hole. In order for data
to appear in the fields, they must be setup correctly, they need to be
populated with data for the projects and tasks to which they apply and these
values must be published. There are also some known issues with the cube
views where values disappear when you add some dimensions to the view. If
this is what you're seeing, then patching SQL Server and Analysis Services
to the latest updates is highly recommended as well as bringing your Project
Server to SP2 + August CU.