August 3, 2006 at 4:36 am
I know that what I need is cascading parmeters but I cant seem to find way of doing it. Below is the MDX code from the second parameters Dataset. I need to filter this dataset by the first paramter which is @p1. I am using rs 2005 and as 2005.
Any Help or pointers greatly appreciated.
WITH MEMBER [Measures].[ParameterCaption] AS '[Broker Contact].[Full Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Broker Contact].[Full Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Broker Contact].[Full Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Broker Contact].[Full Name].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@p2, CONSTRAINED) ) ON COLUMNS FROM [Any Cube])
August 7, 2006 at 8:00 am
This was removed by the editor as SPAM
August 10, 2006 at 8:14 am
Hey Jules,
NOt sure I'm following 100% but onthe cascading params side, normally this would be done within RS. That is, you the order in which the parms are shown on the parms screen (vertically) sets the cascading-ness (is that a word!?!) of the parms. You may need to use a dynamic dataset (ie the dataset is like ="some statement here " & Parm1.Value & "....." ), basically this is string manipulation.
HTH,
Steve.
August 11, 2006 at 7:40 am
Steve,
thanks alot for this
have a look at the reporting services forumn if you have a chance
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=299248
Any help greatly appreciated,
Jules
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply