A
avididy
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!
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!