Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC 10 MS - FILTER USING PROPERTY

HELLO,

CAN WE USE "PARENTH1" IN SCRIPTLOGIC TO FILTER RECORDS?  WILL BELOW LOGIC WORK?

*WHEN ACCOUNT

   *IS ACCT1

      *WHEN DATASRC.PARENTH1

        *IS "PROP1"

         *REC(FACTOR=1,ACCOUNT=ACCT2)

    *ENDWHEN

*ENDWHEN

THANKS IN ADVANCE.

Former Member
Former Member replied

Hi Meghana,


Yes this will work without any doubts. Good luck with your scripting, You don't need to do any select statements...use it as you wrote it (if that is the correct member id's and properties)


*WHEN ACCOUNT

*IS ACCT1

    *WHEN DATASRC.PARENTH1

    *IS "PROP1"

        *REC(FACTOR=1,ACCOUNT=ACCT2)

    *ENDWHEN

*ENDWHEN

But remember that with all properties it only check the id's that actually have that property and not sub-levels of that. If there are many levels below DATASRC.PARENTH1="PROP1" then I would do a:



*XDIM_MEMBERSET DATASRC = Descendants([DATASRC].[PROP1],999,leaves)

*WHEN ACCOUNT

*IS ACCT1

        *REC(FACTOR=1,ACCOUNT=ACCT2)

*ENDWHEN

(in reality you could skip the "FACTOR=1" part as well)


tested and confirmed on BPC MS 10.0


Brgds

Mattias

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question