Importing data with two dimensions?

StephenG
Occasional Contributor

Importing data with two dimensions?

I'm playing around with Anaplan to learn better how it works.  I want to import population data (see below).  The data in the csv has country on the rows, years along the columns and the respective population it the cells.

 

In Anaplan, I have created a list for the countries (with the codes) and I created another list for the years.  I created the years list manually because I could not figure out how to create a time dimension with only years and with so many years (I'm guessing its not supported and that kind of makes sense given this is for planning not BI).

 

I can't figure out how to import this data.  Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: Importing data with two dimensions?

Hi @StephenG ,

 

In Anaplan you have two types of time settings , the first one is the Model Calendar and the second one is time ranges. From here you can set all your planning period. To understand better kindly go through the Anapedia by clicking here

 

Now to understand how to upload this population data into the Anaplan.

I would not recommend using the Anaplan built in time as the data range is from 1960 to 2020 as Anaplan supports the maximum extent of around 100 years with the earliest being FY1981 and the latest FY2078. So the option left is to use a manually created 'Year List'

So to import the population data file you will be needing 2 Lists 

1) Country 2) Year List

Step 1) Create both the lists

Both the Lists might look like the below screenshot

anandshekhawat_0-1623530497621.png

anandshekhawat_1-1623530564069.png

In the above lists I have included all the Countries from the File and Years ranging from 1960-2020

Step 2) Create a Population data module using both the above dimensions.

Step 3) Now import the csv file into the module. The mapping of the same would look something like the below screenshots

anandshekhawat_6-1623531166313.pnganandshekhawat_7-1623531190720.pnganandshekhawat_8-1623531214159.pnganandshekhawat_9-1623531238647.png

 

 

The Country and Time will automatically get mapped, but you have to map the population line item manually as the name are lil bit different.

Step 3) Now run the process, you will get the data into the system 

You might see the below dialog box

anandshekhawat_10-1623531321174.png

Ignore those 220 data fields because we have created the year 2020 as well, but there is no data in the csv file for those 220 Countries.

Also make sure that your data is clean before importing.

 

Sorry for being so much descriptive 

 

I hope it helps.

 

~Anand

 

View solution in original post

2 REPLIES 2
anand.shekhawat
Super Contributor

Re: Importing data with two dimensions?

Hi @StephenG ,

 

In Anaplan you have two types of time settings , the first one is the Model Calendar and the second one is time ranges. From here you can set all your planning period. To understand better kindly go through the Anapedia by clicking here

 

Now to understand how to upload this population data into the Anaplan.

I would not recommend using the Anaplan built in time as the data range is from 1960 to 2020 as Anaplan supports the maximum extent of around 100 years with the earliest being FY1981 and the latest FY2078. So the option left is to use a manually created 'Year List'

So to import the population data file you will be needing 2 Lists 

1) Country 2) Year List

Step 1) Create both the lists

Both the Lists might look like the below screenshot

anandshekhawat_0-1623530497621.png

anandshekhawat_1-1623530564069.png

In the above lists I have included all the Countries from the File and Years ranging from 1960-2020

Step 2) Create a Population data module using both the above dimensions.

Step 3) Now import the csv file into the module. The mapping of the same would look something like the below screenshots

anandshekhawat_6-1623531166313.pnganandshekhawat_7-1623531190720.pnganandshekhawat_8-1623531214159.pnganandshekhawat_9-1623531238647.png

 

 

The Country and Time will automatically get mapped, but you have to map the population line item manually as the name are lil bit different.

Step 3) Now run the process, you will get the data into the system 

You might see the below dialog box

anandshekhawat_10-1623531321174.png

Ignore those 220 data fields because we have created the year 2020 as well, but there is no data in the csv file for those 220 Countries.

Also make sure that your data is clean before importing.

 

Sorry for being so much descriptive 

 

I hope it helps.

 

~Anand

 

View solution in original post

StephenG
Occasional Contributor

Re: Importing data with two dimensions?

Thank you for being so descriptive!  I was missing the manual mapping of the population.  That did the trick.

Thanks again.