none
MDX Query Filter in PPS Dashboard Designer RRS feed

  • Question

  • Hi,

    In PPS dashboard, I need to filter a list of items (projects) based on a status value. The data come from an OLAP cube in  SQL Server 2008 R2.

    On SSMS, the following query gives the good result :

    Select non empty [Measures].[Project Count] on columns,
    non empty  [Project List].[Project List].members on rows
    from [Project Non Timephased]
    where [Statut_Projet].[Statut_Projet].&[{BAF8E0E7-07A8-4DEA-BC31-BFBD481F54DA}]

    To use this query in PPS, I made the following "translation" :

    filter ([Project List].[Project List].[Project List Level 02].ALLMEMBERS,
    [Statut_Projet].[Statut_Projet].&[{BAF8E0E7-07A8-4DEA-BC31-BFBD481F54DA}])

    The issue is that query works but doesn't give the same result, some items are missing.

    I really don't know what to do and any help is welcome !

    Yves

    Sunday, February 7, 2016 12:50 PM