Hi expert,
I do have a mdx function call get_amount(%CAT%) in my dimension formula
this function will get %CAT% for further calculation....
%CAT% should be a category.
But the %CAT% is not my current category ,
instead I want the category is ....: category.currentmember.property("rpt_category").
then I try use :
get_amount([CATEGORY].currentmember.properties("rpt_category"))
this give error :
The Tuple function expects a tuple set expression for the argument. A string or numeric expression was used.
Any idea how to achieve this...
thanks...