Adding a simple custom text field to a cube in Project Server RRS feed

  • Question

  • How to add a simple custom text field to a Cube from Project Server? 
    I have a field called Portfolio, is a simple text field and would like to add it to the cube to use it as a filter in a report. Any suggestions?


    Tuesday, June 24, 2014 1:42 PM


  • Hello,

    Free text fields can't be added using out of the box configuration - you would either need to programmatically extend the default cube or build your own custom OLAP cube. What is the purpose of the Portfolio field? If this tags the portfolio that the project belongs to wouldn't a lookup table be better suited? That could then be added to the OLAP cube configuration (PS2007, 2010, 2013).


    Paul Mather | Twitter | | CPS

    • Marked as answer by Torres_ Monday, June 30, 2014 12:37 PM
    Tuesday, June 24, 2014 2:55 PM