Calculations in combined hierarchy or in standard hierarchy

In calculations, you can refer to specific cells using the so-called named reference type.

E.g., if you have a simple crosstab and need to refer to a specific row (or column), you can use the "@" reference to do this. In this example, we have made a specific reference to the Sweden row:

sum(0, @"[Sweden]", m1)

Named reference in a Standard hierarchy

A Standard hierarchy is a multi-level hierarchy that has been defined in the data model already. I.e., it is a hierarchy that presents itself as a hierarchy in the TARGIT client's Source data, like the Customer hierarchy in this example:

To make a calculation with a reference to a specific member in a standard hierarchy, you should use this syntax:

sum(0, @"[Europe].[Norway]", m1)

Notice the dot between the two levels.

Named reference in a Combined hierarchy

A Combined hierarchy is a multi-level hierarchy that has not been defined in the data model already. It is a hierarchy as a result from adding multiple dimensions to the same axis of a crosstab as in this example:

To make a calculation with a reference to a specific member in a combined hierarchy, you should use this syntax:

sum(0, @"[Europe]";"[Casual Clothing Wholesale]", m1)

Notice the additional quotation marks and the semicolon between the two levels.