Multiload from SQL

786797

Hi,

is it possible to kick off a mutliload from a sql source?

i have 12 periods in one table for my entities (historic data) and i would like to avoid having to load all this manually.

i know how to load from sql or do a multiload from files, but how can i load multiple periods for 1 or more entities in one go? is it feasible by script maybe?

thanks

JTF85

What version of FDM or FDMEE are you on?  Have you considered using batch loader (Blank Files since your using an integration script), while technically it would still be one period at a time the effort would be pretty much lights out.  Since you say it's historical data it wouldn't seem like you would need this on a repeat basis in the future.

Regards

JTF

786797

i am on fdm 11.1.2.3.

regarding batchloader: is your idea to create x (number of location) * 12 files and let the BL run a serial load for example? i guess this could be a good idea actually.

for a 1 time shot anyways. i could see the need of this being reused for budget or forecast load, but i think this could be a good start. i will give it some thoughts. thanks.

Francisco Amores

Hi

FDM or FDMEE?

you can use open interface adapter for that purpose. You can have data for the 12 periods in the open interface table and select the range of periods when executing the data load rule from the DATA LOAD RULE page (not from data load workbench)

Another option would be to customize FDMEE to use period dimension as a column. This can be done with lookup dimensions and adjusting the export data. If HFM you can adjust HFM_EXPORT.vbs action script. If HP/ESSBASE you can use SQL load method and adjust the SQL view used to export data.

if you refer to FDM then you can customize FDM to use period as column. Similar solution to FDMEE.

hope that clarifies

786797

using period as a column is an interesting idea. i will need to see how that can work. but i guess i would need a separate application for this. thank you.

Francisco Amores

if it's only for one shot I would use batch loader for FDM or period range load from open interface table for FDMEE.

786797

it is for FDM.

Francisco Amores

One shot only?

enable UD dimension in the adapter, for example UD5. Set foreign name to Period. Create an integration script where you import Period in UD5. Adjust EXPORT action script so instead of exporting POV period, you export UD5X.

you period in the POV will be ignored as data will be loaded to multiple periods in UD5.