TM1 Forum

Interesting discussion

Www.cognoise.com/community/index.php/topic.12732.0.HTML

Hi, We are currently running 2xTM1 servers (Dev and live) 64bit with 20GB of memory on vitual machines. We are soon going to be using both servers at 10GB and can only allocate upto 32GB to a server as this is the size of one vitual machine. I am not to good on hardware and am wondering what is the ...

Thanks Martin,

I have used this logic which worked fine.

Andrew

Hi I only want this to work for one company code all the others need to remain going to the same place. I am thinking of doing this through the SQL query on the data source.

Hi, I am loading data through TI using ODBC and want to load a company code to a location in the entity dimension if the financial year is pre and including FY09 and if it is post FY09 I need it to go to another company code in the entity dimension. Due to the complexity of the TI process I was wond...

Hi,

In order to look at the prior period you can set up an attribute for your time dimension called "prior_period" and type in the prior period element names.

You can then write a rule to refer to that attribute as follows:

ATTRS('Time',!Time,'prior_period')

I am using tm1 9.4 SP3 with windows 7 on my local machine. We have some users on XP and some on Windows 7 and have not had any problems on TI.

Thanks for all the information, it is really useful to understand the differences between TM1 and Cognos Planning.

Thanks for this Matt. I think I will include the currency translation in the same cube under an extra dimension, and will need upto 100 capex project numbers per BU, but after that will build something very simular to what you have below.

I have recently built a capex cube to hold forecast capex data. I have set it up so that each new project creates a new element within a capex projects dimension. I am now wanting to improve this cube and allow users to directly enter text regarding projects. Is there a better way in building this c...

Thanks for this information - Are you able to answer the following questions - I am interested to know more about Cognos Planning. Do Cubes, Dimensions and Elements get built in the same way as in TM1 in Cognos Planning? Without TI how can you transfer specific data from one cube to another if its i...

Hi thanks for the above suggestion but it didnt fix the problem.

Can anyone tell me what the benefits are in Cognos Planning. We are currently running TM1 9.4 but am interested to know what extra forecasting and budgeting benefits you get with Cognos Planning. Do you need TM1 to run Cognos Planning?

Any information anyone has would be helpful to know.

Has any had the above error on a workbook in TM1? If you are not connected to TM1 the workbook opens fine but if you do connect to TM1 it all crashes and Excel recovers the work. Any ideas how to resolve the issue?

We are using TM1 9.4.1 FP3 and Excel 2003.

That is what I have missed all along I had skip consolidation values ticked.

Thanks for this Alan.

Thanks for the quick response Alan. I have changed the variable to other however it is still not loading any data. Any other ideas?

I am struggling to master Turbo Intergrator in TM1, I have been able to set up processors to load data via SQL however have not been able to set up a process to load from another cube. I am trying to load cash balances from a balance sheet cube into a detailed cash forecasting cube, and so far have ...

Hi, We upgraded to 9.4 FP2 about 3 weeks ago and I got a report of the same problem from a user yesterday, it has worked fine till now. I have ran the process as admin and it works fine. I have tested as the user and they keep getting the same problem the process is being executed but the data is no...

Thanks for the reply. The bit I am struggling with is understanding how to set the data variable. I have set the cube view to extract all but only actual on the scenario and then in the variables I have set each dimension to other in the contents and the value to data. I then have the below statemen...

Hi, I am wanting to copy a scenario and all the data using a TI process, e.g. I want to copy all the actual data to a new scenario called budget. Scenario is a dimension within a cube. Everything will be a like for like copy. I have not done much with TI appart from written SQL data queries and load...