none
Custom Fields and OLAP Cubes - PS2007 RRS feed

  • Question

  • Hi!

    I can include a custom field directly to olap cube per database? 

    I need have these fields (without lookup table) in olap cube "Portfolio_Analyzer"

    Tks.

    Monday, February 24, 2014 6:23 PM

Answers

  • Hi Alex,

    In the OLAP section of the server settings, you can add custom field by types (projects, tasks, resources or assignments). Note that free text fields CANNOT be added to OLAP cubes (refer to the links I give you at the end of my reply). You just have to select the CF and to add it to the right part:

    Note that you have to differenciate measure and dimension:

    • Cube Dimensions Specify the custom fields you want to add to the OLAP database as dimensions. The selected custom fields will be added to both timephased and non-timephased cubes, when applicable. 
    • Cube Measures Specify the custom fields you want to add to the cube as measures. The selected custom fields will be added to the related Non-Timephased cube.

    Finally you can add MDX expression (new measures created with formulas based on existing fields) to any of the 14 cubes.

    Please find some useful links below (some are for PS2010, but still applicable):

    • http://technet.microsoft.com/en-us/library/cc197614(v=office.12).aspx
    • http://technet.microsoft.com/en-us/library/cc197728(v=office.12).aspx
    • http://msdn.microsoft.com/en-us/library/office/ee767696(v=office.14).aspx
    • http://blogs.msdn.com/b/brismith/archive/2010/09/01/project-server-2010-olap-where-are-my-custom-field-dimensions-and-measures.aspx
    • http://office.microsoft.com/en-us/project-server-help/set-up-and-manage-olap-cubes-for-the-portfolio-analyzer-HA010074911.aspx#BM2

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS


    Monday, February 24, 2014 6:43 PM
    Moderator