Post reply

MDX Question

  • April 30, 2015 at 12:55 am

    #307532

    Hi

    I am new to MDX.

    I have this

    select [Project].[Project Phase].members on columns

    , non empty ([Project].[Department].children, [Date].[Month].[Month]) on rows

    from theCube

    At the minute it looks like a count as the values but id like to put Project.Cost.Cost as the value

    could anyone help please

    thanks

  • April 30, 2015 at 1:34 am

    #1794582

    SELECT

    { [Project].[Project Phase].Members, Project.Cost.Cost } ON COLUMNS,

    NON EMPTY

    { [Project].[Department].Children, [Date].[Month].[Month] } ON ROWS

    FROM theCube

    Igor Micev,My blog: www.igormicev.com

  • April 30, 2015 at 1:45 am

    #1794586

    thanks a lot

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply