TM1 Forum

if the TM1 service will not start, and the error is almost instantaneous, then it is almost certainly one of three things: 1) the data directory specified in the tm1s.cfg file is not valid. 2) the registry key for your service that specifies the location of the tm1s.cfg file is not valid. 3) there i...

Given these facts the best way to accomplish what you want is going to be to create a rollup in the P&L dimension called "FeedBase" and make it a parent of all the lines you want to feed to the Base cube. You can have multiple hierarchies in TM1 so this won't affect anthing you are doi...

You're still a little light on details. You talk about a dimension with 2,000 P&L lines. Is this dimension in sending cube, receiving cube, or both. If not in both, how do you map the P&L lines from the sending cube into the proper P&L line in the receiving cube? but i found that using c...

Instead of guessing as to why it didn't start, why not try looking in the tm1server.log file and find out why.

I think the problem we are having here is that you are using the term "feeder" for the wrong thing. A "feeder" in TM1 is a statement that tells the TM1 rule engine where a value is going to exist in a cube so that it is not skipped when performing a consolidation. It doesn't actu...

Hi thanks for the advise but im really looking to streamline my feeders. So let me get this straight. You're going to streamline your feeders by adding an unnecessary attribute and then write a conditional feeder rule????? Whatever makes you think this is "streamlining"? All you are doing...

Your slowdown/locking issues is probably due to locks placed on the cube. As a general rule, I never read and write to the same cube in one TI process to avoid problems like this. if I need to copy one version to another in the same cube I always split the process in two, extracting to a flat file i...

i don't know if this what you ment by application folders. plz if there is any step missing tell me what to do If you look at the object tree in Architect you will see an object called "Applications". This is the apllications folder and it is where you would likely put views and reports. ...

Did you assign any security rights to the appropriate application folders to at least one of the groups the user you are logging as belongs to?

In the logging directory of your TM1 server you will find a text file called tm1server.log. Scan this text file from the bottom up and look for a message that says "TM1 Server is ready" with a current date and time stamp.

abcuser wrote:Is there any way I can check if TM1 created view is used by Cognos BI?

Did you configure your query in Cognos BI to pull from a TM1 view? I doubt it's going to magically just know to utilize a cube view you created in TM1 unless you specifically instruct it to.

qml wrote:AFAIK there is no TI function CubeSecurityPut() or anything like that.

I don't think you need it. Although I have never used it like this, the following syntax should work:

ElementSecurityPut('WRITE', '}Cubes', CubeName, GroupName);

Are you saying you want to record how long it takes to run a process and store that value in a control cube? It would be easier to record the start and stop times in the control cube and then calculate the elapsed time via a rule in the control cube. Just CellPutN the value from the NOW() function i...

If you are copying inside the same cube then I have found that breaking that into two processes, where you extract the values to a flat file in process 1 and then load back into the cube in process 2, is much. much faster than doing it all in the same process.

Read the TM1 documentation behind the TI function CellPutProportionalSpread, which looks like CellPutProportionalSpread(number, Dim1, Dim2,Dim3...,Dimx) . It takes the number you provide and, starting with the spot in the cube defined by the intersection of Dim1, Dim2, Dim3...,Dimx proportionally sp...

The purpose of feeders is to tell TM1 which cells, that are subject to rule calculations, will actually evaluate to something other than 0. In your example it looks like Cube1 is really just a lookup cube for determining what a person's grade level is. Why would you use the existence of grade level ...

CoN73mP7 wrote:Now I have to add an alias to each Element. How do I do this? Could anybody tell me?

Have you thought about looking this up in the TM1 documentation? Look for Attribute Manipulation TI functions. It's all there, with examples.

This is why the Best Practices team, some years ago, recommended that all cubes be created with an additional 'measure' dimension at the end. We follow that and it's saved our proverbials a number of times. Doesn't eliminate the need for cube restructuring, but reduces it a fair amount. And it's no...

I see that the last message was in October 2010 and we are in May 2011- Do we have a 'normal' solution for this problem. I see the 'workaround', but I do not understand how to implement it. Also, I have more than one xlsm to put in the applications. It is my understanding that TM1 still only suppor...

Removing all the children underneath a parent element will convert it to an "N" element. Use a While..End loop to cycle through a "C" element and use the DimensionElementComponentDelete to remove each child.