Technical data

Creating Rules, Formul as, and User Functions Chapter 10

Dimension Member Filters

You can create f

ilter user functions to display only the dimensio n members that are referenced in the filter

function. For

example, this is the formula for the FILTER_DIGITAL_CAMERAS filter user function, which is

appliedtothe

PRODUCTS dimension:

IF(MEMBER(PR

ODUCTS) = [PRODUCTS:Digital Cameras], RETURN(1), RETURN(0))

In this example, the end user only has access to the Digital Cameras member of the PRODUCTS dimension.

You can also create filter functions that filter data by userID by using the OPRID built-in function.

See C

hapter 11

, “Using Built-in Functio ns in Analytic Models,” OPRID, page 177.

Rule Bar Display

The informati

on that is displayed in the rule bar depends on the selected part. This table lists the parts and

the resulting

rule bar display:

Selected Part Rule Bar Display

Data cube The data cube’s fo rm ula (if any).

User function The user function’s rule.

All other parts Rem ains blank.

No selected part Remains blank.

To edit a formula or user function, click in the rule bar. The rule bar displays buttons that enable you to

edit rules.

nderstanding Rule Error Messages

When creating an analytic model, it is important that you create rules that follow certain guidelines. For

example, a multiplication symbol needs a value or expression on both sides of the symbol; therefore, if you

createarulesuchas3+5*, the analytic calculation engine cannot interpret the rule.

When you either click the Accept Changes button to accept a rule or you select Tools, Validate Project, the

analytic calculation engine examines the analytic model’s rules for errors. All error messages for rules appear

in the Output window. When you click an error message, the cursor moves to the part or rule in the analytic

model definition that caused the error message. At this time, you can edit the rule in question and fix the error.

The following table describes PeopleSoft Analytic Calculation Engine’s rule error messages and how to

resolve them.