TM1 Forum

Hi
In my earlier post I have tried to update a single column from TM1 to oracle database.

Now my requirement is I want to load TM1 cube view data into oracle database. For that ;

1) I created a table in oracle.
2) In TI i have selected source TM1 cube view
3) In variables all items as other.
4) In advance Tab;
a) In prolog tab: ODBCOpen(source,username,password)
b) In data tab:ODBCPutput(source,-----------) please suggest me what write here I tried with Insert into [dimension name],[dimension name] from cube view name, which gave me an error.
c) In Epilog tab:ODBCClose(sourcename)

This is what I tried but unable to load TM1 cube view data into Oracle, this process should be automatic like whatever the view data updated same should reflect in Oracle database.

Please suggest how to meet this requirement.

TM1 9.5.2
Excel2007

Thanking you

Mods, please delete this post. This guy has been told repeatedly not to start new threads on the same topic when his old thread is still active and receiving replies.

Hi Tomok this is another one, the previous one was I was updating a row in the Oracle from TM1.

Here my source is Cube view in which I want to load cube view data into Oracle database.

In the previous thread I have closed how I got it.

Please help me.

charan wrote:Hi Tomok this is another one

No it's not. It's the exact same thing you were asking about in the other thread I replied to.