Search found 534 matches
- Tue Aug 02, 2022 1:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculation inconsistency after using a DB
- Replies: 16
- Views: 2734
Re: Calculation inconsistency after using a DB
To expand on lotsaram's point that they are the same this https://docs.python.org/3/tutorial/floatingpoint.html is the clearest explanation I have found of the problem. It is from the documentation for the Python programming language but what it says applies to all systems that use IEEE754 double pr...
- Fri Apr 01, 2022 10:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Equivalent of TM1User() function in Rules
- Replies: 23
- Views: 19633
Re: Equivalent of TM1User() function in Rules
If my understanding of caching is still valid, then I would be very wary of relying on any numerical results that had been calculated from the result of TM1User(). This is because of caching of calculated numeric cells. Any cell that has taken more that the configured number of steps to calculate is...
- Fri Mar 11, 2022 1:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14256
Re: Rule Erroring on Duplicative Dimension in DB Formula
Looking back through some old posts reminded me that the problem that I was misremembering was when you have it would think that the @ was part of the dimension name. Sorry for the confusion / memory loss.
Code: Select all
!dimname @= 'string'
- Tue Dec 14, 2021 7:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to calculate up to Millisecond
- Replies: 18
- Views: 68701
Re: How to calculate up to Millisecond
It's always worth pushing it to see what the tick granularity actually is, i.e. if you are hammering it continuously how often does the returned value actually change. That was how we found out how bad NOW is. Millitime certainly looks a lot better, but if you are using it for micro-benchmarking it'...
- Thu Oct 07, 2021 10:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14256
Re: Rule Erroring on Duplicative Dimension in DB Formula
It's been a very long time since I looked at the parsing code but I seem to recollect that you can't do bang notation (!dimname) on a dimension name with a space in it. I'm probably wrong. Perhaps someone closer to the product could confirm or refute for me.
- Tue Aug 24, 2021 3:09 pm
- Forum: General
- Topic: Public Dataset suitable for TM1
- Replies: 7
- Views: 57200
Re: Public Dataset suitable for TM1
Thanks Alan. Very useful and timely info. Simple MIT license too so effectively no restrictions on use.
- Fri Dec 04, 2020 9:05 pm
- Forum: General
- Topic: 75,000 posts
- Replies: 6
- Views: 54698
Re: 75,000 posts
Ouch!
- Tue Nov 27, 2018 8:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders: rule based on constant values
- Replies: 3
- Views: 3169
Re: Feeders: rule based on constant values
I presume you are building the product dimension with a TI. This is setting the parent(s) for each "activity" in the product dimension. Can the data tab of the TI not just set the appropriate cell values (having cleared ['displayElement'] with a view)? Rules are good for the dynamic things...
- Sat Apr 07, 2018 7:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What can cause variability in recalculation times?
- Replies: 2
- Views: 3066
Re: What can cause variability in recalculation times?
Are you making sure that all caches are completely clear before you start the test? This is normally done by changing a value in the cube (or an upstream cube) from the one the view is running on. This is unless they have finally shipped selective cache invalidation. I kind of imagine there would ha...
- Sat Apr 07, 2018 6:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Interesting findings in rules
- Replies: 4
- Views: 3994
Re: Interesting findings in rules
I went to a customer in the south of England who were using this feature of the rule parser to write extensive well formatted documentation of their rules. Couldn't believe it then went back to read the parser code and, lo and behold, it was confirmed. However it looked as if it was completely accid...
- Wed Nov 15, 2017 5:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negligible value in consolidation
- Replies: 2
- Views: 3212
Re: Negligible value in consolidation
If you are interested in why it happens then have a read of this.
The effect is magnified in consolidated numbers and the level of error increases the more leaf numbers are involved.
The effect is magnified in consolidated numbers and the level of error increases the more leaf numbers are involved.
- Sun Jul 16, 2017 8:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: negative value divided by zero Issue
- Replies: 3
- Views: 3518
Re: negative value divided by zero Issue
Out of interest what happens when the denominator is the extremely small number used in place of null in some instances when we have UNDEFVALS? I would hope that it would realise and treat it as zero.
It's been a while. Is UNDEFVALS still a thing out there?
It's been a while. Is UNDEFVALS still a thing out there?
- Sat May 20, 2017 8:46 pm
- Forum: Useful code, tips and tricks
- Topic: Double counting elements in a dimension
- Replies: 5
- Views: 19881
Re: Double counting elements in a dimension
Wim, you've made my day. There's someone else out there that puts the comma at the beginning of each parameter line instead of the end.
- Tue Apr 11, 2017 6:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2.2 FP6 IF1 crashing without log entries
- Replies: 10
- Views: 7691
Re: TM1 10.2.2 FP6 IF1 crashing without log entries
Given that you are running on Windows have you looked in the Windows Application event logs to see if the process dying is leaving any trace in there?
"Programs -> Window Administrative Tools -> Event Viewer" or something similar.
"Programs -> Window Administrative Tools -> Event Viewer" or something similar.
- Tue Apr 11, 2017 5:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to solve SystemOutOfMemory errors when running reports?
- Replies: 7
- Views: 6922
Re: How to solve SystemOutOfMemory errors when running reports?
This APAR might be relevant depending on the version of BI you are using.
- Mon Apr 03, 2017 2:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export Cube data in CSV file, with all Months as columns
- Replies: 31
- Views: 19407
Re: Export Cube data in CSV file, with all Months as columns
Let feeders be your friends. http://www.tm1forum.com/viewtopic.php?f=3&t=7439
Feeders will not suffer from the cancelling out of normal accumulation.
Feeders will not suffer from the cancelling out of normal accumulation.
- Fri Mar 17, 2017 4:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Number Consolidation based on security settings
- Replies: 7
- Views: 5331
Re: Number Consolidation based on security settings
Even in Cognos Planning the access tables did not affect the way in which the consolidation was done. If there data was there it was aggregated, even if it was invisible to the user. We had arguments internally about the problem Steve highlights but there was never any question of doing the aggregat...
- Wed Mar 15, 2017 9:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fact table
- Replies: 3
- Views: 3518
Re: fact table
So if you are talking about a star-schema structured fact table in a dimensionally modeled relational warehouse (Kimball style) then TM1 does most of this intrinsically. A Dimension in TM1 corresponds to the dimension table in the star schema. The key difference is that whereas the individual levels...
- Tue Jan 03, 2017 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 replacement for Cognos Controller
- Replies: 1
- Views: 2358
Re: TM1 replacement for Cognos Controller
It depends whether you are asking "Could you implement a consolidation package in TM1?" or "Could I just migrate from Controller to PA?" The answer to the first is yes - various others here can point you at particular offerings. It is even possible to reproduce some exact Control...
- Fri Dec 09, 2016 8:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server crash after data entry
- Replies: 8
- Views: 5492
Re: Server crash after data entry
No idea if this is still the case but at one time if you had a circular reference that was enabled conditional on some data entry, and if the circularity involved multiple cubes then the server didn't detect it and blew up with stack full.
As I said I have no idea if this is still the case.
As I said I have no idea if this is still the case.