I don't think you are going to be able to do this using Excel. Excel based loads don't really make use of an import format as all of the metadata that defines the dimension associations is held in the Excel sheet itself in header lines. This includes the period information for multi-period files when you have multiple amounts. In an Excel that only has one value it will defult to using the Period defined in the POV (which in your case is probably January, hence why all your data is being loaded there).
What worked for me was adding a Period column to the Import Format (tried adding a Year column too but did seem to work) and mapping it to the Period column in the source file. However, the entries in the source file had to match the Periods in the Period Mapping e.g. Period Name = Jan-16 (mapped to Target Period Month = Jan and Year Target = FY16) rather than just using Jan. When you load the data you can specify to and from Periods and the relevant data will be loaded.
no, loaded period is taken from the data-load-rule start-period.
I just wanna know, how to FileData.py working, when i start import data from Excel into FDMEE, but there is no 'FileData.py' script in the FDMEE folder.. it's seems it taken from ODI xml or something.. mb some later i will check this.
When i tested this method, i used all possible spellings Periods in file. For e.g. period key(1/31/2017), period name(2017.01), from Global Period Mapping.. GL Period(Jan), GL Period Number(201701) from Source File Period Mapping - still have no sense.. but thanks, i will test it again today.. mb i did something wrong..
If this work for U and U loading different Periods from Excel(.xlsx ?) single-column source file.. it's a good news!
For multi period load, I normally used this format instead of one column period:(either in patch 210 or patch 200), but even this need a mappings script to differentiate the amount for each different month in a column :
maybe you need to create mapping script(expression) in the import format to tell the system that you have different month in one column???
Otherwise how does FDMEE knows that you have different month, because the target is only one month in Import Format.
You may need to add 2 lookup dimensions, one for year and one for period.
Then add them to your import format and configure your Excel accordingly.
You will need to adjust the SQL view used by FDMEE to export data so period/year are taken from columns assigned to lookups rather than period mapping tables.