Search found 1015 matches

by qml
Wed Nov 01, 2023 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Dependency with DB Function - How Smart?
Replies: 3
Views: 5649

Re: Cube Dependency with DB Function - How Smart?

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. ...
by qml
Thu Jun 15, 2023 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert Progress status in TI process
Replies: 2
Views: 1214

Re: Insert Progress status in TI process

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...
by qml
Sun Apr 23, 2023 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone Know About TM1 Function RoundP
Replies: 2
Views: 875

Re: Anyone Know About TM1 Function RoundP

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 ...
by qml
Thu Mar 23, 2023 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: what is difference between TM1 9.1 and TM1 11.6
Replies: 6
Views: 971

Re: what is difference between TM1 9.1 and TM1 11.6

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...
by qml
Fri Mar 10, 2023 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding .775
Replies: 6
Views: 903

Re: Rounding .775

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...
by qml
Thu Mar 09, 2023 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding .775
Replies: 6
Views: 903

Re: Rounding .775

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...
by qml
Mon Mar 06, 2023 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding .775
Replies: 6
Views: 903

Re: Rounding .775

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...
by qml
Wed Mar 04, 2020 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1Server log stops after tm1s-log properties file
Replies: 3
Views: 2701

Re: Tm1Server log stops after tm1s-log properties file

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.
by qml
Wed Mar 04, 2020 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1Server log stops after tm1s-log properties file
Replies: 3
Views: 2701

Re: Tm1Server log stops after tm1s-log properties file

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...
by qml
Mon Mar 02, 2020 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monitoring User Logins
Replies: 21
Views: 12565

Re: Monitoring User Logins

chewza wrote: Mon Mar 02, 2020 2:56 pm Below is the contents of my log file.
Still waiting for it. ;)
by qml
Mon Mar 02, 2020 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with LogOutput and/or certain hierarchy subset functions
Replies: 3
Views: 2464

Re: Issue with LogOutput and/or certain hierarchy subset functions

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...
by qml
Fri Dec 13, 2019 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of TI parameters
Replies: 6
Views: 3379

Re: Order of TI parameters

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...
by qml
Tue Dec 10, 2019 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 5179

Re: Temporary views surviving their TI process

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...
by qml
Fri Nov 22, 2019 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 5409

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

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...
by qml
Wed Nov 20, 2019 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 5409

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

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?
by qml
Tue Oct 15, 2019 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Speeds
Replies: 4
Views: 5950

Re: RAM Speeds

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.
by qml
Wed Jun 26, 2019 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 12375

Re: Lock Contention and RollBack

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...
by qml
Thu May 09, 2019 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a View in TM1 (Planning Analytics 2.0)
Replies: 3
Views: 2742

Re: Creating a View in TM1 (Planning Analytics 2.0)

I received a DM from Peter: "How difficult is it to create the TI process? What is involved?" I'm replying here as this is a public forum and discussions should be available to everyone who wants to benefit from them. Such a process would take a few minutes to create by anyone with any TM1...
by qml
Thu May 09, 2019 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a View in TM1 (Planning Analytics 2.0)
Replies: 3
Views: 2742

Re: Creating a View in TM1 (Planning Analytics 2.0)

Unfortunately and notoriously, a user cannot create a public view without being at least Admin for the cube in question, which is rarely a good idea. Luckily, you can create a simple TI process based on the function PublishView to turn any private views into public ones. The users can run this proce...
by qml
Wed May 01, 2019 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 21
Views: 19205

Re: RunProcess and threads

When you consider Synchronized() function or when you consider batchupdate functions, are the threads treated as completely independent process executions similar to the way it happens when executed via RunTI or are they still dependent on the main process that triggered them similar to the way it ...