TM1 Forum

Hello All, I have a scenario like, a ti process is used to create,insert and delete elements in the dimension, it is behaving normal except for the last element of the dimension. It is creating a dimension and adding the elements in the dimension through ti process and deleting as well. But it is no...

Hello All, I have a scenario like, i need to block only a model which was sent for approval. The hierarchy is like services has models as child elements. So in security overlayglobal cubes it is locking entire service, which means all models under that service are being locked. So i want only the mo...

So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3. So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ? Hello, So cant we show only the number of tables according to the number of elements of a dimensions, like if my d...

Hello All, I have a scenario like, I need to display a table of 2 rows ad 5 columns for each element in a dimension. If a dimension has 2 elements i need to display 2 tables, it depends on the number of elements in a dimension. 1. How to display the tables according to the number of elements in a di...

If you will be consuming on TM1 Web, you cannot use macros. If not, you probably want .xlsb or .xlsm If you are publishing to applications, go with .xlsm, .xlsb can be trickier to keep updated. Hello, Yes i use Active sheet in tm1 web as well. So if we use the active sheets in tm1 web, we can not u...

Hello All,

I need to write a vba code in one of my active sheet. So do i need to save in xltm or xlsx?

Do tm1 support .xltm sheets.

Can anyone help me out.

Hi. Write more details what you create picklist(by attribure or picklist cube), wich elements contain's dimension, wich permission uses for this dimension elements and etc... Hello, This is a static pickist which has value A or blank. Everyone has write access. This is happening for one portion lik...

It sounds like you have used the server parameter in the web config file. If you remove it (leave it blank) then the drop down box will appear. You will need to restart the web service after changing the config file. Hello, Thanks it worked. I had a default parameter, i removed it. It is working now.

Hello all,

The picklists for some columns are not displaying, while they work fine for others.
But when i change the parameters and check for the same ids which did not showed earlier, they work fine.
Now i selected the same parametrs which i seleced at first now they work.

Can anyone help me out

Hello All, I have two server instances A,B in one server. So i want make both A,B to available in tm1 web. Currently A is available. As soon as i open tm1 web for the respective server it is asking for id and then opening server instane A. So whenever i open the server i want to ask for the server i...

Emixam wrote: ↑Wed Sep 04, 2019 12:18 pm

spartan wrote: ↑Wed Sep 04, 2019 8:59 am I have used data folder from other server instance, hiw to use user/ password from the server.

Did you change the PortNumber ?

A quick google search and I found this : Client shows list of TM1 Servers but cannot connect to any of them

Hello,

Changing the port number worked.

Thanks.

Hi, Are you able to log on ? Can you show us what you see ? 1) Here's how to add an existing TM1 Server in Cognos configuration: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1_inst_usingcognosconfigurationtoaddanexistingcognostm1server.htm...

Hello All, I have created a new tm1 server instance through cognos configuration. Now it is created and displaying in tm1 architect. But when i am trying to access it by clicking on it, it does not respond. Do i need to add the users at first or will it open automatically using integrated login. Can...

Hello All,

Is their any method to insert dimension while creating }securityoverlayglobal_Cubename. I have seen that the syntax as below

SecurityOverlayCreateGlobalDefault(‘DataCube’,
‘0:0:1:0’);

Is their any way of inserting dimension name in place of 1 's and 0's.

Hello everyone, We are facing a issue, the scenario is like, admin can run a process and see the result whereas the non admin users cannot see the changes made. When the non admin users run the same ti process ran by the admin a error log is generated with an error "access denied to the cell&qu...

The exact scenario is like, in workbook1 i have Year field which has subnm function and it opens all the years(2017,2018,2019) in the dimension. Now if i select a year 2019 in this year field. If i go to workbook2 now i want 2019 value to load automatically in the year field of workbook2. And in wo...

Hello Wim, The exact scenario is like, in workbook1 i have Year field which has subnm function and it opens all the years(2017,2018,2019) in the dimension. Now if i select a year 2019 in this year field. If i go to workbook2 now i want 2019 value to load automatically in the year field of workbook2....

Hello All,

I have a question, can we access a value in work book1 to workbook2.

Like, in workbook1 i have selected year as 2019, so the year in workbook2 should be automatically generate by taking value of year from workbook1 in TM1 WEB.

Although its working in excel it is not working in tm1 web.

Hello Orlando,

I have a question, can we access a value in work book1 to workbook2.

Like, in workbook1 i have selected year as 2019, so the year in workbook2 should be automatically generate by taking value of year from workbook1 in TM1 WEB.

Hello All,

Is it possible in tm1 , to store information entered by a logged in user in some sheets till log out. Like storing the information entered by the user at that particular session and using that information in other sheets till that work session.