TM1 Forum

But of course. There is a new revolutionary function called Search on this forum that you can try and use to your advantage. For example, you could try typing 'cannot convert field to a real number' (a quote from what TM1 is telling you is wrong) and check out the threads that pop up. You might be surprised at how many of these questions have already been asked in a way that didn't put people off answering them.

Hi Qml,
Thank you and in the search, the result was spelling, but my problem mapping the data of TM1 to oracle database. Please find the attachment inmy previous post which I have showed in details with TI error.
I want to map two dimensional cube data to a table which has eight columns, which I am not able to do.

Thanking you.

Hi Qml,
I am requesting you to give me a hint how to map two dimensional cube with data to oracle table with eight columns. Please.

Can you please avoid posting multiple posts in a row? Use the edit option instead.

Your immediate problem is to do with trying to implicitly convert string values to numbers and no, you did not find the correct solution to your particular problem. Sometimes you need to clisk on a few different results, not just the first one that shows up. In your case it's not a spelling mistake, keep looking and thinking.

Then, when this particular problem is resolved, you can take another step in the right direction by looking at the below paragraph.

Your problem is that each of your source rows contains only a part of the information you need to insert a complete row into Oracle. Therefore you have two solutions - either you start collecting the information in TI, inserting it only when you have a full row collected, or, alternatively, you can execute partial inserts, using the SQL update statement, which you can find plenty about elsewhere as this is not really a TM1-related subject.

Charan

Managed to solve this problem?
I'm having the same problem and have not found the solution.