Search found 10 matches

by Guang Ming
Wed Feb 22, 2017 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error when using package connector
Replies: 4
Views: 3758

Error when using package connector

Hi experts, im now strugling about error in TM1 Architect when select Package connector mode. bellow is the error. https://s21.postimg.org/3rb7zr9av/Error.png my server environment : Cognos BI 10.2.2 64Bit ,Fixpack 6 Cognos TM1 10.2.2 32Bit, Fixpack 6, Interim fix 001, and with SSL Update Framework ...
by Guang Ming
Thu Mar 14, 2013 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create View and Get the Variable name on TI Script
Replies: 4
Views: 3405

Re: Create View and Get the Variable name on TI Script

Well, thanks again Duncan and lotsaram.... I'm glad you would help me. Now I can understand. Firstly I need to create TI that creates only view, right? Then, I need to prepare the dummy cube where store all views that I'm gonna use. And on the 2nd process is: use the created view as the data source....
by Guang Ming
Thu Mar 14, 2013 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create View and Get the Variable name on TI Script
Replies: 4
Views: 3405

Re: Create View and Get the Variable name on TI Script

You should check out the bedrocktm1.org for some ideas as this sort of thing is covered there and there may even be a process that does what you want already. Nothing wrong with your approach you just need to use a dummy cube view as the "source" for the purposes of defining the variables...
by Guang Ming
Thu Mar 14, 2013 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create View and Get the Variable name on TI Script
Replies: 4
Views: 3405

Create View and Get the Variable name on TI Script

Dear all masters... :) I would like to ask you about what I have done here... I am creating the TI process. In there, I am creating a view on TI using scripts, set the view as the datasource and then pull all data to another cube. All in one TI process. Here is the code that I used. CubeName = 'Cash...
by Guang Ming
Mon Mar 04, 2013 4:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Parameters in Turbo Integrator
Replies: 5
Views: 5439

Re: Advanced Parameters in Turbo Integrator

Hi Alan Kirk...

Sorry for long response..

Yeah, that is what I meant.. It's so clear explanation man. Thanks again for your help... ;)
by Guang Ming
Fri Feb 22, 2013 5:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Views on Turbo Integrator
Replies: 3
Views: 3044

Re: Create Views on Turbo Integrator

Guys, I have found this method... http://pic.dhe.ibm.com/infocenter/cx/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_ref.10.1.0.doc%2Fr_tm1_ref_tifun_viewcolumndimensionset.html Hopefully it works, it work for me... I just put the code : ViewCreate(CubeName,ViewName) on epilog tab, and it wor...
by Guang Ming
Fri Feb 22, 2013 4:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Views on Turbo Integrator
Replies: 3
Views: 3044

Re: Create Views on Turbo Integrator

Im so sorry... I didnt notice that and I didnt have that intention.. Im also new for TM1, Well, here is the complete one: Im trying to make a turbointegrator process to create the view of a cube. I tried to find the source, but mostly I found that I just can create dimensions. Thats why I would like...
by Guang Ming
Fri Feb 22, 2013 4:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Parameters in Turbo Integrator
Replies: 5
Views: 5439

Re: Advanced Parameters in Turbo Integrator

Cool... It works for me... Thanks a lot... Here is what I've made : select columnA, columnB, columnC from mytable where columnC = '?pYear?' variables are : vColumnA, vColumnB, vColumnC then I go to parameter tab and insert new one. On Data tab, I put CellPutN(vcolumnB, 'cubeName', vColumnA, vColumnB...
by Guang Ming
Fri Feb 22, 2013 4:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Views on Turbo Integrator
Replies: 3
Views: 3044

Create Views on Turbo Integrator

Hi all.. Is it possible to create views on Turbo Integrator process?
by Guang Ming
Thu Feb 21, 2013 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Parameters in Turbo Integrator
Replies: 5
Views: 5439

Advanced Parameters in Turbo Integrator

Hi guys... Im now struggling using tm1 process using advanced parameters tab. I need to import data from oracle data source to cube. Data source Query result shows some variables, one of them has 'Year' variable. Query result shows 'year' : 2008, 2009, 2010, etc. Now Im thinking how to make a year p...