TM1 Forum

Dear all,

We are preparing for a customer project using Cognos TM1 Connector for SAP BW to retrieve data from SAP BW InfoCubes. Customers are asking us whether IBM has any successful customer reference. Does anyone have prior project experience of this? Thanks in advance for your help!

mikegrain wrote:Try right clicking on the application folder in Server Explorer and using the Add File option to upload the original .xlsm file.

It was the only way I could get TM1 to handle .xlsm files properly.

It works! Thanks for your tips!

Hi all, In TM1 Perspective user can input data on each cell and the DBRW function will send the value back to TM1 server. We would like to know if it is possible to copy data of a large area, for example, A1:D10 in one sheet and paste the data to another sheet with DBRW formula on the cells. However...

Thanks for the information. I have done the following settings on my TM1 server. Select "Enable Closing Cursors" Add "UseSQLFetchScroll=T" in tm1s.cfg And I got the following results of different settings of my TI process Select "Use Unicode" and select all the columns ...

Thanks tomok. We followed your advice to add "UseSQLFetchScroll=T" into tm1s.cfg. If we use "SELECT * FROM ..." to select all columns, there is still no data shown in Preview. However, if we change our SQL to select only one column, we can see the first 10 rows in Preview, but af...

Hi all, We want to read data from an Oracle DB table and write the data into TM1 cube using Turbo Integrator. However, we can only see the table schema but no data in Preview in Preview, and cannot read any data. Our setup procedure is as follows: 1. Setup a 64-bit ODBC System DSN in Windows ODBC Da...

Just a word of warning - if you're changing rules and feed cells then remove the feeder, the cells will remain fed until you clear them out. Not that it sounds like this is your problem but it's something to bear in mind - ususally when developing it's a good idea to recycle the whole server at the...

My question is: Will the feeder firing logic be different when it comes to copy/paste values to cube viewer from MS Excel? No, it won't be. Entering a value in a cell should fire a feeder based on that cell, full stop. The interface/mode used is irrelevant, can be TI, DBRW, or a Cube View copy-past...

Hi qml,

Thanks for your prompt response. I may gave a bad example. The feeder should be [Quantity] => [Sales Amount].

My question is: Will the feeder firing logic be different when it comes to copy/paste values to cube viewer from MS Excel?

Thank you.

Hi all, I would like to clarify my understanding about feeders. Please take some time to help me. Much appreciated. 1. Let's say we have a sales assumption cube, A, and sales plan cube, B. In B we have the following rule calculating sales amount: [Sales Amount] = N:[Unit Price] * [Quantity]. In A we...