Help with text box expression using mdx parameter

Question

I am working on a report which uses ssas cube as data source, I have parameter in my report which i want show in a text box. I tried to use text box expression to include parameter value in text box but i didn't worked for some reason, can someone help me out with this.

here is the expression and report preview

expression : =Parameters!HomestoreOperationsStoreLocation.Value(0)

Report Result : [Homestore Operations].[Store Location].&[Albuquerque-99, NM]

i just want the store location ([Albuquerque-99, NM]) name without the whole path.

thanks in advance

Answer 1

Instead of using "=Parameters!HomestoreOperationsStoreLocation.Value(0)", use "=Parameters!HomestoreOperationsStoreLocation.Label".  That should give you the friendly name for that parameter value.

David Brooks
LiveLogic

Answer 2

Hi David,

Thanks for the quick reply, I have tried using "=Parameters!HomestoreOperationsStoreLocation.Label"      & =Parameters!HomestoreOperationsStoreLocation.Label .  but it didn't worked for me. #Error in the report text box.

thanks.

Answer 3

Is your parameter set as multi-value?  It seems that this may be why you were using .Value(0).  If it is a multi-value parameter, you can use Join(Parameters!HomestoreOperationsStoreLocation.Label,", ") in your textbox expression to print the labels of all items in the multi-valued parameter separated by a comma and space.

Hope that helps,

David Brooks
LiveLogic

Answer 4

Hi David,

Thanks for the expression, It is working fine now.

RamaRama