SPunk
Legacy Member
uitleg staat in het engels, omdat ik al een paar forums heb afgeschuimd (msdn enz) en nergens een antwoord krijg.
Hopelijk hier meer geluk
dus -->
Hi
I am making a report that has 2 different cubes as data source.
the reason for this cube is to compare data from cube A to cube B.
The user can start with selecting a customer name.
Via a subreport, cube A is linked to cube B. (parameter link).
Now i need cascading parameters, i read all the msdn manuals, and googled a whole day.
But i cant find it.
My subreport parameters are non-queryd, cus they get data from the main report.
so i cant cascade them there.
If a customer is chosen, they need to see the contractnumbers that match with that customer.
But i get all the contractnumbers.
I link to my subreport with following parameter link :
contractnumber (only located in subreport, not available in main report(so i need to link it with another dataset in my mainreport))
&
The main report has the same parameters as the subreport.
The parameter customer is linked with eachother. So cube customers from cube 1 is linked with a intern table to the customers of cube 2.
I link it through the parameter. So when i choose a customer from cube1, the subreport auto search the customer from cube 2 (subreport).
Now i added the parameter contractnumber in the subreport, that parameter only exist in the data of the subreport, but i need to get it in the main report.
So i added a extra data set to the main report, with that contractnumber, and linked it also with an expression
So now the main report, searches the contractnumbers in the subreport, the bad part is, they main report shows ALL the contracts of ALL the customers.
I need to select a customer and then get the matching contractnumbers.
&
If i use in my contractnumber pamareter :
strtomember(@customername).children, my contract dropdown list gives me customer names :/.
the main dataset has following dmx code :
the customer parameter got this mdx code
And the contractparameter got following code
Like i said before customername and contractnumber are NOT in the same dimension of the cube.
and the case is : when the user chooses a customer, the comparing contractnumbers need to be shown, not all the contractnumbers.
Kind regards
hopelijk niet te verwarrrend :/
Hopelijk hier meer geluk
dus -->
Hi
I am making a report that has 2 different cubes as data source.
the reason for this cube is to compare data from cube A to cube B.
The user can start with selecting a customer name.
Via a subreport, cube A is linked to cube B. (parameter link).
Now i need cascading parameters, i read all the msdn manuals, and googled a whole day.
But i cant find it.
My subreport parameters are non-queryd, cus they get data from the main report.
so i cant cascade them there.
If a customer is chosen, they need to see the contractnumbers that match with that customer.
But i get all the contractnumbers.
I link to my subreport with following parameter link :
Code:
customer ="[Dim Customer Mp].[Customer ID].[" & Fields!MP_Customer_ID.Value & "]"contractnumber (only located in subreport, not available in main report(so i need to link it with another dataset in my mainreport))
Code:
=SPLIT("[Dim Contract Mp].[Contractnumber].[" & (replace( join(Parameters!DimContractMpContractnumber.Value,"|"),"|","]X[Dim Contract Mp].[Contractnumber].[") & "]") ,"X")&
The main report has the same parameters as the subreport.
The parameter customer is linked with eachother. So cube customers from cube 1 is linked with a intern table to the customers of cube 2.
I link it through the parameter. So when i choose a customer from cube1, the subreport auto search the customer from cube 2 (subreport).
Code:
----- DimCustomerMpCustomerID = "[Dim Customer Mp].[Customer ID].[" & Fields!MP_Customer_ID.Value & "]" ----So i added a extra data set to the main report, with that contractnumber, and linked it also with an expression
Code:
--- DimContractMpContractnumber =SPLIT("[Dim Contract Mp].[Contractnumber].[" & (replace( join(Parameters!DimContractMpContractnumber.Value,"|"),"|","]X[Dim Contract Mp].[Contractnumber].[") & "]") ,"X") ---So now the main report, searches the contractnumbers in the subreport, the bad part is, they main report shows ALL the contracts of ALL the customers.
I need to select a customer and then get the matching contractnumbers.
&
If i use in my contractnumber pamareter :
strtomember(@customername).children, my contract dropdown list gives me customer names :/.
the main dataset has following dmx code :
Code:
SELECT NON EMPTY { [Measures].[QTY] } ON COLUMNS, NON EMPTY { ([Dim Contract Mp].[Contractnumber].[Contractnumber].ALLMEMBERS * [Dim Customer Mp].[Name].[Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
(select(strtoset(@Parametercustomer,Constrained))
on columns from
(select(strtoset(@parametercontract,constrained))
on columns from
[mashota])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSthe customer parameter got this mdx code
Code:
WITH MEMBER [Measures].[ParameterCaption] AS '[Dim Customer Mp].[Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Dim Customer Mp].[Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Dim Customer Mp].[Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Dim Customer Mp].[Name].CHILDREN ON ROWS FROM [Mashota]
Code:
WITH MEMBER [Measures].[ParameterCaption] AS '[Dim Contract Mp].[Contractnumber].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Dim Contract Mp].[Contractnumber].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Dim Contract Mp].[Contractnumber].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Dim Contract Mp].[Contractnumber].ALLMEMBERS ON ROWS FROM [mashota]Like i said before customername and contractnumber are NOT in the same dimension of the cube.
and the case is : when the user chooses a customer, the comparing contractnumbers need to be shown, not all the contractnumbers.
Kind regards
hopelijk niet te verwarrrend :/