Passing parameter from one DW to another.

[nik11]

I have a DW report which has an embedded DW. I need to pass a parameter from the main DW to the embedded DW. Can anyone please tell me how this can be done. I tried creating a retrieval argument in the embedded DW and it worked. But I am not using that Retrieval Argument in my DW query. I just want it for DW text expression of some columns. Can it cause any problems.

 

[vipinhcl]

To pass any value in embedded DW, only retrieval argument is the way.what's the problem not calling retrieval argument? Are you facing any problem ?

 

[mbalent]

You shouldn't have any problems with your approach.

Matt

"Nature forges everything on the anvil of time

 

[nik11]

Thanks for your replies. I used the retrieval argument in the query with the possible values that I could pass from the main DW.