Please enable JavaScript to view this site.

AudienceView Unlimited Product Guides

The following image illustrates the Business Intelligence and Reports - Business Intelligence|Formula page:

BIR-BI-Forumlas-7.10

The Business Intelligence|Formula page contains the following properties:

Field

Description

Name

Enter a name for the formula.

This name will be the name of the column returned as the result member.

info_outline

Information

If a formula is in use (has been selected in the Result Members) and the 'Name' is modified, the change will automatically be reflected in all of the places where it is being used.

Formula

Enter the formula that you want to use.

Because the formula needs to be able to perform complex math functions, it is free form. The formula will be validated against the following rules:

•The formula contains only numbers, result members and math symbols (including parenthesis).

info_outline

Information

You cannot use a result member that returns a GUID. This applies to most ID result members.

•The formula is structurally reasonable (opening and closing brackets).

•The formula may include = operator that allows direct assignment of an output value that may be alphanumeric.

If the = operator is used, the system will select that as the value.

For example:

o=Hello Bob

This could translate to:

oSELECT 'Hello Bob' as greeting FROM ts_customer

info_outline

Information

If a function has been applied against a result member, that function will be performed before the formula is calculated.

info_outline

Information

If the same member appears multiple times in the Result Members, the first definition of the aggregate member is the one used in the formula.

Order

Enter a number to determine the order in which multiple formulas will be calculated.