Search found 11 matches

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: 603

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: 603

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: 299

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: 511

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: 511

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: 521

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: 521

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: 716

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: 1014

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: 740

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: 1649

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