Hello everyone!
I'm building a report in ssrs using MS SQL server Analysis Services for Data Source.
For designing report I'm using Query designer where I want to create Calculated member with parameter.
When I write in Calculated member:
StrToMember("[Dim Vrijeme].[Mjesec u godini].&[" + CStr(@FromDimVrijemeMjesecugodini) + "] "
I get this error:
'The FromDimVrijemeMjesecugodini parameter could not be resolved because it was referenced in an inner subexpression.'
When I write this:
'AGGREGATE ( { " + Parameters!FromDimVrijemeMjesecugodini.Value + " : " + Parameters!ToDimVrijemeMjesecugodini.Value + " } ) '
I get null value.
For now I just want to get a Parameter value witch I can use for some calculation in Calculated member.
Thank you!
bye