End Date on a Day (as Start Date)

Niklas Multerer

In the rows I have the day entity. In column 1 the possibility to enter a number of new hires and in column 2 the end date for the new hires. The date on which I enter the new hires should represent the start date. In a procedure, the number of new hires should now be written to the days from the start date to the end date. If no end date is entered, the new hires should continue until the end of the database period or selected period. Another issue is that there can be multiple new hires on different days and the periods can overlap. Does anyone have a good idea of the easiest way to implement this or do I have to do this via an additional entity with positions (alternative approach)?

Thank you very much in advance!

Niklas

ANKITA SAHA

Hi Niklas,

1.First you can start by writing a condition in procedure such that if the end date column is empty but the start date column is not empty then put the end date = last date of timeline.

Algorithm ⇒ if (and(start date <>"",end date =""),last_date_of_timeline,end date)

2. Create a mapping between start date and end date and flow the new hire values accordingly in target cube.

Let me know if this was helpful.