Skip to Content
0
Former Member
Jul 22, 2013 at 08:57 PM

Script Logic: select with property and hierachy

641 Views

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