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