TM1 Forum

Hello Tom,

The question is, is it possible to export Bi report to CSV using TI process. The bypass is only the TM1 cube. TI will still remain there.
And yes, as per your suggestion will post the question in BI forum as well.

Thank you.

Thanks David for the reply. Here it is the case of two different systems residing in different DBs. Due to the timeline issue it is not possible to connect two different DBs directly. Hence they have some quick fixes, BI reports. Source DB --> FM Package Provided global use --> BI Report as per the ...

Hello, In my current assignment, there are processes to import Cognos BI report data in to TM1 Cube, and then Cube export to CSV, lastly load in to database table using SQL Loader. Now the question is can we directly export the data from Cognos BI report to CSV and load in DB using SQL Loader? This ...

Hi Everyone !
Thanks for your responses.
Have been able to solve the issue, The problem was with the logic i was writing including too many complex conditions.
Instead broke it down to simple segments by adding two elements in the source cube.

Here is the final rule and cube structure.

Hi, Thanks for your responses. Yes i have made changes accordingly, []=N:IF(DB('Test1',!Store_test,!Volume_test,'HF DCG1')@<>'' & DB('Test1',!Store_test,!Volume_test,'HF DCG1')@=DIMNM('DCG_test',DIMIX('DCG_test', !DCG_test)), DB('Test1',!Store_test,!Volume_test,'HF DCG1 Volume'), Continue); []=N...

Thanks Tom. However the problem is my second rule statement is passing false result only. If you look at the last screenshot in the document, Test1 has volume data in HF DCG2 & HFG Volume 2. And Target already holds data in the area, rather than adding, it is just giving the false result. What i...

Hello, Here i am with one more question! Have to achieve the accumulation of data, where source cube has picklist and in target the picklist items are in one of the of real dimension. It is easy to move data when you have one picklist item in source with string comparison using IF statement. But in ...

Thank you Paul for your response

Yes figured out the same approach and it is working as desired.

Hello, I have recently been working on one of the projects: Migration from Planning to TM1. Question 1) Studying the model reveals that there are too many break back dlinks are being used in Cognos Planning(very straight forward to implement though). However in TM1 we cannot feed any consolidated it...