none
add a dimension to the cube with MDX RRS feed

  • Question

  • We have created a custom field type text to capture the phone number of users. 

    How can we add this custom field to the cube through mdx?

    (Project Server 2007 - PWA)

    Tks!


    • Edited by Alex_ aijou Thursday, February 6, 2014 5:08 PM
    Thursday, February 6, 2014 5:05 PM

Answers

  • Hi Alex,

    Only custom fields with lookup table can be added to OLAP cubes dimensions, not free text custom fields such as your phone number field. Thus it cannot either be added to a MDX formula.

    I'd suggest you to retrieve this info through Reporting DB.

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Alex_ aijou Monday, February 17, 2014 1:01 PM
    Thursday, February 6, 2014 6:36 PM
    Moderator

All replies

  • Hi Alex,

    Only custom fields with lookup table can be added to OLAP cubes dimensions, not free text custom fields such as your phone number field. Thus it cannot either be added to a MDX formula.

    I'd suggest you to retrieve this info through Reporting DB.

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Alex_ aijou Monday, February 17, 2014 1:01 PM
    Thursday, February 6, 2014 6:36 PM
    Moderator
  • Hi Guillaume, 

    That bad news, I thought that would solve the problem with mdx.

    Tks!!

    • Marked as answer by Alex_ aijou Wednesday, July 30, 2014 4:42 PM
    • Unmarked as answer by Alex_ aijou Wednesday, July 30, 2014 4:42 PM
    Monday, February 17, 2014 1:01 PM