September 7, 2010 at 10:23 am
Hi,
The query below was generated by query designer in ReportBuilder. When I run the report and select the (Select All) option, I receive this error:
The function expects a tuple expression for the 455 argument. A tuple set expression was used.
But if I run the report and select the ALL selection item, then the report runs fine.
Anyone have any ideas why this might happen? it doesn't look like I can remove the (Select All) option from the param dropdown. If that were possible then this problem would go away.
SELECT NON EMPTY {
[Measures].[Measure1],
[Measures].[Measure2],
[Measures].[Measure3],
[Measures].[Measure4] } ON COLUMNS,
NON EMPTY { ([Segment].[CMkts].[Segment].ALLMEMBERS * [Ter].[Territories].[TK].ALLMEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@PERDN, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [SP].[Source Type].&[Trans] } ) ON COLUMNS FROM [Sales])) WHERE ( [SP].[Source Type].&[Trans], IIF( STRTOSET(@PERDN, CONSTRAINED).Count = 1, STRTOSET(@PERDN, CONSTRAINED), [Product].[ERDName].currentmember ))
September 7, 2010 at 12:40 pm
Fixed it like this:
SELECT NON EMPTY {
[Measures].[Measure1],
[Measures].[Measure2],
[Measures].[Measure3],
[Measures].[Measure4] } ON COLUMNS,
NON EMPTY { ([Segment].[CMkts].[Segment].ALLMEMBERS * [Ter].[Territories].[TK].ALLMEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@PERDN, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [SP].[Source Type].&[Trans] },IIF( STRTOSET(@PERDN, CONSTRAINED).Count = 1, STRTOSET(@PERDN, CONSTRAINED), [Product].[ERDName].currentmember ) ) ON COLUMNS FROM [Sales]))
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply