Analytics Software

Hi,

I have built ODI interface to extract data from essbase and load to a Oracle Table.

I'm using a report script for extracting data from essbase. The Report script is generating correct output when viewed in console.

When i use this report script in ODI interface, it is extracting the data, but data is being loaded to wrong columns, say A is loading to V and S is loading to B.

I also have set the EXT_COL_DELIMITER to \t.

Below is my report script for ODI to understand output columns. Please help me understand what i'm doing wrong to get out put to right columns

<Sym

{SUPALL}{NAMESON}{TABDELIMIT}{ROWREPEAT}{NOINDENTGEN}{SUPMISSINGROWS}

<COLUMN("TP")

<LINK (<DESCENDANTS ("YT") and <LEV ("TP", 0))

<Supshare

<ROW(Y, S, V, B, P, I, A)

<LINK (<DESCENDANTS ("Y") and <LEV ("Y", 0))

<LINK (<DESCENDANTS ("S") and <LEV ("S", 0))

<LINK (<DESCENDANTS ("V") and <LEV ("V", 0))

<LINK (<DESCENDANTS ("B") and <LEV ("B", 0))

<LINK (<DESCENDANTS ("P") and <LEV ("P", 0))

<LINK (<DESCENDANTS ("I") and <LEV ("I", 0))

<LINK (<DESCENDANTS ("A") and <LEV ("A", 0))

!

Thanks