Bypassing rules

By using the STET function, you can bypass the effect of a calculation statement for specific areas of a cube.

For example, you may want to write a statement for Gross Margin that applies to all regions except France. You can write the general rule and the exception in two ways.

• Write the STET statement first followed by the general rule:

  ['Gross Margin', 'France']= STET;

  ['Gross Margin'] = ['Sales'] * 0.53;

• Write one rules statement that includes an IF function:

  ['Gross Margin'] = IF(!Region @= 'France', STET, ['Sales']* 0.53);