Use counter in Data Management Mapping
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.