Hi, I am wondering if anyone has tips on this. I have a reporting services report which accesses cube data and has parameters. I would like to pass a parameter in a query string. However I am not having much luck in making this work.
To be clear about my goal I will provide this example:
In a relational world, let's suppose I have a query which I want to pass the parameter the sales person's name. The URL might look like this (on report manager):
Where SalesPerson is the Name of the Parameter and John Public is the name of the sales person. %20 = (Space) and %2f = "/" so that this will work as a url.
In the multidimensional world, the member uniquename is passed, which would look more like [Sales Person].[Sales Person].&[John Public]
I tried passing that as is, but that doesn't work (that is, the value passed in the query string was not recognized so it went with the default which is nothing). I then tried replacing the brackets with %5D and the ampersand with %26, but
this did not seem to work either.
Any thoughts on this and does this more belong in the SSRS forum?
Any ideas on
View Complete Post