TM1 Forum

I have a few users running 9.1 SP4 client with Excel 2007 on Windows 7 . The Server is also 9.1 SP4. One of the user is having issue with exporting slices to excel. Unfortunately, we were unable to replicate the scenario, but happens on a few occassions which do not follow any particular trend. The ...

Thanks Alan for your quick response. I had a look at the tm1server.log file which tells me which cubes are taking long time. One of those cubes is a very small cube with only two measures having rules and takes 10 mins to load. So, I loaded this cube and its feeder cube only (as mentioned in the pre...

Hi Guys, I am currently using 9.1 SP4 on Windows 2003 R2 64 bit machine with 32GB memory. The Data folder is only 700MB, but it takes 45 minutes to load. I then realized the MaximumCubeLoadThreads was not set to maximum, which I then changed to maximum and it brought the loading time to 25 mins. But...

Thanks John...really appreciate your help. Hope you have a gr8 weekend!!!!!

Thanks John. Just so that I got the freedom of asking loads of questions...I hope you dont mind me asking a few now.... :D 1. Can Palo link to TM1 view to load data instead of reloading them from warehouse and/or operational systems? 2. I read a thread about Palo unable to do C: level rules? is ther...

Thanks again John. I am not sure if I am asking a lot, but would ask it anyway.. ...whats the best material to read to get started with Palo?

Thanks to you all for your valuable suggestions. It helps a lot. It looks like Mid Market edition is the best option given the scenario we have. Even with Mid Market, the cost is much higher than what we are currently paying. It will be a huge challenge for me to convince the management for this big...

We are currently running TM1 version 9.1 SP3 with 5 concurrent licenses. Recently, the number of TM1 users have increased in the business and there are currently 15 users. At the moment, I am managing the users by, 1. priority 2. time frame and/or 3. connecting and disconnecting using macro for once...

Hi All, Below are the details of TM1 and Excel versions I use. TM1 Version: 9.1 SP3 Excel Version: 2003 SP3 I get a very unusual behavior while working with Excel spreadsheets. It happens with SUBNM formula. The formula I am using is as below, SUBNM("tm1serv:AGR Cost Centre","",&...

Very recently we have started looking at options for seasonal demand forecasting in business. As such, I have been looking at a few statistical approaches for seasonal demand forecasting such as Bayesian technique, ARIMA, etc. It would be great to know if TM1 is the best technology for statistical a...

apologies for a late reply. Thanks very much for your help. It worked like a charm!!!!!

Hi Guys, I am trying to execute a process from VBA using an command button. But, keep getting an error type of 6. Have pasted the code below. Any ideas where I am going wrong? Thanks in advance. Declare Function TM1ValString Lib "tm1api.dll" (ByVal hPool As Long, ByVal InitString As String...

Thanks Guys...this forum is awsome!!!!

Hi guys....not sure if this has already been posted before. Is there any way to copy and paste a range of cells into a DBRW range of cells? Thanks in advance.

Thanks Scott....It worked!!!!

Oh...forgot to mention the version....TM1 9.1 SP3 (Build: 9.1.30000.340)

Apologies for a late reply....Had to move my house (such a nightmare I had to go thru)... I would have thought its a very simple piece of code since I am populating data from and to N levels. May I am doing something really stupid (:D)...Below are a few more details... Old Cube (Merch2) 1. Version 2...

Thanks guys for you prompt response. I am using Tm1 9.1 on a 32 bit windows 2003 server. The total memory size is 3.7 GB and I have monitored the memory usage to reach around 3GB before crashing. I have also tried using ASCII output, but with not much help. I am loading only one measure element and ...

I am trying to create a new cube that has slightly different structure to the old one, e.g. removing a few dimensions and adding a few new ones. In order to move the data across to the new cube, I have built a process that loads data from an existing view of the old cube. Even through the view seems...