TM1 Forum

that'll do it - thanks man!

I have a dimension with several attributes that the user would like to filter on. They are populated properly and when I filter on an attribute, they are available for selection. Trouble is when I go to select which value I want, that drop down is empty. What could cause this? To clarify, they don't...

Can this be done?

All the IBM docs show this being an option that you select during install. My manager is wanting to set up LDAP but I want to avoid a full reinstall if possible.

Disregard, damn you excel formatting

I had to add a new measure to a cube this morning for our users. I got it added just fine, added security and data formatting. It works fine in architect and tm1web, it is always zero in a dbrw call from excel. Every other measure in the whole cube works fine, but this one. So, I'm afraid I missed d...

We are on 10.1 You answered my question though which was admittedly poorly worded. I was wondering if the TM1 excel add-on was something you had to pay an additional license for.

Does the excel add in require architect to be installed to work properly? I've been asked to look into creating some excel templates and I noticed the slice and other functions seem to use architect so now I'm wondering if you have to have an architect license to use the excel add-in. . .

Can this be done? We are introducing TM1 to our users and we want the interface to be as simple as possible.

Is it possible to have tm1 web launch for certain users with several cube views pre-opened?

Thanks, I've seen alot of things, but "%" for OR is a new one.

does this exist, I have the following statement: ['Forecast', '06XW'] =N: IF(('ESP Sales' @= !SSP_m), Continue, 0); It is zeroing out values for an entire level of a cube sans the measure 'ESP Sales' I want it to leave ESP Sales and another value, is there a proper 'or' structure? "OR", '|...

I am in the unenviable situation of taking over a TM1 project from a guy that has left our company. I have no formal TM1 training so I'm learning on the go. On our server, we have 2 TM1 servers running - one for dev and one for prod. It seems that this guy did not keep things in synch - at all. So I...

I have a dimension I'm trying to move between servers. I have moved the subset folder, the dim file and the xdi file. I restart the service for the server receiving the dimension, but the changes (specifically a new alias) do not show up. What am I missing?

I was thinking that was it, from code context, but was not sure - thanks!

What is the difference between '@=' and '='? I cannot find a single thing about them.

declanr wrote:You will need to restart the service for it to appear.

I assume you mean the service running the tm1 server that received the pro file? Sorry, very new to the server side of all of this stuff.

I am trying to copy a process between two servers. I copied the PRO file but the process does not show up in architect, what am I missing?

Disregard, I got it - just made a TI process that took no action and did the following in the data section:

if (VALUE_IS_STRING=1, CellPutS(SVALUE,'Copy Test',Location,Measures,Version,YearQtr), CellPutN(NVALUE, 'Copy Test', Location,Measures,Version,YearQtr
));

I am working on a financial planning application and I need a process to create a copy of the plan into a new dimension when the plan is finalized. For example, say I have a simple cube with the dimensions of Version, Month, and Store. The users will lay out a plan of sales by store by month in a ve...