Script logic dynamic selection clarification

[Former Member]

Hello,

In our Model, we have Cost Center and Profit Center Dimension.

In our Cost Center we have the Company Code, Profit Center  as Property. 

We want to filter the Cost Center relevant to that Company Code.

*Select(%COST%,"[ID]",COSTCENTER,"[COMPANY_CODE]"="%COMPANY_CODE_SET%")

Similarly instead of selecting all profit center is there is any way to filter based on the Cost Center selection. Otherwise in the script we have to scope all the Profit Centers.

Thanks & Regards,

Ram

[former_member186338]

Hi Ram,

Can you read this:

Vadim

[damovand]

Hi,

How about adding another *SELECT statement like below:

*Select(%COST%,"[ID]",COSTCENTER,"[COMPANY_CODE]"="%COMPANY_CODE_SET%")

*Select(%COST2%,"[ID]",COSTCENTER,"[PROFIT_CENTER]"="%COST%")

Best Regards,

Leila

[former_member186338]

Incorrect

[damovand]

Hi Vadim,

Thanks for the quick response.  I will try to test my suggestion in my test system over the weekend to find out more about why this will not work.  I think I know what is wrong but I want to confirm.  Thanks again.

Best Regards,

Leila