Search found 9 matches

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

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

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

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

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

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

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

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

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

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