Procedure
- Select the cell in the worksheet
where the crosstab with the data from the selected data source should be
inserted.
- Select
Insert Data
Source.
The
Log on to SAP
BusinessObjects BI platform dialog box appears.
- Log on to the platform you want to
use:
- Enter your
User,
Password
and the
WEB Service
URL to log on to the business intelligence platform.
- Select
Skip to
use the SAP NetWeaver platform. Log on to a BW system directly without using
the business intelligence platform. Continue with step 7 if using this log on.
Note If you log on with an initial password to
a BW system, or your password is expired and needs to be reset, the dialog for
changing the password opens automatically.
- Optional step: Enter
System and
Authentication.
You will normally not be
asked to supply this information. However, if you are asked to log on to a
special Central Management System (CMS), you can add these two additional
fields to the dialog box by selecting
Options.
Enter the name of your Central Management System in the System field and the
authentication type in the
Authentication field.
- Press
OK.
The
Select Data
Source dialog box appears.
- Select a connection in the
Show
Connections list:
- If you select
All, all
available systems, Cubes / InfoProvider and Query / Query views on the business
intelligence platform are displayed.
- If you select
System,
all available systems on the business intelligence platform are displayed.
- If you select
Cube /
InfoProvider, all available Cubes and InfoProvider on the business
intelligence platform are displayed.
- If you select
Query / Query
View, all available Queries and query views on the business
intelligence platform are displayed.
- If you select
Local
System, all systems in your local
SAP
Logon are displayed.
- Select a system and press
Next.
To select a Query, query
view or InfoProvider directly, double-click the object you want to select.
The
Logon to
System dialog box appears.
You can refresh the displayed system list by
choosing
Refresh
in the context menu or pressing
F5, for
example after adding a new system to the SAP Logon.
- Enter
Client,
User and
Password in
the fields and press
OK.
If you want to specify the
system language, select
Options and
enter the language in the
Language
field.
- Select a data source in the
Select Data
Source box and press
OK.
On the
Folders
tab, you can navigate in the
Roles,
InfoAreas
or
Workspaces views to find a data
source.
On the
Search
tab, you can search for the description or technical name of a data source. To
retrieve data sources that begin with a specific string, you can type
* after a
partial string.
Results
A new crosstab with the data of the selected data
source is inserted into the worksheet. The SAP style set
SAP Black&White is used as
default. You can now analyze the data and change the displayed data set
according to your needs. You can also add other components to your analysis,
charts for example.