All about EPM 11.2

In my last blog , I showed how to load multi period data - but in a single numeric column. In this blog, I will cover loading a multi-column numeric data file. Here's my source file (make sure it's in '.csv' format if you're using MS Excel): I'm using an excel data file with multiple columns of numeric data to a period as a column header.  Note: The Excel file may or may not contain a header. Let's get started. In the last blog, I already registered the target application ('POC') and created a source system ('File'). So let's head over to the Import Format section. I will create a new import format. File Type : I have chosen 'Multi Column - Numeric Data' because I have multiple columns of numeric data. Save it. Now let's update the mappings. In the source file, we have the following dimensions: However, we DO NOT load/map Scenario, Period and Year in our import format. Those are taken care in category and period mapping. As p...