Hi davoscollective,
Thank you for your answer. Very helpful.
But my chief doesn't want to work with dataset expression.
So, I think that the problem is not the multi-value parameters. I solved the multi-value problem with this method: http://saldeloera.wordpress.com/2013/02/07/ssrs-how-to-straightforward-method-to-pass-mdx-multi-select-parameters-to-mdx-datasets/
Because with my mdx dataset test:
WITH
-- Geography metadata
MEMBER [Measures].[Geographie]
AS StrToValue ( @SelectionGeographie + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Geographie_Label]
AS StrToValue( @SelectionGeographie + ".Hierarchy.CurrentMember.Member_Caption" )
SELECT NON EMPTY {
[Measures].[Geographie],
[Measures].[Geographie_Label],
[Measures].[11 VA]
} ON COLUMNS,
( STRTOSET ( "{" + @SelectionGeographie + "}") ,
STRTOSET ("{" + @SelectionActivite + "}" ))
ON ROWS
FROM [MyCube]
WHERE STRTOTUPLE ( "(" +@Annee + "," + @Perimetre + ")" )
1- When I put one value parameter, I have the result on both columns and rows. That works perfectly.
No errors, no "null" result .
2- but when I put multi-value parameters , I have result only on rows.
I have no errors but I have a "null" result on columns.
I think that the problems are from the .currentmember.uniquename functions. Any idea ?
Thank U