Task (cost) custom fields not showing up in cube measures

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!
 
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 articlehttp://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 tothe
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!


I just found the answer to my question (even though I was hoping this
was not the answer)

Only non-timephased cubes can contain calculated measures.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top