Search found 129 matches

by ajain86
Thu Nov 05, 2009 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Schedule chore for a specific time
Replies: 12
Views: 100854

Re: Schedule chore for a specific time

To limit to 8 am to 6 pm, you can do an if statement to check current time and only proceed if it is in between the desired time. so: assuming you are running the chore once an hour. # to get the current hour sTime = SUBST(TIME,1,2); # convert to number to easily to comparison nTime = StringToNumber...
by ajain86
Mon Oct 19, 2009 5:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate Average in Rules
Replies: 4
Views: 4769

Re: Calculate Average in Rules

Chris,

I looked into this, but due to the complexity of the cube, I was unable to do this. I had to create a work around solution.

Average = (A + B + C + D) / (A\A + B\B + C\C +D\D) .

This provides the correct answer but is a big mess to look at in the rules as member names are quite long.
by ajain86
Fri Oct 16, 2009 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Function or Rule to return the count of elements in a DIM
Replies: 5
Views: 4144

Re: Function or Rule to return the count of elements in a DIM

you should be able to a new member in the production dimension ('No. of Stores').

So you would make a rule:
# This would count all stores that have amount greater than 0.
['No. of Stores'] = N:if (['Amount'] > 0, 1, 3);
by ajain86
Fri Oct 16, 2009 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AVG MDX
Replies: 1
Views: 1555

AVG MDX

Hi,

Has anyone used AVG function that is part of TM1 as a MDX function? i am specifically looking to use it as part of a rule.
by ajain86
Fri Oct 16, 2009 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate Average in Rules
Replies: 4
Views: 4769

Re: Calculate Average in Rules

Martin,

I read through that post. I wish there was just like an AVG or average function that would do this without me having to create a new member or rollups as my current rule is pretty complex and adding a new element would just make it longer and more complex.
by ajain86
Thu Oct 15, 2009 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate Average in Rules
Replies: 4
Views: 4769

Calculate Average in Rules

I need to calculate an average of multiple cells and assign that to another cell using cube rules. The reason I cannot simply do an add and divide is because I need it to ignore cells with 0. Ex: Prices- A = 10 B = 20 C = 30 D = 0 If I do a sum and divide, it is 60 / 4 = 15. What I need is 60 / 3 = ...
by ajain86
Thu Oct 15, 2009 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: copying children from 1 parent to another
Replies: 2
Views: 1972

Re: copying children from 1 parent to another

I assume you have defined the variable CopyForm, CopyTo, Project_Tasks. If Project_Tasks was actually supposed to be the dimension name and not a variable, then it must be in single quotes. Can you show how they are defined. I personally would the part of CopyTo|'.'|TaskNo in a variable as I think t...