Skip to Content
-1
May 21, 2018 at 01:23 PM

script logic:scoping with the mutltiple properties

71 Views

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"