How to map column with value "1" to "Counter" in SAP_HR_GEN_IM_RECRUITMENT standard model?

[former_member56890]

Hi All,

In the Business content provided by SAP in SAC, we have some standard model "SAP_HR_GEN_IM_RECRUITMENT"

In the above screenshot, please find the member "Counter"

The above screenshot is from a standard document provided by SAP for the Business content, I have no idea how to do this, How to create the column with value "1" and to map this column to counter.

If anyone has an idea on this.Please help me

[rituparnaredd · Accepted solution]

The first time in your model data wrangling step, please provide the value 1 in counter column for all rows ( use transformation and replace "" with 1). This step will get recorded and when you schedule an upload it will be executed accordingly. Please do not delete the counter column as it is used in several calculations.

[former_member56890 · Accepted solution]

Thanks for the solution, Ritu

[Henry_Banks]

Hi,

just to elaborate on Ritu's answer, I would suggest doing the following:

1. When you are in the Data Wrangling view, switch to the Column Mode.
2. Duplicate any column (preferably the one with the least number if members).
3. In the duplicated column, do the following transformation Replace “” with “1”.
4. Now, you can rename that column to “Counter” and map it to the counter measure.

screenshot attached to give you the idea

Kind regards,

H

[former_member56890]

Thanks a lot Henry.

[former_member56890]

Hi Henry,

Just I want to do the same thing for Userid column, To count the userids, Is it possible to replace the users ids with value "1"

[TammyPowlas]

Hi - is your standard BW content activated to the same release as outlined in the SAP Analytics Cloud Content provided? I am not using SAP BW HR, but for Solution Manager I had to activate more recent content so the models would match up.

You can also fix it by copying the SAP Analytics Cloud content model to your own space, and then remove "counter" (depending on your needs/requirements)

[former_member56890]

No, my source system is SuccessFactors EC, The screenshots are about the Standard content provide for SuccessFactors in SAC.

[Henry_Banks]

Hi, let me make a few enquiries - i've been working through some of this stuff recently but hadn't remapped this model yet. Kind regards, H