TM1 Forum

Client has a project-based business with revenue, costs and gross profit being tracked at Program / Project level. A project rolls into a unique program. Programs are categorized at a high level as building/ Repairing projects. It tracks costs and revenue for the entire life span of the project by P...

I am trying to create a staging cube which is going to send data into 19 cubes for a particular Actual update process. I am not sure what all parameters i need, to assess the feasibility as the staging cube, whether it is going to work properly or how much performance gets bog down. So just want to ...

HOw? Is it same as size of data directory?

How can we assess the size of a TM1 model?

Yes You are right Alan. Thanks I got it.

Hi,
I need to have 2 data sources in a TI Process. One data source I am having as a cube view, I also need some information from Excel file into this TI Process as well. In the data source I have defined the cube view. How shall I get the csv file read now?

Hi,
How does multiple execute process statements work in TM1? If I have multiple Execute Process in Prolog of my TI Process. Does it waits for the first statement to finish execution or they all execute in parallel( like even if the first one has not finished executing the second starts)?

I am going to merge TI processes which belong to same dimension or cube. These processes were created long back and looks scattered, so currently, in a TI we are updating subset and another TI for attributes, then these attributes are getting loaded into cube so some discrepency is there. I will not...

Thanks for the replies. I can't post all the TI's which are involved in the process as it would be lots.
Just wanted to have an idea like what all factors I should consider if i want to redesign an existing process.

Developer. The Process has TI's which are updating subsets, loading attributes, loading data, to different cubes for every period(every month) like copying forecast current to forecast prior, loading actuals etc. I also need to know where do we recommend to have staging cubes? Updating subsets and a...

Hi all, We have to redesign TM1 Actual loads process for our client. Currently it take 29 steps to upload data in all the cubes. There are 5 modules for the TM1 system. We have 29 buttons in a websheet and user run one by one each button to complete the load process. We want to make it as short as p...

I want to fetch subset(all zero level elements) from a dimension into an excel sheet, which is connected to TM1. It is not an active form. I am populating a list(dropdown) using data validation in excel, the list contains elements from the dimension copied statically, but I want the list to get upda...

I have a .csv file from which i want to load data into cube. The requirement is only non zero values should get loaded as the sheet has lots of zeros. What is the best approach to load data in this case? I was thinking to put if condition in data tab so that if data <>0, Cellputn statement executes....

Hi all

I want to know if there is any way to understand an existing model. I want to understand TM1 Plan samp(data flow, measures) and blueprints models. Is there any good documentation available for these?