Hi!
I need to read a parent from an dimension. I tried use SELECT as follow:
*SELECT(%V_HIER_COST_CENTER%,"[PARENTH1]",COST_CENTER,"[ID]=%COST_CENTER_SET%"), but does not work because PARENTH1 is not an atribute from COST_CENTER. This field, PARENTH1, is part of a hierachy structure.
E.g.
I have a hierarchy like this:
COST_CENTER PARENTH1 10001 10000 10002 10000 10003 10000
I received 10001 in a parameter COST_CENTER (*XDIM_MEMBERSET COST_CENTER=%COST_CENTER_SET%) in my script logic. I need read the parent node 10000.
I just need to know the statement to read the parent node of a dimension.
Someone can help me?
Thanks in advanced.
Rafael