Summary of Reporting Rules For Multi-Dimensional Data Sources

Reference:

When you use Report Painter to create a report using a multi-dimensional data source, certain reporting rules are enforced automatically. The tables below summarize these rules.


Top of page

x
Reference: Summary of Reporting Rules for SAP BW

When you use Report Painter to create a report using an SAP BW data source, the following rules are enforced automatically.

Component

Rules

Variables (also known as Parameters or Filters)

Variables cannot be displayed in a report. They can only be used in a Where statement.

Note: There is one exception to this rule, and that is if the variable is the only field in the request.

Single Value Variables should only be used with the EQ operator and only one literal (value) should appear in the Where statement. It is possible to use an amper variable.

Mandatory Variables require a value and must exist in the report. You can use these to create a Where statement. A warning message appears if you run the report without creating a Where statement for a mandatory variable.

Measures

Can be used in:

  • Computes.
  • Sum.
  • Where Total statements. When creating a Where Total statement you should enter values manually instead of retrieving values.

Cannot be used in:

  • By fields.
  • Defines.
  • Across fields.
  • For.
  • Where statements.
  • Headings or footings.

Hierarchy

Only one hierarchy per characteristic can be used in the report. Hierarchies can be used as:

  • By field.
  • Across field.
  • For.
  • Detail fields.
  • Defines.
  • Computes.
  • Where statements.
  • Headings and footings.

Properties (also known as Attributes)

Same rules as Hierarchy.



x
Reference: Summary of Reporting Rules for Essbase

When you use Report Painter to create a report using an Essbase data source, the following rules are enforced automatically.

Component

Rules

Variables (also known as Parameters or Filters)

Cannot be used for an Essbase data source.

Measures

Can be used in:

  • Computes.
  • Defines.
  • Sum.
  • Headings or footings.
  • Where Total statements. When creating a Where Total statement, you should enter values manually instead of retrieving values.

Cannot be used in:

  • By fields.
  • Across fields.
  • For.
  • Where statements.

Hierarchy

Only one hierarchy per characteristic can be used in the report. Hierarchies can be used as:

  • By field.
  • Across field.
  • For.
  • Detail fields.
  • Defines.
  • Computes.
  • Where statements.
  • Headings and footings.

Properties (also known as Attributes)

Same rules as Hierarchy, with the exception of:

  • Defines, which cannot be used for an Essbase data source.


x
Reference: Summary of Reporting Rules for Microsoft Analysis Server 2005

When you use Report Painter to create a report using a Microsoft Analysis Server 2005 data source, the following rules are enforced automatically.

Component

Rules

Variables (also known as Parameters or Filters)

Cannot be used for a Microsoft Analysis Server 2005 data source.

Measures

Can be used in:

  • Computes.
  • Headings or footings.
  • Sum.
  • Where Total statements. When creating a Where Total statement, you should enter values manually instead of retrieving values.

Cannot be used in:

  • By fields.
  • Defines.
  • Across fields.
  • For.
  • Where statements.

Hierarchy

Only one hierarchy per characteristic can be used in the report. Hierarchies can be used as:

  • By field.
  • Across field.
  • For.
  • Detail fields.
  • Defines.
  • Where statements.

Properties (also known as Attributes)

Same rules as Hierarchy.


WebFOCUS