Adding Multiple Leave dates into single line item

deepak83 · 2024-03-17T11:51:40+00:00

There was an error rendering this rich post.

I am importing multiple instances of Leave in module. i used select function to get them into module. Now to allow them take maximum 40 days cumulative in a year, i want to store them in single line item. so that i could apply check there.Please suggest.

Accepted answers

All comments

TristanS

@deepak83 so to confirm my understanding of your requirement is correct.

For example, Employee ABC that is planning to take leave on 20 Mar, 2 Apr and 5 Apr 2024
You want to have the info: 20 Mar, 2 Apr and 5 Apr 2024 in one line item

Usually, you would have a module having the following dimensions:

Employee
Time (Day Time Period?)

Then you would have a boolean line item e.g. "On Leave?" then have it set to true for 20 Mar, 2 Apr and 5 Apr 2024

But impression I'm getting from your question is you want a module with only the Employee dimension (without Time Period dimension) and have the dates above stored in a singe line item. If my impression is correct, it can be done but I wouldn't really recommend it and would like to understand what the use case is. If you really need it, you create a line item as Text format. Then apply a Textlist function against the dates employee is on leave (ensure you convert the dates into a text line item to which you would apply the Textlist function.

deepak83

Thanks, let me provide you more details.

i want data imported in #1,#2,#3 into #Days off ****. as currently it is having data for single select statement. so i want #Days off **** module to calculate if leave imported through #1,#2,#3 breach the max allowed leave in a year. based on that i could mark them as paid or non paid leave.

Dikshant

Hey requirement is clear now. Can you just share the pivot of FA17_M05_Import Long Leaves module?

What all dimensions are used and how you are storing start and end dates?

deepak83

SriNitya

@deepak83
Anaplan does not allow multiple date selection in one single line item, when employee enters the initial leave provide him with action button to import data from without time dimension module to another time dimension module rest dimensions keep them same. Create line items and calculate leave duration
based on Start Date & End date then bring the total leave days into module to without time dimension and then display a warning message in a line item that as Total leave days > 40 mention it as paid or unpaid based on use case.. and then you can use further..

Dikshant

I think your FA17 modules has multiple leave ID which has multiple leave interval of an employee, as shown below

you wanted to calculate the total number of days employee has taken leaves which can be done like this as shown below:

Let me know if this is what you're expecting!

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled