Steps to Import data from TM1 cube to Database

[Acc_Moonwalk]

Hi

Can anyone give me the steps to import the data from TM1 cube to DB . Is it possible?

Regards
Ashok

[Steve Rowe]

Hi Ashok,
Can I suggest you post alot more detail about what you are trying to do, especially which DB.

In order to get the most help you'll need to outline what you have tried to do and why that isn't working for you.

It's pretty straight forward to export data from a cube to a SQL DB using and ODBC connection, if you take the time to read up the help and search the forum you should find some examples.

Cheers,

[qml]

What kind of database? TM1 is itself a database engine (of the MOLAP variety).

But basically any database will allow you to load data from a flat delimited file, so just export your cube data to one (right click on the cube -> Export as Text Data...) and import it using the other database's ETL tools.

[santosh361]

Hi,

I am trying to create the reports with the TM1 Cube.

When I tried to take TM1 Cube as datasource and build the reports for some of the data items report is taking long time to execute.

I am assuming this is taking long time to do the consolidations. I also has configured some of the settings to tune the performance but no luck.

So now we are planning to develop the Transformer Cube from the TM1 Cube which will store all consolidations as well to provide the fast response in the reports.

We are using Report Studio for developing the reports, when I use TM1 Web the same cube is giving faster response than in Report Studio.

I have also using the dynamic query execution methodology.

Not sure right place to keep all this stuff.

My main question is how to export the data into cma file via TI code. Can you please provide the steps for doing this via TI Process.

As TI process is asking me to select the cube view, but I want to load all data into cma file and later I will load the data into database or will develop the cube from there.
So that, report will give faster response.


Thanks,
Santosh

[David Usherwood]

When I tried to take TM1 Cube as datasource and build the reports for some of the data items report is taking long time to execute.
I am assuming this is taking long time to do the consolidations. I also has configured some of the settings to tune the performance but no luck.

You should benchmark generating the output in Perspectives or Architect. TM1 consolidations are very fast indeed.

So now we are planning to develop the Transformer Cube from the TM1 Cube which will store all consolidations as well to provide the fast response in the reports.
We are using Report Studio for developing the reports, when I use TM1 Web the same cube is giving faster response than in Report Studio.
I have also using the dynamic query execution methodology.

Earlier versions of BI generated - to put it very kindly - 'sub-optimal' MDX. DQ was meant to deal with this but may not have in your case - or, quite possibly, you're not using it correctly.
Another possibility is that your TM1 application itself has design and/or performance issues.

Not sure right place to keep all this stuff.

No comment

My main question is how to export the data into cma file via TI code. Can you please provide the steps for doing this via TI Process.
As TI process is asking me to select the cube view, but I want to load all data into cma file and later I will load the data into database or will develop the cube from there.

You'll need to create a cube view. You will know (won't you ) from the documentation that a TM1 View is just a collection of subsets selecting values from the cube. Exporting data really isn't hard. You don't even need TI, but if you use it, you write an AsciiOutput line in the data tab, remembering (you did know that, didn't you ) to convert the value into a string.

So that, report will give faster response.

When you factor in the export and import time, I doubt it. Try 'Freezing' the data by transferring your values to an unruled cube. That should perform very well indeed.