TM1 Forum

Maybe I need to explain a little clearer what I am trying to achieve. In my source file I have a column that is called mattype and also a column that is called Quantity. Mattype hold either a N or a Y In my cube I have a dimension called Measures which has Quantity, Occurrences and Number of landing...

Hi all, I am trying to write what i thought is a simply rule but keep getting the message missing semi Colon when I am clearly not. My rule is: IF(Mattype @= 'N'); 'Quantity' = 'Occurrences'; Else; 'Quantity' = 'Number of Landings'; Endif; Some added information, Mattype is a variable which holds ei...

Many Thanks for your replies. Just sat with the server/services expert in our department and we had a look at Event viewer. It appears the only reason my service did not pick up my live data folder was because I was missing a logging folder. I created a new logging folder in TM1DATA started the serv...

Hi Jim,

I did a custom install and named the server and admin host when installing this then created a service (I Believe)

I changed the Planning Sample to be custom data, not sure if this was right.

Does this answer your question ?

Hi All, I think this is a very simple one and I will be kicking myself very hard when one of you guys gives me the answer but here goes. I have just installed TM1 9.5.2 x64 Server on to a new server and then installed 9.5.2 Perspectives x86 (Client). I copied over our exisiting Livedata folder to th...

No Unfortunately there are no Attributes/Aliass in the element being selected nor are any of them DBRW formulas. The file was created by a pivot table but the info was moved to a different sheet, therefore the DBS is not referencing the pivot. The copy from the pivot was doe using paste special valu...

Hi Jim, Thanks for your quick response. I have re typed the formula myself and also used the DBS wizard but to no avail. All the elements on the file are fine and at the lowest level All signs point to a corrupt file as even myself as admin are unable to do a DBS, just wanted the TM1 guru's view fir...

Hi, One of my users is trying to do a DBS to a cube but getting key_err. I have opened the file myself and get the same thing. If I look at one line of the file and create a view in the cube I get a white cell and can input. The infocat TM1 toolbox does not indicate any problems and I have checked t...

Hi, One of my users has created an input template in excel which is a little busy but nothing TM1 can't handle. This template has 3 tab, If you do a shift F9 then the recalc of the tab you are currently on works fine. Do a full F9 or hit the recalc button of all 3 tab and excel dies ? I have been ha...

Alan,

This is a new server and once I have added these 42 group there will be little or none left to create So I think a limit of 50 will be more than enough.

Many thanks for your help.

Lee

Has anyone ever seen this before ?

Message : Tm1server has reached the groups creation limit. You cannot create anymore groups in this server session

I was not aware there is a limit to how many groups you can create.

I am trying to set up 42 new groups, got to about 18 and this message appeared ?

Hi , Thanks for your replies, Admin host is fine, I have uninstalled TM1 and deleted the Applix and Cognos folders, Removed Ofiice completely, reinstalled Office, ran all windows updates, reinstalled TM1 client and all under an administrators log in. I am definitely using the TM1p.xla and ignoring t...

UPDATE: When opening an excel file that is saved on the desktop Tm1 launches and works. However when launching excel from start menu Tm1 splash screen shows but TM tab does not appear and when added in addins excel crashes. ...............................................................................

All, This is the one and only time i have had this problem and seems to be on one machine only. Laptop recently upgraded to MS office 2007, TM1 then stopped working. uninstall Tm1 and re-installed. First time opening excel Tm1 appeared to be fine, closing and reopening causes TM1 tab to dissapear an...

Thanks George,

Event log pointed me straight to the problem.

.LIC file not in right place.

Thanks again.

Hi, When trying to start a service on a new server with 9.4 FP3 on it I get the following attached. My .cfg file points to all the right places and is in my livedata folder, I have also coppied over a small amount of data to check that it works but just can't get the services to start. Any help woul...

Alan,

I reinstall Tm1 on my machine making sure I included everything needed and it now looks fine.

Thanks for you help very much appreciated.

Lee

Alan, Thanks for your reply. I have been through the readme document that cam ewith the download but nothing in there ref Licences. I definitely have the perpectives version of TM1 installed and also the tm1p8.lic file is in my licence folder under tm1data (Same place and my livedata). I have also r...

All, I have recently upgraded to TM1 9.4.1 FP003, I have also recently moved to office 2007. All seems to be work very well at the moment. In 9.1 on Office 2003, there were 3 buttons on the toolbar for open .xdi, Save .xdi and create .xdi these are no longer in my tool bar. I have searched and found...

All sorted.


Thanks alot.