Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25 at 11:02 AM
    -1

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 08:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded