SAP 7090310 Ficha Técnica Página 571

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 706
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 570
To create a BW query with a hierarchy
1.
Go to Start > Programs > Business Explorer > Query Designer.
2.
Click Open Query.
3.
Select the query you created in the last tutorial.
If you have not created a query, see Building a report off a BW query.
4.
In the Rows area, right-click Material and click Properties.
The "Characteristic Properties" dialog box appears.
5.
Next to the Hierarchy Name field, click the Values button.
The "Select Hierarchy" dialog box appears.
6.
In the Available Hierarchies list, select Material class and click OK.
You are returned to the "Characteristic Properties " dialog box.
7.
Click OK and then click Save Query As... to save your query to the appropriate location.
For this example, in the Description field, type Simple Hierarchy for MDX, and in the Technical Name
field, type HIERARCHY_SIMPLE_MDX.
8.
Click Quit and Use Query.
You now have a simple query with three possible levels of hierarchy. You can display the query in either
the SAP Business Explorer Analyzer or as a dataset in Crystal Reports.
How to build a report off the BW hierarchy
The report that you build in this section starts using the same field as the report you created in Building
a report off a BW query. The difference comes with the grouping. Instead of grouping the data like you
did in the previous tutorial, you will group the data hierarchically. This way, the hierarchy that exists in
the data is reflected in the report.
This tutorial will use the following fields to create a hierarchical display:
Hierarchy Name Node ID
This field reflects the child values.
Hierarchy Name Parent ID
This field reflects the parent values. Combined with the Actual Node ID, Crystal Reports uses these
fields to determine the hierarchy based on the information received from the SAP BW query.
Hierarchy Name
This field contains the captions of the hierarchy members.
2011-05-16571
Integrating Business Applications with Crystal Reports
Vista de página 570
1 2 ... 566 567 568 569 570 571 572 573 574 575 576 ... 705 706

Comentários a estes Manuais

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema