TM1 Forum

Amritha.tm1

You can try this way

['value'] = S: IF(DIMIX('Dim4',ATTRS('GEO',!000_Geo,'Geo_code')|ATTRS('Entity',!Entity,'Entity_code'))>0,ATTRS('GEO',!Geo,'Geo_code')|ATTRS('Entity',!Entity,'Entity_code'),continue);

Hope this might help

Hi Thank you lotsaram and mattgoff for your reply. @lotsaram I've posted the result from the IBM reference material.but in fact it didn't appear like that. As your solution to hide entire navigation pane, this is a good solution but I cannot disable entire navigation pane according to I have to open...

Hi All, I have a problem on Tm1 Web by cannot hide the Administration Node on Tm1 Web. According to our Cognos Tm1 doesn't allow user to change thier password via Cognos Tm1 (we are using LDAP), so I've to hide Administration Node on Tm1 web to avoid the confuse of user by changed web.config as foll...

Thank you Steve for your suggestion

It's very good suggestion. I'm going to think about it.

Very useful for me.


BR,
Note

Thank you for your kindly help Your code works very well my mistake that I make a wrong type I cannot use customer as dimension because in report need to show detail by transection and if i use invoice as dimension, i affraid that element of the dimension will increase very fast because i have 10 co...

I do follow your suggestion prolog tab ItemCount=0; CurrentEntity=''; Data tab if( Entity @= CurrentEntity ); ItemCount=ItemCount+1; Else; Curententity = Entity; ItemCount = 1; Endif; item=numbertostring(itemcount); CellputS(V2,'test',Entity,item,'Customer Name'); CellputN(V3,'test',Entity,item,'Amo...

Many thank David/Steve for your reply My expect view is follow attach file But in my ERP doesn't has item column. ERP has only Company, Customer name, Amount My purpose is not to use OLAP cube as relational table but i need to have item dimension to serve report view Can it possible to use TI to loa...

Hi All I want to create TI script to load data from ERP to TM1. But my problem is in TM1 I have structure and result should be like this Company Item name amount X 1 A 100 X 2 B 200 X 3 C 300 X 4 D 400 Y 1 B 150 Y 2 C 170 Y 3 D 220 Z 1 B 60 Z 2 D 70 But in ERP there is no column name item as follow ...

Thank you very much for your kindly help.
It works

I don’t know which function I have to use, but below is the example. Cube: A Amount Currency Explanation(String) 33000 THB AAA 1000 USD (It should show “AAA”, but it doesn’t) Once I change the currency from “THB” to “USD”. The amount convert from 33000 to 1000 automatically from the ...

I'm trying to create TI for update data back to MSSQL but it doesn't work. Here is my TI script. on Data tab ODBCOpen('TM1MSSQL','xxx','xxx'); ODBCOutput('TM1MSSQL', INSERT INTO Season_Index ( Version, Year, Month, Entity, Assumption_Measure, Percent_Inc ) VALUE("%Version%","%V2%"...

When data is entered into TM1 and then the structure of dimension has been changed as Sample below Assume this as structure of dimension 'Department' Previous structure Department A - A 1 - A 2 Department B - B 1 - B 2 - B 3 New structure > Move B 3 from department B to be hierachy of Department C D...

We have the following problem when using TM1. Our users accessing TM1 web over WAN links reported that using TM1 is very slow. As we checked, they have enough bandwidth to access the service. www.cognos.com recommends 256kbit/s per TM1 session and our WAN connection available bandwidth fits this req...