WebFOCUS Online Help > InfoAssist > Hierarchical Reporting in InfoAssist > Summary of Reporting Rules For Multi-Dimensional Data Sources
Reference: |
When you use InfoAssist to create a report using a multi-dimensional data source, certain reporting rules are enforced automatically. The tables below summarize these rules.
When you use InfoAssist 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:
Cannot be used in:
|
Hierarchy |
Only one hierarchy can be used in the report. Hierarchies can be used as:
|
Properties (also known as Attributes) |
Same rules as Hierarchy. |
When you use InfoAssist 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:
Cannot be used in:
|
Hierarchy |
Only one hierarchy can be used in the report. Hierarchies can be used as:
|
Properties (also known as Attributes) |
Same rules as Hierarchy, with the exception of:
|
When you use InfoAssist 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:
Cannot be used in:
|
Hierarchy |
Only one hierarchy can be used in the report. Hierarchies can be used as:
|
Properties (also known as Attributes) |
Same rules as Hierarchy. |
WebFOCUS |