TM1 Forum

We built a workflow on vba coz the requirement required to handle the read/write security , multi level workflow....etc
and not sure how to call a pre/post process in workflow...

I built a excel input template which loads some data from 3 different cubes and have some vba codes. it works fine. however , I can't open the template it the web I've check that the TM1 excel service is on and the views of the cube is working fine in the web really have no idea about it ? please he...

I just wondering can we set something up to trigger a task after another task(s) are finished in TM1 workflow? It would be very useful

very tedious
if the text have single quote like 's ...

get a ETL mates. and have a happy life~

I'm fail to setup a Delegate task and not sure what did i missing anything what I did lwas to set type = Delegate and status = not delegated, anything else ?? lets say, the manager want to delegate task 1 to sales1 task hierarchy ------------------- |--director |--task1(manager) task2(sales1) task3(...

what if the cell is for user input(DBRW), once you set a rule for the cell, you no longer able to edit the cell . and In my cube , there is a column call QTY .It's a integer . For some reason ,i need to apply data spreading on this column . after spreading ,the QTY need to remain a integer value. e....

Quantity is a integer . Even applying data spreading on Quantity, it supposes to return a integer.
Can it be done in TM1 ?

protect workbook with a password?? but wat if it is a input template .. ...

is there any issue to load TM1 cube into Cognos BI for reporting purpose? or better be with executive viewer ?

Thanks alot. I got another problem that after I created a simple workflow.(i.e. submit from salesperson to manager ) The performance of the TM1 application in Excel dropped dramatically. wat i did was just created a plan_version dimension, a business_unit dimension, create some group and user ,the r...

play around the TM1 in excel lately, found that if a user presses delete button in a cell , it clears the formula and the cell no longer get a value from cube.
is there a way to avoid the formula from being clear out except disable the delete button ?

is there any functions to get login username ?

when running the following code in TI process, I found that value of variable summaryProductName become null within the while loop. got any idea, or is it a bug ? detailCount=1; summaryCount=1; summaryProductName =''; detailProductName=''; preVerson = ATTRS('Verson',Version,'Pre_Verson'); while (sum...

I'm trying to create a new workflow.
when I click "TM1 workflow -> Admin
the following error come up ... any idea?

I'm trying to insert records of a view into a Ms access table Prolog: odbcopen('access', 'isaac', '1234'); Data: odbcoutput('access',Expand( 'INSERT INTO table( 1,2,3,4,5,6 ) VALUES ( "%v0%", "%v1%", "%v2%", "%v3%","%v4%",%v5% )' )); Epilog : odbcclo...

Thanks alots~

in the cube viewer , I can't find the snapshot icon , active form icon and slice icon.
but I can insert active form from Excel?

got any idea
??

In the 9.4 MR1 reference guide said "If a worksheet already contains one or more Active Forms, you can insert a new Active Form above or below existing forms. Each form uses its own title, row, and column dimensions" is there any workaround to insert a new active form next to existing form...

is it possible to give a unique key for each element in the hierarchy, then create a lookup cube and use DBR funciton to map the name on the report level?

the manager want to freeze the data in order to avoid any data change while he is reading the report.
how can it be done ? TM1 workflow ?