Establish a connection between fake time and real time

I have a csv upload (see below) with a column for FY and an individual column with the qty value of each month. I cannot change the headers prior to import. To view this data by anaplan native time, I know I need to create a fake time to real time conversion, but I'm not sure where to start, thanks!

Accepted answers

All comments

seymatas1

You should work with the IT team to reformat the file so that it combines months and years into one column. For example, each row will have "Jan 20," "Feb 20," etc., and you will have an "Amount" column.

Then set up a module in Anaplan with time (months) as the dimension and "Amount" as a line item. This will make it the most efficient way to import the data into Anaplan.

Fixing the data format at the source before importing numbers into Anaplan is a more sustainable approach.

I hope this helps.

Seyma 🌷🙂

melliott

Unfortunately, I cannot alter the import. Long term, we may be able to get that changed, but this format is what I'm working with for now.

Preethi

@melliott

In your import module create 12 line items for each month & format it as Month Time period & derive the anaplan month for each year using finditem

Next create a target module dimensioned by time & list same as your source module.

Then you can run the import from source to target for each month separately, total 12 imports starting from Jan to Dec or use a logic in target module to pull in the values using SUM forumla.

Ex: "IF LEFT(NAME('Item: Time'), 3) = "Jan" THEN 'test'.JAN[SUM: 'test'.Jan Month] ELSE if LEFT(NAME('Item: Time'), 3) = "Feb" then 'test'.Feb[SUM: 'test'.Feb Month] else" & so on until December

Hope this helps.

seymatas1

Hi @melliott
Please do not use 12 nested if statements. It violates the best practices.

Try to follow this approach.

Create a UID column in the file.
Create a UID list.
Create a fake month list with 12 items.
Create a budget year list with 2 items.
Create a transaction data module with one dimension: UID list. Let's call it DAT01.
DAT01 has line items BudgetYear, Jan, Feb, etc.
Import the file's UID column into the UID list.
Import the data from the file into DAT01.
Create DAT02 module. It has budget year list as a dimension. No native time dimension.
Import numbers from DAT01 to DAT02.
Create a SYS01 Time module with the time dimension and two line items: Budget Year and Month. Use text functions to combine the Budget Year and Month to resemble Anaplan's time format (e.g., Jan 20).
Use FINDITEM to map this to Anaplan's native time.
Create another module: DAT03 with Amount line item, and Anaplan's native time dimension.
Use a LOOKUP formula and SYS01 module to bring numbers from DAT02 to DAT03.
Combine your actions in a process, and publish on a UX page.

I hope this helps.
Seyma 🌷🙂

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…