Hello!
I have the following command in the script logic:
*SELECT(%VAR%,"[ID]","COMPANY","TEST='Y'")
The command is working OK. However, TEST is a property of dimension COMPANY. Must also include a filter by hierarchy, named PARENTH1. I tried the following command:
* SELECT (%VAR%,"[ID]","COMPANY","TEST='Y' AND [PARENTH1]='A'")
also tried:
* SELECT (%VAR%,"[ID]","COMPANY","TEST='Y' AND PARENTH1='A'")
Both did not work (says there PARENTH1 as property).
Any suggestions to solve this problem?
Use BPC 10.0 Netweaver.
thank you
David