You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

jdenegri

Professional

  • "jdenegri" started this thread

Posts: 20

Date of registration: Jan 5th 2012

  • Send private message

1

Tuesday, May 22nd 2012, 6:18pm

Variable Rule, checks values of previous and forward elements

Hi, I'm trying to create a rule that checks if the values of the next element (month) is 0 assign a value in the target, the same rule check if the next two elements of months is o assing another value..

I want to do that looking forward and backward checking if the elements are 0 or not.

Can anyone help me?

thanks

Joaquin.

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Tuesday, May 22nd 2012, 8:42pm

Hi,
One approach is to create attributes in your time dimension(s): e.g. "last month", "next month", next month+1" where you store the relevant element names. These names you can read out from the attribute cube in your rule.

Another approach would be using PALO.EINDEX/PALO.ENAME in combination to retrieve the element names - provided that your element indexes are in the right oder. You then need to take great care of your element indexes.

Similar threads

Rate this thread