March 2, 2008 at 2:41 am
hello,
i have a report with matrix and the cells properties in navigation have a 'jump to report' a another report with parameters, but I want introduce in -parameters value- the name of the group columns and of rows group where I have done clik in matrix.
i only know set a parameter with mdx : [dimension].[product].&[(all)] or [dimension].[product].&[cars]
how i introduce in -parameters value- the name of the group columns and of rows group where I have done clik in matrix?
thanks
March 3, 2008 at 1:35 pm
i answer me.
finally i could put in parameters value of reporting source, from the reporting Origin.
this is :
=" [dimension].[product].&[" & fields!cars.value & "]"
mi problem now is that when i done click en subtotaly of matrix cells the reporting source not filter by 'all' cars, and filter by first item.
I dont know how filter by 'all' :
like:
=iif(fileds!cars.value="total", [dimension].[product].[all],.....
thanks
March 6, 2008 at 11:11 am
Actually, it's more straight forward than that:
On your MDX query that is being used to pull the original data, for the rows, pages, etc, make sure you specify DIMENSION PROPERTIES UNIQUE_NAME as part of the specification. You won't see any change to the result set, but trust me, there's something there.
Now, for your jump through, you can simply specify
= Fields!Cars.Unique_Name
RS "knows" what the current member is at that point, and will map it in for you.
Also, always jump over to the "expressions" when mapping in the parameters. There's way more funcationality and references you can use, which isn't obvious from the dropdown. If I had my way, I would turn off the dropdown, since it's misleading in what you can do with this feature.
NB. [dimension] isn't really a good name for a dimension. (I'm not sure if it was a typo, but I've assumed it wasn't.) It shoud be [Products], with proper names for your levels and attributes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply