none
Displaying a message instead of blank Chart when MDX query retirned no data RRS feed

  • Question

  • Hello,

    I am developing a Analytical CHart using customized MDX query. But whenver MDX query is returning no data for the specified condition from CUBE, blank report is shown with just X-Axis.

    Could you please help me in displaying a message in these scenarios instead of displaying blank report with just X-Axis that too which is looking tatally odd on the dashboard.

    Thanks

    Friday, October 7, 2011 7:35 PM

All replies

  • Try using NONEMPTY function in your MDX query to limit any tuples showing up. Eventually this tuple contributes to the X-Axis.
    http://dailyitsolutions.blogspot.com/
    Friday, October 7, 2011 7:44 PM
  • Hello,

    I am using the following query. But in some of the condition it is just displaying the X-Axis with MonthlyEarned label. Please correct me where am i doing wrong

     

    WITH

    MEMBER

    [Measures].[MonthlyEarned]

    AS

    (

    SUM([Logical Currency].[Logical Currency Code].&[Project],

     

    SUM([Result Unit].[Result Unit Code].&[TotalCost],

     

    SUM({Head({Order({Filter({[Period].[Period Calendar Period Name].[Period Calendar Period Name].Members },

     

    NOT IsEmpty([Measures].[BCWP Current Period] ))},[Period].[Period Calendar Period Name].MemberValue,BDESC)},2)}.ITEM(0),

     

    [Measures].[BCWP Current Period] )))) /

     

    (

    SUM([Logical Currency].[Logical Currency Code].&[Project],

     

    SUM([Result Unit].[Result Unit Code].&[TotalCost],

     

    SUM({Head({Order({Filter({[Period].[Period Calendar Period Name].[Period Calendar Period Name].Members },

     

    NOT IsEmpty([Measures].[BCWP Current Period] ))},[Period].[Period Calendar Period Name].MemberValue,BDESC)},2)}.ITEM(0),

    [Measures].[BAC] ))))

     

    SELECT

    {[Measures].[MonthlyEarned]} on Columns,

    ([Logical Currency].[Logical Currency Code].[ALL])

    on Rows

    FROM

    [CUBE]

    WHERE

    ( [Revenue Package].[Revenue Package Number].&[112012],

    [Functional Group].[Functional Group Name].&[Construction],

    [Project].[Charge Number].&[112012.1000.C.02],

    {

    Except([Group].[Group Code].[All].CHILDREN,{[Group].[Group Code].&[CT],[Group].[Group Code].&[MR]})} )

     
    Friday, October 7, 2011 8:50 PM
  • Can i display a message saying "No data exists" in these scenarios atleast is query is not returning the data

    Friday, October 7, 2011 8:53 PM