SAP Crystal Reports 2011, Win Betriebsanweisung Seite 570

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 569
5.
Define your query by selecting measures and characteristics from the Key Figure and Dimensions
lists and dragging them to the Columns area.
Note:
When you create a new query for reporting purposes, it is recommended that you place Key Figures
in the Columns area of the Query Designer and Characteristics in the Rows area.
6.
Click Query Properties.
7.
Click the Extended tab and ensure that Allow External Access to this Query is selected.
This option allows other programs, like Crystal Reports, to access this query.
8.
Click Save Query.
9.
In the "Save Query" dialog box, click Roles and select the role where you want to save the query.
10.
Type a Description and a Technical Name for the query, then click Save.
The Technical Name must uniquely identify the query—that is, the name can appear only once
across all InfoProviders in BW. The Technical Name can be up to 30 characters long and must begin
with a letter.
Selecting BW Queries for a report
There are two ways you can access BW queries to use as Crystal Reports data sources. You can use
the SAP Tools toolbar in "Crystal Reports" or you can use the Database Explorer in Crystal Reports.
Using the SAP Tools toolbar to select an MDX query
Note:
The tutorials in this section use the SAP Tools toolbar to create new queries for reporting. However,
when creating new queries you can use whichever method you prefer.
Before you can see a query in the Database Explorer, you will need to set the “Allow External access
to the Query” option in its properties.
1.
On the SAP menu click Create New Report from a Query.
2.
When prompted, log on to your SAP BW system.
The "Select Query for your Crystal Report" dialog box displays the queries that are available through
your Favorites, Roles, and InfoAreas in BW.
3.
Select the query with the data that you want to report off, then click OK.
Crystal Reports generates a report that uses your query as its data source. The report opens in the
Design tab of "Crystal Reports". You can now add fields, titles, charts, and other objects to the
report.
Using the Database Expert to select an MDX query
1.
On the File menu in Crystal Reports, click New and then click Blank Report.
The Database Expert appears.
2012-03-14570
Integrating Business Applications with Crystal Reports
Seitenansicht 569
1 2 ... 565 566 567 568 569 570 571 572 573 574 575 ... 717 718

Kommentare zu diesen Handbüchern

Edwinfet 29 Feb 2024 | 08:13:09

What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a

KarenSkaky 17 Apr 2024 | 10:11:41

Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in

Helenlal 18 Apr 2024 | 08:19:10

Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen

Helenlal 29 Apr 2024 | 05:23:21

In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit

Chrisnug 29 Apr 2024 | 14:39:54

Hello, im noob :)