Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple Amount Columns

854880Jun 13 2011 — edited Jun 14 2011
I'm setting up an import format for a text file (to load data into Essbase) that has more than one column with an amount in it. e.g. column 1 is expense dollar amount, and column 5 is hours. the expense gets loaded to the account shown in column 2, and the hours in column 5 get loaded to an account called "Hours".

I have another flat file, with about 12 amount columns, each loading to a different stat account. Same situation.

(before you tell me that I should use a load rule and load to essbase, I know, but we're not doing it that way...)

So my question is, how do I set up the import format to load more than one data column, where I know specifically what the account for the second columns is? I don't mind having to do some scripting, but I might need and example to follow.

thanks.
This post has been answered by SH_INT on Jun 14 2011
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 12 2011
Added on Jun 13 2011
8 comments
364 views