Skip to Content

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

Apr 25 at 10:59 AM


avatar image

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

recruit.jpg (75.7 kB)
sac-doc2.jpg (149.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Best Answer
Rituparna Reddi
Apr 27 at 07:38 AM

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the solution, Ritu

Tammy Powlas
Apr 25 at 11:02 AM

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)

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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


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

Henry Banks
Apr 27 at 08:31 AM


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,


like-this.png (308.3 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks a lot Henry.


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"

users.jpg (68.7 kB)