This content has been marked as final. Show 4 replies
Is account the only dimension in your essbase outline???
Ofcourse not ....
This was just an example to explain what I am looking for, which is, data load for multiple period when period is in a single column.
You can do this using the Multiload Functionality in FDM.1 person found this helpful
You would need to have your source file in the format defined in the section of the Administrator Guide on Multiload Templates. THey can be text based or Excel based and allow for you to load up to 12 periods at one time.
But the multiload file format requires the data to be in column's as shown below.
Account, Mar, Apr, May
I was looking for something like data in a single column and period in another. I know converting it to the multi load format is an option but i am looking to avoid this manual process.
Another option is to make period as mapped dimension instead of global dimension and have period mapped. Has anyone tried this?