Question on Loading and Refresh of TM1 cubes & dim

[Sourav_Das]

We are doing a Financial DataMart for our client. The financial data will come from Oracle11i system and will be loaded in a DataMart using ETL(Informatica). Our Client has Enterprise lisence of Cognos TM1 so TM1 will be used to do analytics pertaining to Planning from the data that is residing in the DataMart. The DataMart which is a typical Star Schema (Fact-Dim) will also be used by some other applications of our client.

My question is :
a) How will I load data in the Cubes and Dimensions in TM1 from the DataMart. Do I need to use TI (another ETL) to load the cubes and dimensions?
b) There will be increemental data loading only in the DataMart. Can I refresh the cube and the dimensions incrementally i.e. Only new Insert and Update records will be loaded?

Regards,
Sourav Das

[Martin Ryan]

a) Yes. TM1 doesn't let other systems write to it (without a LOT of work). So yes, Turbo Integrator is the tool to use.
b) Yes, you can do incremental loads. You receive the delta from the source system then add or subtract that from the existing balance in TM1. This can be quite tricky in practice to do to ensure you get the timing right. I would say it's more common practice is to do a clear and reload.

HTH

[Sourav_Das]

Thanks Ryan for your reply.. I have couple of more question :

a)If I need to use TI to create cubes , then will creating a cube from TI automatically creates the dimensions and measures in TM1 environment?
b) If you answer is YES , then can I use the same dim and measures to create a new cube?
c) In our scenario , will the user needs to first create a TI process to populate a new cube for doing analysis.

Regards,
Sourav Das

[Martin Ryan]

You'll find the TM1 documentation, while not the simplest to navigate, is quite comprehensive. Please consult the documentation and you are likely to find the solution to your problems. You might also like to try the forum search function (top right of every page) or use Google. If after following these suggestions you are still unable to resolve your issue please re-post. Please include what documentation you've consulted and what forum/Google searches you've tried.

Martin

[Wim Gielis]

Hello

Martin Ryan is absolutely correct and please follow his instructions.
Before you start, keep in the back of your mind that in 95% of the cases,
you create your cube "manually". That is, make sure your different dimensions in the cube exist. Create them manually (or with a simple TI command DimensionCreate('name of the dimension'); )
Then create the cube structure manually or through the equivalent TI of CubeCreate.
But from then on the cube gets untouched. You will not use your (main) TI procedures to create cubes and to delete existing cubes.
Clear data and load data in an existing cube but do not destroy and create your cubes on the fly.