July 3, 2013 at 10:09 am
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