Skip to Content
avatar image
Former Member

BPC Script logic - removing duplicates from *select statement

Hello,

We use BPC NW 10.1.

I use a *select statement to retrieve the cost center associated with an employee(s) that have data submissions via input schedule. I use the cost centers to cycle through *rec logic. However, if several employees have the same cost center, I don't want to cycle through duplicate cost centers, only unique members. Any suggestion on how to accomplish this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 30, 2016 at 03:22 PM

    Easy, but please ask your question in line with: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Sample

    You have:

    Dimensions:

    EMPLOYEE with property CC filled with required COSTCENTER member

    COSTCENTER

    You have selected number of EMPLOYEE ID's in %EMPLOYEE_SET%

    Code:

    *SELECT(%CCNOTUNIQUE%,CC,EMPLOYEE,ID=%EMPLOYEE_SET%)

    *SELECT(%CCUNIQUE%,ID,COSTCENTER,ID=%CCNOTUNIQUE%)

    %CCUNIQUE% will contain only unique COSCENTER ID's

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 06:38 PM

    Gotcha...clever, thank you.

    Add comment
    10|10000 characters needed characters exceeded