March 3, 2013 at 2:03 am
Hi ALL,
I need your your help!!
I want to create a report with multi-value parameters with SSRS.
So, I wrote this mdx script:
WITH
-- Geography metadata
MEMBER [Measures].[Geographie]
AS StrToValue ( @SelectionGeographie + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Geographie_Label]
AS StrToValue( @SelectionGeographie + ".Hierarchy.CurrentMember.Member_Caption" )
-- Activity metadata
MEMBER [Measures].[Activite]
AS StrToValue( @SelectionActivite + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Activite_Label]
AS StrToValue( @SelectionActivite + ".Hierarchy.CurrentMember.Member_Caption" )
-- Date metadata
MEMBER [Measures].[Temps]
AS StrToValue( @Annee + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Temps_Label]
AS StrToValue( @Annee + ".Hierarchy.CurrentMember.Member_Caption" )
-- Perimetre metadata
MEMBER [Measures].[Perimetre]
AS StrToValue( @Perimetre + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Perimetre_Label]
AS StrToValue( @Perimetre + ".Hierarchy.CurrentMember.Member_Caption" )
SELECT NON EMPTY {
-- display the parameters attributes on columns
[Measures].[Geographie],
[Measures].[Geographie_Label],
[Measures].[Activite],
[Measures].[Activite_Label],
[Measures].[Temps],
[Measures].[Temps_Label],
[Measures].[Perimetre],
[Measures].[Perimetre_Label],
[Measures].[11 VA]
} ON COLUMNS,
( STRTOSET ( "{" + @SelectionGeographie + "}") ,
STRTOSET ("{" + @SelectionActivite + "}" ))
ON ROWS
FROM [MyCube]
WHERE STRTOTUPLE ( "(" +@Annee + "," + @Perimetre + ")" )
But It works with one value in parameter and not with muti-value parameters.
I have null result in my metadata members when I have multi value.
Any idea ?
Thank
March 3, 2013 at 3:34 am
Noone ? : (
I don't know why That works when I have only one parameter and not with many parameters ? is it possible to use the uniquename functions with muti-value ?
March 3, 2013 at 9:55 pm
yes. sorry
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy