Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error when run report Expand / Collapse
Author
Message
Posted Wednesday, July 03, 2013 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 03, 2013 10:06 AM
Points: 1, Visits: 1
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.
Post #1470147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse