TM1 Forum

MTQ is a dynamic parameter, so in theory you can change it via the REST API and use it in the same server session, but the change isn't immediate - it takes up to a minute for the change to be reflected by the server. While I'm a fan of creative solutions, I doubt this is the best one for your probl...

Voted! And I hope others vote too - this is such a worthy nomination. Congratulations, Marius!

Technically it terms of performance DB performs slightly better than shorthand; Are you sure? I have always worked under the understanding (confirmed with some testing a while back) that it's the opposite: the short-form/bracket notation is faster than a full DB function, and measurably so (althoug...

There is a bit of a hack, if you'd like to call it that, which lets you to get around the cube dependency cache invalidation problem. Lotsa is right in saying that all DATA changes in upstream cubes will invalidate the cache in downstream cubes. However, the same does not apply to METADATA changes. ...

If your status cube is small (which it typically is) then one way to commit value changes done via CellPutN/CellPutS in it right away is to invoke CubeSaveData() on that cube, which commits data mid-process and serialises the cube to disk. Normally data is committed only at the end of the transactio...

Excel uses "round away from zero" tie breaking. TM1 is supposed to use the "round down" method for tie breaking and has used it for decades. So I would say the behaviour you reported for 11.6 is expected and the one for 11.8 is unexpected, but maybe they have changed it to align ...

Sorry，i don not know it was released 15 years ago，i want to know whether it can also be used to develop new module like cost budget / forecast analysis，etc. Yes, you can use a very old version of TM1 to develop a budgeting/forecasting application. The question is: why would you want to? You'd be mi...

generally when given the number 4283.775 and again if the format expected is two decimal, I strongly believe that no one would say .77 is correct, right? Well that's the crux right there, isn't it? There isn't one "correct" approach to rounding. It really depends on what MarenC called &qu...

I have figured out where the value 4283.77490234375 quoted in the original post comes from. This would be the most accurate 32-bit float representation. However, as I have already mentioned in my first reply, TM1 uses 64-bit (double-precision) encoding, for which the most accurate value representing...

A colleague of mine enlightened me that this figure with decimal when stored in TM1 as floating, it doesn't really get stored as 4283.775 but 4283.77490234375, which is why the roundp seems like it's not doing it's job. Where did you (or your colleague) take the "4283.77490234375" from? I...

chewza wrote: ↑Wed Mar 04, 2020 12:26 pm Many thanks. So does the S1 part ensure everything logs to the Tm1Server log (exactly as before), and the S2 part logs log logins to the login file?

Precisely. The names S1 and S2 given to the logger streams are totally arbitrary, BTW. Other names can be used too.

You need to set up your base S1 logger: log4j.logger.TM1=INFO, S1 log4j.logger.TM1.Lock=ERROR, S1 log4j.appender.S1=org.apache.log4j.SharedMemoryAppender log4j.appender.S1.MemorySize=10 MB log4j.appender.S1.MaxFileSize=100 MB log4j.appender.S1.MaxBackupIndex=20 log4j.appender.S1.TimeZone=local log4j...

chewza wrote: ↑Mon Mar 02, 2020 2:56 pm Below is the contents of my log file.

Still waiting for it.

It looks like the first argument of the functions LogOutput/AsciiOutput is being ignored/skipped if you nest HierarchySubsetExists inside. And on further inspection it looks like HierarchySubsetExists returns two values rather than one: the hierarchy name as a string and a numeric flag. Because it r...

A question. In an environment without Postman (and TM1py and the likes), can we execute a REST API call by simply using a browser ? For example, a statement like the above. I know that simple GET requests like a list of cubes are easy in a browser but not sure about more advanced queries where addi...

I think you might actualy be exploiting a bug Ty. AFAIK assigning a permanent subset to a temp view isn't supposed to work and you may find that on next upgrade all processes using this "feature" break. Not entirely sure what the intended behaviour is, but a few versions ago we were using...

I still don't trust the *Direct metadata functions very much. The fact you need to remember to run DimensionUpdateDirect after any such updates in order for the new elements to be fully functional tells you a bit about the downsides of overusing these functions. But I digress. When I had issues with...

Do you have any functions in this TI which would operate on these locking dimensions, even as read-only? DIMIX/DIMNM/ATTRS...?

Are any of the locking dimensions ever updated by any of the *Direct functions - not necessarily in this process, but in general?

Because as RAM clock speeds go up each operation takes more clock cycles, increasing the relative latency, therefore you cannot expect to double your performance. A more realistic outcome would be a 10-20% improvement, depending on many additional hardware and software factors.

mce, Does your master process also execute a DIMIX on the DimX dimension? Or any other function on that dim? Contrary to what you might think, DIMIX sometimes requires more than just an R lock. I don't understand it fully, but I have observed that e.g. the first DIMIX on a given dim after a server r...