A
Avi
I have created two Task level cost custom fields which are not showing up in
the PS 2007 cube as measures (darn it). When I go to cube configuration, the
fields show up in the assignment cube as measures (not sure why assignment
cube and not task cube). I add them as selected measures and re-build. They
show up in the assignment non timephased cube ONLY. Which does not help my
case. I was hoping they show up in the time phases cube, especially
MSP_Portfolio_Analyzer. The way the fields are defined are as below
Task 1 cost - All default except Calculation for Summary Rows: rollup Sum
Task 2 cost - All default
Per this article http://msdn2.microsoft.com/en-us/library/ms447495.aspx,
"Cube Build Service support for custom fields as measures" (figure 10)
mentions Task cost type custom field w/ no lookup table and formula used
should show up on the cube.
Any help on this issue will be appreciated. I have tried adding data to the
fields, save/publish, re-build of the cube etc. If anyone has a link which
explain the PS 2007 cube configuration and what can be added/not added that
will be much appreciated too.
Thank you!
the PS 2007 cube as measures (darn it). When I go to cube configuration, the
fields show up in the assignment cube as measures (not sure why assignment
cube and not task cube). I add them as selected measures and re-build. They
show up in the assignment non timephased cube ONLY. Which does not help my
case. I was hoping they show up in the time phases cube, especially
MSP_Portfolio_Analyzer. The way the fields are defined are as below
Task 1 cost - All default except Calculation for Summary Rows: rollup Sum
Task 2 cost - All default
Per this article http://msdn2.microsoft.com/en-us/library/ms447495.aspx,
"Cube Build Service support for custom fields as measures" (figure 10)
mentions Task cost type custom field w/ no lookup table and formula used
should show up on the cube.
Any help on this issue will be appreciated. I have tried adding data to the
fields, save/publish, re-build of the cube etc. If anyone has a link which
explain the PS 2007 cube configuration and what can be added/not added that
will be much appreciated too.
Thank you!