Search found 534 matches

by Duncan P
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: 863

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...
by Duncan P
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: 16390

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...
by Duncan P
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: 12923

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

Code: Select all

!dimname @= 'string'
it would think that the @ was part of the dimension name. Sorry for the confusion / memory loss.
by Duncan P
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: 66267

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'...
by Duncan P
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: 12923

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.
by Duncan P
Tue Aug 24, 2021 3:09 pm
Forum: General
Topic: Public Dataset suitable for TM1
Replies: 7
Views: 44224

Re: Public Dataset suitable for TM1

Thanks Alan. Very useful and timely info. Simple MIT license too so effectively no restrictions on use.
by Duncan P
Fri Dec 04, 2020 9:05 pm
Forum: General
Topic: 75,000 posts
Replies: 6
Views: 42260

Re: 75,000 posts

Ouch!
by Duncan P
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: 2493

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...
by Duncan P
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: 2525

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...
by Duncan P
Sat Apr 07, 2018 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interesting findings in rules
Replies: 4
Views: 3395

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...
by Duncan P
Wed Nov 15, 2017 5:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Negligible value in consolidation
Replies: 2
Views: 2605

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.
by Duncan P
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: 3093

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?
by Duncan P
Sat May 20, 2017 8:46 pm
Forum: Useful code, tips and tricks
Topic: Double counting elements in a dimension
Replies: 5
Views: 16705

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.
by Duncan P
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: 6888

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.
by Duncan P
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: 6083

Re: How to solve SystemOutOfMemory errors when running reports?

This APAR might be relevant depending on the version of BI you are using.
by Duncan P
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: 16962

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.
by Duncan P
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: 4693

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...
by Duncan P
Wed Mar 15, 2017 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: fact table
Replies: 3
Views: 3109

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...
by Duncan P
Tue Jan 03, 2017 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 replacement for Cognos Controller
Replies: 1
Views: 2060

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...
by Duncan P
Fri Dec 09, 2016 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crash after data entry
Replies: 8
Views: 4916

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.