TM1 Forum

So i'm still new to TM1. So i'm looking for some detailed help on the following.

Now I have a cube with over a million records, I need to create a TI process to extract the data so that it can be loaded into a Oracle database. "The DBA wants a flat file." Now the flat file they want is a denormalized data extract. Now I came across a few posts like the ones below but they are not detailed. I'm looking for a step by step instruction and example on how to create the following TI process.

http://www.tm1forum.com/viewtopic.php?f=3&t=10816

http://www.tm1forum.com/viewtopic.php?t=7439

Right-click on cube, select 'Export to Text File', make your selections.
You probably want to check suppress zeroes and suppress calculated (ie consolidated) values.
You can write a TI to do the same thing but if it's a one-off the above will deliver the same.

Thanks David Usherwood that worked! Using the manual data extract with the right click. Now I just need to learn how to do this using a TI.

You can just grab The bedrock process to export cube data. Both as a means to have the TI without having to learn how AND if you read through the code it will teach you a lot should you ever care to do it from scratch.

Thanks lotsaram, I will give that a try.