Search found 16 matches

by MGrain
Thu Feb 27, 2020 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 3726

Re: Consolidation sum error - negative weighting

As Steve points out, there is a parameter in the TM1S.CFG file but it relates specifically to division:

MagnitudeDifferenceToBeZero
by MGrain
Wed Dec 04, 2019 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Devops in PA/TM1
Replies: 9
Views: 6580

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.
by MGrain
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: 6663

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'
by MGrain
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: 8736

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...
by MGrain
Fri Nov 30, 2018 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Database Insert
Replies: 4
Views: 3429

Re: Database Insert

SCAN will help here too.
by MGrain
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: 8277

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...
by MGrain
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: 8277

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...
by MGrain
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: 2256

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...
by MGrain
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: 4026

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...
by MGrain
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: 4026

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...
by MGrain
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: 4028

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...
by MGrain
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: 4028

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'...
by MGrain
Mon Jun 04, 2018 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Warning - read only users
Replies: 6
Views: 4387

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.
by MGrain
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: 6825

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
by MGrain
Wed Feb 21, 2018 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SUBNM in TM1Web
Replies: 5
Views: 3659

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

Code: Select all

 ="Ausgleich_"&Subset 
into a separate cell and referencing that cell instead.
by MGrain
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: 6898

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...