AudienceView Unlimited 7  Product Guides

To add a formula to an existing BI query:

1.Open Business Intelligence and Reports from the Desktop

2.Select the Business Intelligence tab.
The Business Intelligence|Search page appears.

3.Search for and select the business intelligence (BI) query that you want to work with.
The Business Intelligence|Results page appears.

4.Select the Formulas tab.
The Business Intelligence|Formulas page appears.

5.Click 'Add Formula'
A new formula row appears.

6.Enter a name for the formula in the 'Name' field.

7.Enter the formula that you want to use in the 'Formula' field.

a.The formula:

ocan only contain numbers, result members and math symbols (+, -, *, /, (, ), <, >, <=, => and =).

omust be structurally reasonable (opening and closing brackets).

omay include = operator that allows direct assignment of an ouput value that may be alphanumeric.

b.Click 'Add Member' to use a result member as part of the calculation (seat).
The New Result Member window appears.

a.Search for and select the result member that you want to insert into your formula.
Result members that begin with an asterisk (*) are other formulas that have been created. Formulas can be used in other formulas.

b.Complete the remainder of the formula, including mathematical symbols.

8.Enter a number in the 'Order' field. This is the order in which multiple formulas will be calculated.

9.For every formula that you want to add, repeat the process from Step 5.

10.To verify the formula's results, select the Results tab.
The Business Intelligence|Results page appears.

11.Click 'Add One'
The New Result Member window appears.

12.Search for and select the formula that you just created.
Formula names are prefaced with an asterisk (*).

13.Click 'OK'.

14.Select the Preview tab.
The Business Intelligence|Preview page appears.

15.The formula and the returned results appear. Ensure that the formula returns the appropriate results.

16.Select the Results tab.
The Business Intelligence|Results page appears.

17.Click 'Apply'
A window confirms that the query was updated.

18.Click 'OK'.

To delete a formula from an existing BI query:

1.Open Business Intelligence and Reports from the Desktop

2.Select the Business Intelligence tab.
TheBusiness Intelligence|Search page appears.

3.Search for and select the business intelligence (BI) query that you want to work with.
The Business Intelligence|Results page appears.

4.Select the Formulas tab.
The Business Intelligence|Formulas page appears.

5.Select the 'del ?' check box next to the formula that you want to delete.

6.Click 'Update Details'.
Formulas that are not in use are removed from the list.
If a formula is in use, a warning icon () will appear next to the 'Name' field. If you want to delete the formula, you must first remove it from the Business Intelligence|Results, Business Intelligence|Criteria or Business Intelligence|Filters pages.

7.Select the Results tab.
The Business Intelligence|Results page appears.

8.Click 'Apply'
A window confirms that the query was updated.

9.Click 'OK'.