Attribute filter with attributes calculated by rule

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.

ufleisch

Intermediate

Posts: 4

Date of registration: Jul 1st 2009

Wednesday, July 1st 2009, 10:06am

Attribute filter with attributes calculated by rule

Hi,

I have attributes which are calculated by a rule. If I use these attributes in an attribute filter (AFILTER in a SUBSET) the command fails. If I remove the business rule for the attributes, the same command succeeds. Is this a restriction of the attribute filter?

Regards,
Urs

Go to the top of the page

realquo

Sage

Posts: 255

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

Wednesday, July 1st 2009, 10:25am

Hi,

I've done the same and it works for me, but be sure that rule definition doesn't cause any error (e.g. division by 0, eprev function applied to the first member of a dimension, etc).

Kind regards,

RQ

This post has been edited 1 times, last edit by "realquo" (Jul 1st 2009, 3:08pm)

Go to the top of the page

ufleisch

Intermediate

Posts: 4

Date of registration: Jul 1st 2009

Wednesday, July 1st 2009, 2:08pm

Thank you, you are right. I added some IF(ISERROR(..)) to the rules to return a valid value in case of errors and now it works.

Go to the top of the page