TM1 Forum

Jorge, the bottom line is this has been the behavior in TM1 since pretty much when the tool was first created. It was initially built for accounting-related apps and this is not normally an issue for budgeting and planning. If you just explain to your users that this is a limitation in the tool, tha...

chewza wrote: ↑Tue Jun 14, 2022 12:15 pm Hi Guys

Do you know of a way of establishing when a chore might have been activated/de-acticated?

Many thx
Chris

That event should be recorded in the tm1server.log file.

This looks to be what I would expect based on past experience. I am assuming that Actual and Budget are in one dimension, the time periods are in another and the accounts are in yet another. Since you've brought both April YTD and Full Year into the view, both Budget and Actual, as well as a subset ...

I don't understand the need to feed the Standard Hours measure in the Labor cube. The only issue you'll encounter if you don't feed it would be possible zero-suppression of that measure whenever someone was browsing the Labor cube. It's really easy to get around that problems with a few reporting tr...

If the type and number of cores is the same I would suspect hard drive issues, i.e., SAN. Are you sure your drive space is in the same region as your server? Even in cube to cube copies TM1 is going to utilize drive space in the memory temp file. As to Architect, at least from an Admin standpoint, c...

Although TM1 can be used for a number of things, the true sweet spot for the tool is planning and forecasting (FP&A) and other accounting/financial purposes. In that vein, in only makes sense that a developer that has a keen grasp on the business purpose for FP&A and knows accounting princip...

Has anyone tried and gotten to work doing an automated server restart on an IBM Cloud TM1 server using a Net Start and Net Stop command? I've tried working on it and I can get the command to execute without any error messages but nothing happens. I'm theorizing that it isn't working either because 1...

I concur. I can't remember exactly when check feeders stopped working (we're on the IBM Cloud) but it's been at least a year. Luckily, it's pretty easy to tell when a cell is not fed so it isn't that big of a deal.

According to the documentation, the behavior you are seeing is the expected outcome. If you skip consolidated values via ViewExtractSkipCalcsSet then you are not going to be able to see any string values from those intersections in your view. The only options I know of would be to 1) not skip consol...

The TI process seems to execute the view as if all dimension are nested on rows. Even though in a TI you don't specify this, it will execute a very large view of data and return the records flattened out. This is the way a TI process works when a cube view is the data source. You get one record for...

Hi, its not directly a TM1 question, but i hope its ok to post it here.. In our company we use ApacheDS as LDAP for Cognos CA and use CAM security to sso into TM1. Now our company has some changes in the unit structure and we want to correct namings and Unit Numbers in the LDAP, this ends with a ne...

Hello - We have 10 profit centers under 1 dimension. A user logins into TM1 web, goes to applications and opens up a websheet that is saved and is able to see all 10 elements under that dimension. When the user builds that exact same websheet in views, the user is only able to see 1 profit center u...

Hi, I am struggling to see how a TI process wouldn't be more logical than a unfed rule in the case of rates? regards, Mark Because the percentages, at whatever level in the dimensions, need to be calculated in real time ? This depends on the purpose of "Rate". If Rate is the result of a c...

Hi, does anyone know whether it's possible to use a table-valued function in the data source of a TI? i.e. select * from tfn_Test1 ('Param1','Param2') At the moment I'm getting an SQL statement failing error I remember I saw stored procedures working, but never tried table-valued functions Thank yo...

Not sure how many people are running Cognos Command Center but had our tasks failing since Saturday after IBM carried out some scheduled maintenance. When running the tasks scheduled or manual, in CCC, the 1st step to test TM1 Server connectivity failed with "Task disappeared". Subsequent...

Fed cells are fed and take up memory, regardless of whether or not there is an actual value in the cube that has been fed. I am hesitant to declare it not to be best practice as there may be situations where it is the right answer. However, in most instances I would use STET instead of assigning a z...

mnasra wrote: ↑Tue Jun 01, 2021 2:34 pm is there a different solution?

Yes. Maintain the dimension through an XDI spreadsheet. This will let you fine tune the order any way you want. AFAIK there is no other way to achieve what you are asking.

Not sure what kind of activity you are trying to log but if it is TM1 related, you may try: Thanks. I am trying to capture whenever someone publishes a file in the }Applications folder. We had someone update a form and screwed it up by publishing from an outdated file. Now no one wants to take resp...

Does anyone know if it is possible to add parameters to the tm1slog.properties file to log activity in the }Applications folder? If so, what would the parameters be?

I agree with Wim that we need more information: Where is the data coming from that you are loading into the target cube? If it is a cube, what is the dimensionality of the source and target cubes? What do you mean by "fill in data on consolidated cells"? Please be specific. If you plan on ...