This discussion is archived
1 Reply Latest reply: Dec 28, 2012 8:57 AM by CL RSS

How to optimize Flat file to Flat file dataload thru ODI, where query is in

932031 Newbie
Currently Being Moderated

I am trying to load data thru flat file in essbase, my flat file consist 7 columns among which only 2 are needed as one of the two signifies my account dimension and other one carries a string of 6 dimensions. following process is followed.

1. created a staging file which will bifurcate my column carry 6 dimension members.
2. in that staging file directly mapped account.
3. created variables for year and period.
4. in the final interface i mapped members directly to dimensions like version and scenarion

Note : i have a total of 14 dimensions.

Swarnima Mandloi.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points