TM1 Forum

Hello everyone, Do you have any advice on when to use several TM1 instance (model, server whatever you call it) instead of just using one massive one? I'm currently rebuilding my new employers TM1-monster and adding a lot of much needed functionality to it. This of course makes a fairly large model ...

How large is the model when it is fully loaded?

Most of the time I use Performance Modeler when editing rules. Most of my old colleagues laughed at me for doing so, but I just find it to be the middle way between having a good editor such as Notepad++ and something that can compile and test the code such as Architect. I do find myself writing the...

Use your last breath and file it as a bug. Who knows... IBM might actually listen.

Thanks for your replies. I sent the question to IBMs product team as well. I will update you if I get a reply. I prefer the nested IFs as well as I can then clearly see how a measure is calculated, without having to look in the entire rule-file for variants. I do use continue at the top of a rule fi...

This is how I would do it:

The picklist-dimension would have string attributes with Model, Year and Color.

The "different cube" would then contain rules that checks the picklist value and then gets the model, year and color using ATTRS.

Thanks for the tip!

Hi all, Im rebuilding some stuff at work and need some advice on what is best from a performance perspective. This cube is going to get big because of an "advanced" idea on how things should be organized. Consider the two examples: Example 1: ['Value'] = N: IF( !Period <= ['PeriodBreak1'],...

FYI, I noticed that Planning Analytics will have the ability to hide a dimension from the end user interface.

Personally I wouldn't mind.

I would love it if removal of a rule meant the last calculated value was saved as a static value. But this would then mean that any previous written value would of course have to get overwritten.

Try publishing an application from PM or Architect and check the logs for what processes are run. Looking at the control objects there is a process called }tp_application_deploy that seems to do all sorts of things. I would dive into that one. And there are pros here that will probably give you a be...

Thanks! I will look into it.

I was at this thing with IBM a month ago. The new rhetoric was "We have the ambition to create an on-premise version of Planning Analytics".

I laughed a bit...

Quick question from a fairly new guy.

If I wanted to learn about configuring logging. What would I google?

I understand that TM1 has this logger. And you can configure this logger to do things. But I cant seem to find what available commands there are.

Did anyone get CAFE to work with Excel 2016 32-bit?

I tried to get it working with Excel 2016 64-bit but that didn't go to well. Perspectives seems to work fine. But I would really want the users to start using CAFE instead.

Hi, I have users that are annoyed with the fact that they always have to expand the workflow nodes to get to where they are to work. The approval subset is expanded, but this doesn't seem to matter. Is there anyone that has a trick for having this always be fully expanded? We are on TM1 10.2.2 if th...

Normally when talking about "shorthand" vs "longhand" rules is taken to mean ['Element'] vs DB('cube',!dim1,!dim2,...'Element') on the right hand side of the rule. Thanks for your reply. Im new at this so haven't really figured out the lingo yet. Ill call it "midhand" ...

Hi,

Does anyone know if using a longhand instead of shorthand has any effect on performance?
In other words, does writing ['Dimension':'Element'] perform worse than writing ['Element'] in a rule?

Hi,

Did you ever solve this? I'm having similar issues.

Hello, I have a process that syncs and re-calculates data from one set of measures to a few others. The process is working as intended but Im looking for a way to limit the process to only run for the cost-centers that the user currently has ownership of. Currently Im looking up the user name and ma...