Wednesday, September 28, 2005

[BW] Setting sign reversal for a hierarchy basic characteristic

In InfoObject maintenance, you define whether or not sign reversal is possible for the InfoObject (see Tab Page: Hierarchy). The Sign Reversal for Nodes setting adjusted here is valid for all hierarchies based on this InfoObject. If sign reversal is allowed for hierarchies, the attribute 0SIGNCH is included into the communication structure for the hierarchy nodes.
1.
Set sign reversal per node in hierarchy maintenance
Via Change Node from the context menu of a hierarchy node, you can set the sign reversal for this node. Note: The sign reversal only applies to the node itself not to its children or subnodes.
2.
Load the hierarchy attribute sign reversal flexibly
See Special Features when Loading Data via the PSA.

You have loaded data into your InfoProvider. To be able to use sign reversal in Reporting, you need to define a formula variable in the query definition:

  1. You are in the Query Designer. Under Key Figures, use the context menu to choose New Formula. The Formula Builder opens.
  2. Under Formula Variables, choose New Variable from the context menu. The variable wizard opens.
  3. Give the variable a name and a short text. Choose Replacement Path as the processing type.
  4. Choose your hierarchy basic characteristic.
  5. Choose Hierarchy Attribute as the replacement. The attribute Sign Reversal is automatically displayed.
  6. Save your formula variable. When defining the formula variable, you get the factor 1 or –1, with which you can multiply the required key figure.

...