You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Use counter in Data Management Mapping

Received Response
31
Views
2
Comments

Summary:

We would like to load vacancy data to our BSO cube with data management, in our outline we have the following members (vacancy 1 to 30). With every (monthly) load, we would like to remove the existing vacancy data and load the vacancies in the file to the vacancy members. First vacancy to member " vacancy 1", second to "vacancy 2" and so on.

In the file, the vacancies have an unique ID, but are not numbered from 1 - 30. Would it be possible to achieve this, maybe by using a count function in a SQL mapping, which maps the first records to 1 and the second record to 2.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!