Hi Folks ,
My requirement is to pass the the parent of the dimension from the data manager package , which should pass members which qualifies two properties . i have written below code, my code is not working :-
I know my code is wrong. help required.
*SELECT(%COST_CENTRE_SET%,"[ID]",COST_CENTRE,"[CALC] = 'N' AND [ALLOCATED] = 'Y'")
*XDIM_MEMBERSET COST_CENTRE = %COST_CENTRE_SET%
*XDIM_FILTER COST_CENTRE = [COST_CENTRE].CURRENTMEMBER.PROPERTIES("ALLOCATED") = "Y"