Skip to Content
0
Former Member
Jan 11, 2011 at 03:05 AM

MDX formula

25 Views

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...