Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saeedehgh88
Starting Member
1 Post |
 Posted - 2012-06-01 : 06:18:59
|
Hi every one I write blow code in data set of second parameter (Child parameter) but when I run report, child drop down list do not have affected from parent drop down list javascript:insertsmilie(' ')what is problem?NOTE: @SubjectCategoryTypeNameParam is parent parameter.---WITH MEMBER [Measures].[ParameterCaption] AS [Dim Subject Category].[Category Name].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Dim Subject Category].[Category Name].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Dim Subject Category].[Category Name].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Dim Subject Category].[Category Name].ALLMEMBERS ON ROWS FROM (SELECT {STRTOSET(@SubjectCategoryTypeNameParam)} ON COLUMNS FROM [1888 DW]) WHERE ( IIF( STRTOSET(@SubjectCategoryTypeNameParam, CONSTRAINED).Count = 1, STRTOSET(@SubjectCategoryTypeNameParam, CONSTRAINED), [Dim Subject Category Type].[Subject Category Type Name].currentmember ) )---Best Regards---prophet Mohammad:The best thing next to the faith in God is friendship with people. |
|
|
|
|
|
Problem in Cascading Parameters