BPC Script logic - removing duplicates from *select statement

[Former Member]

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?

[former_member186338 · Accepted solution]

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

[Former Member]

Gotcha...clever, thank you.

[former_member186338]

Then please accept the correct answer and close the discussion!