How to import multiple header rows into a module?

The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this?

Jan 19

Feb 19

Mar 19

Actual

Forecast

Actual

Forecast

Actual

Forecast

Amount

Comment

Amount

Comment

Amount

Comment

Amount

Comment

Amount

Comment

Amount

N/A

Ephany, LLC

7211 - Content / Creative

48,000

N/A

Extron

5110 - Cost of Goods Sold - Hardware

350

1,502

N/A

FedEx - Autodebit

7770 - Freight Expense (non COGS)

mulitple_header_rows_54160.JPG

Accepted answers

All comments

JaredDolich

@kdoan There should be a choice for line items when you go through the mapping. This will allow you to apply a dimension to a row header.

I've never tried to import multiple dimensions so you may have to break that up into to loads.

caleb.maxson

If this is a module-to-module import and you need to map all the dimensions from Module A to Module B, you can create a saved view in Module A with the dimensions in the page instead of the columns. If you import that saved view, the dimensions will all be on the rows and mappable to the new module.

Importing from saved views is often best for module-to-module imports because they can be optimized with filters, etc. and are less prone to breaking the import if updates are made to the module.

Misbah

@kdoan

I agree with @caleb.maxson . Module to Module Imports are way better in terms of performance and effectiveness. Here is the article from @DavidSmith that may help you in understanding it factually.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Import-from-File-vs-Module/m-p/54113#M8509

Thanks,

Misbah

nathan_rudman

you can change your view to have them as page dimensions, the mapping will be easier then

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…