Error when run report

  • the function expect tuple expression for the 5 argument tuple set expression was used

    MDX I used:

    with

    member [Measures].[R0_Caption] as [Hình thức đầu tư].[Hình thức].currentmember.MEMBER_CAPTION

    member [Measures].[R0_UniqueName] as [Hình thức đầu tư].currentmember.UNIQUENAME

    member [Measures].[R0_LevelDepth] as [Hình thức đầu tư].[Hình thức].currentmember.LEVEL.ORDINAL

    member [Measures].[K0_Caption] as [Loại HSDA].[Loại].currentmember.MEMBER_CAPTION

    member [Measures].[K0_UniqueName] as [Loại HSDA].[Loại].currentmember.UNIQUENAME

    member [Measures].[K0_LevelDepth] as [Loại HSDA].[Loại].currentmember.LEVEL.ORDINAL

    member [Measures].[K1_Caption] as [Cơ quan cấp GCNĐT].[Cơ quan].currentmember.MEMBER_CAPTION

    member [Measures].[K1_UniqueName] as [Cơ quan cấp GCNĐT].[Cơ quan].currentmember.UNIQUENAME

    member [Measures].[K1_LevelDepth] as [Cơ quan cấp GCNĐT].[Cơ quan].currentmember.LEVEL.ORDINAL

    SELECT non empty

    {

    [Measures].[R0_Caption],

    [Measures].[R0_UniqueName],

    [Measures].[R0_LevelDepth],

    [Measures].[K0_Caption],

    [Measures].[K0_UniqueName],

    [Measures].[K0_LevelDepth],

    [Measures].[K1_Caption],

    [Measures].[K1_UniqueName],

    [Measures].[K1_LevelDepth],

    [Measures].[Số lượng]

    }

    ON COLUMNS ,

    Nonempty(

    crossjoin(

    crossjoin

    (

    StrToSet(@K0),

    StrToSet(@R0)

    ),

    strtoset(@K1) ),

    [Measures].[Số lượng]

    )

    on rows

    FROM [HSCNDT]

    Please help me.

Viewing 0 posts

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