As Steve points out, there is a parameter in the TM1S.CFG file but it relates specifically to division:
MagnitudeDifferenceToBeZero
Search found 16 matches
- Thu Feb 27, 2020 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidation sum error - negative weighting
- Replies: 8
- Views: 3755
- Wed Dec 04, 2019 11:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Devops in PA/TM1
- Replies: 9
- Views: 6622
Re: Devops in PA/TM1
I recently discovered BareTail https://www.baremetalsoft.com/baretail/
Very useful for looking at log files on a running TM1 instance.
Very useful for looking at log files on a running TM1 instance.
- Mon Dec 02, 2019 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 rule subst with dimension element
- Replies: 9
- Views: 6733
Re: TM1 rule subst with dimension element
Sometimes it can help to wrap up your element reference in something else:
Subst(DIMNM('abc',DIMIX('abc',!abc)),1,1)@<>'2'
Subst(DIMNM('abc',DIMIX('abc',!abc)),1,1)@<>'2'
- Tue May 07, 2019 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI - Add new element in alphabetical order under consolidation
- Replies: 17
- Views: 8831
Re: TI - Add new element in alphabetical order under consolidation
I've had to solve similar problems in the past with a staging dimension and a published dimension, it's an extra level of complexity but if you are building the dimension with TI anyway it's not really an issue. Some slightly more advanced features in DimensionSortOrder (like specifying an alias) wo...
- Fri Nov 30, 2018 2:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Database Insert
- Replies: 4
- Views: 3495
Re: Database Insert
SCAN will help here too.
- Thu Jul 19, 2018 11:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Azure VM Type for Planning Analytics
- Replies: 10
- Views: 8487
Re: Best Azure VM Type for Planning Analytics
Definitely speak with your IBM partner. As for Express being limited to 1600 PVUs (I think you are right about that by the way) the actual number is irrelevant. In a VM environment you are *required* to run ILMT to monitor your VM isn't using more PVUs than you are licensed for. In the event of an I...
- Thu Jul 19, 2018 7:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Azure VM Type for Planning Analytics
- Replies: 10
- Views: 8487
Re: Best Azure VM Type for Planning Analytics
Before moving to a VM environment, especially a cloud based one, I would strongly suggest you look very carefully at your licensing. If you are licensed on a PVU basis as soon as you move to a VM, even a local one, you will be entering the murky waters of 'sub capacity licensing' and the IBM License...
- Thu Jun 21, 2018 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: "IF Statement" - Returning ELSE output for blank intersections
- Replies: 2
- Views: 2366
Re: "IF Statement" - Returning ELSE output for blank intersections
Hi Mark To evaluate a rule based on a NULL/empty cell is counter-intuitive in TM1, the rules engine with skipcheck and feeders is all about hypersparsity. As usual with TM1 there are several different approaches you can take to solve the problem: 1) There's no need to put any rules in the lookup cub...
- Thu Jun 07, 2018 4:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: C Level Rules with attributes evaluations in N level elements
- Replies: 5
- Views: 4254
Re: C Level Rules with attributes evaluations in N level elements
I think we may be talking at cross purposes here. I guess I didn't express myself very clearly (it was early, before coffee). The point I was trying to make was: If you use C: your rule will apply to all C level elements in all dimensions thus preventing natural consolidation. If the OP only wants t...
- Thu Jun 07, 2018 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: C Level Rules with attributes evaluations in N level elements
- Replies: 5
- Views: 4254
Re: C Level Rules with attributes evaluations in N level elements
If you want the rule to apply at the C level on the time dimension but N level on other dimensions you can't use =C: in the rule, that limits the rule to C level elements across all dimensions. As you are already using an if test to limit Month to the C level elements you want, try simply removing t...
- Thu Jun 07, 2018 7:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Checking Element Level Security in a TI processes
- Replies: 6
- Views: 4148
Re: Checking Element Level Security in a TI processes
Thanks for the replies. As Paul rightly points out the right approach depends on a lot of factors, it's one of the great strengths of TM1 that we can adopt so many different solutions to the problem. The reason I shy away from the security lookup cube is because it is adding another step of maintena...
- Wed Jun 06, 2018 2:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Checking Element Level Security in a TI processes
- Replies: 6
- Views: 4148
Checking Element Level Security in a TI processes
This is hopefully one for the useful section. John Turner and I came up with a fairly slick solution to a problem this morning and I thought it was worth sharing. As you may or may not know, all TI processes, regardless of who actually executes them, run with DataAdmin rights. I confess that I didn'...
- Mon Jun 04, 2018 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Warning - read only users
- Replies: 6
- Views: 4539
Re: Warning - read only users
I've been there and done that too, caused a moment of panic!
I added a rule to the }ClientProperties cube to set myself back to zero.
I added a rule to the }ClientProperties cube to set myself back to zero.
- Tue May 22, 2018 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Filtered by string measure in a 3 dimension cube
- Replies: 12
- Views: 7199
Re: Filtered by string measure in a 3 dimension cube
Hi Steve
The Filter by View Extract icon is greyed out in your last screenshot...
I see the same behaviour as Wim, as I press Record Expresssion, that icon and the OK button grey out.
Cheers
Mike
The Filter by View Extract icon is greyed out in your last screenshot...
I see the same behaviour as Wim, as I press Record Expresssion, that icon and the OK button grey out.
Cheers
Mike
- Wed Feb 21, 2018 8:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SUBNM in TM1Web
- Replies: 5
- Views: 3819
Re: SUBNM in TM1Web
The problem is most likely due to the ampersand &. I’ve experienced issues in TM1Web with concatenation, particularly when building MDX queries dynamically.
Try putting into a separate cell and referencing that cell instead.
Try putting
Code: Select all
="Ausgleich_"&Subset
- Thu Feb 15, 2018 12:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RunTI and number of cores/threads
- Replies: 9
- Views: 7204
Re: TM1RunTI and number of cores/threads
Might be going slightly off-topic here but I think it could be useful... In order to make TM1RunTI a little palatable/easier to use we have a generic TI process (TM1RunTi_Did_It) as a kind of surrogate TM1RunTI. This is a TI process that has a dummy 17 field CSV file as a datasource and a single par...