Select statement not working with Hierarchy

[Former Member]

Hi All,

I am currently using this statement for IC ELIM business rule in logic.

*SELECT (%IC_PARENTH1%, "ID", COMPANYCODE, "[PARENTH1] <>''")

*XDIM_MEMBERSET COMPANYCODE = %IC_PARENTH1%

I am getting error "RUN_LOGIC:Invalid attribute name (PARENTH1) in dimension (COMPANYCODE)."

Can any one please help me on this. What is the correct way to use Hierarchy in Filter in logic.

Thanks,

Sumit Bhatti

[former_member186338 · Accepted solution]

Hi Sumit,

PARENTH1 is simply not supported in SELECT.

Use *XDIM_MEMBERSET COMPANYCODE=BAS(SOMEPARENT)

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Could you please tell me can we use filter with Hierarchy PARENTH1,PARENTH2 etc in COMPANYCODE. Because XDIM_MEMBERSET not working with properties and XDIM_FILTER shows errors for below line -

*XDIM_FILTER COMPANYCODE = [COMPANYCODE].PROPERTIES("PARENTH1") = "BAS(PARENT)"

error - invalid attribute name (PARENTH1) in dimension COMPANYCODE.

[former_member186338 · Accepted solution]

Sorry, you can't use hierarchy in SELECT or FILTER!

If you have multiple hierarchies and you need to select members under parents of PARENTH1 then:

For example in PARENTH1 you have 2 root parents: P1 and P2

*XDIM_MEMBERSET COMPANYCODE=BAS(P1,P2)

Vadim

P.S. It's better to provide the detailed explanation of your COMPANYCODE dimension to get help...

[Former Member]

Hi Sumit,

I hope that you didn't mentioned the [PARENTH1]<>"Dimension Member", in your select statemnet.

Kindly mention the PARENT member of the Company Code dimension, i hope this will fix your issue.

Syntax:-

*SELECT(%variable%,"Destination Dimension Property","Dimension Name","[Source Dimension Property]="Source Dimension Property Member"")

Regards,

Aravind.

[Former Member]

Hi Aravind,

I also used particular member/node in PARENTH1 hierarchy. Got same error.

But i need to run logic for all member of PARNETH1.

Thanks,

Sumit Bhatti

[former_member186338]

"But i need to run logic for all member of PARNETH1"

*XDIM_MEMBERSET COMPANYCODE=<ALL>

*XDIM_MEMBERSET - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library

Vadim

[Former Member]

Ok, Then i hope as vadim mentioned PARENTH1 is not supported. So that is the reason why you are facing error. I too personaly never used Hirerarchy in SELECT statement.

So you can go with BAS() in the scope as vadim already mentioned. Or else if you need to skip some members then you can have a extra property in the Company code dimension. And you can use that property in your SELECT statement.

Aravind