Is it possible to create a “Measure” parameter I have tried the following:
SOLUTION 1
select
NON EMPTY {
strtomember(@Measure)} ON COLUMNS
....
The report builder recognize the parameter value but the dataset fix the standard value (TurnOver) in its fields. In this way the dataset will be invalid if the parameter has a different value because the report will search for the field “TurnOver” to fill the table.
SOLUTION 2with member
[Measures].[Selected] as 'strtomember(@Measure)'
NON EMPTY {
[Measures].[Selected]} ON COLUMNS.....
The report builder does not recognize the parameter value
SOLUTION 3select
NON EMPTY {[Measures].Allmembers}
ON COLUMNS ....
And in the report the expression =Choose...
I am sure that this solution will work but i dont want to retrieve all of the measure information.
---------------------------
Does anyone know if I can use something like:- Datasets!Dataset1.field(3)
Does anyone have an idea
Parameter: Measure