User
name and password stored in the connection string are only used to create
the universe, and for end-users to create and run queries in the event
the SSO option is not activated.
You create a connection to a BW Cube or Query Cube. Each connection maps the structures in the cube data source to a universe. One connection must be created for each cube that you want to use to create a universe.
There are two ways to create a connection:
· From the Connections list (Tools > Connections). This method is documented in the section To Create a OLAP Connection below.
· From the Parameters dialog box. This box appears when you select File > Parameters or click the new universe icon. From the Parameters page, you click New, and the New Connection Wizard appears. The steps through the wizard are the same as documented below.
To create a OLAP connection
1. Start Designer.
2. If the Quick Designer Wizard appears, click Cancel.
3. Select
Tools > Connections.
The Connections list appears. All the connections available to the current
Designer session are listed here.
4. Click
Add.
The New Connection wizard appears. The wizard guides you through the connection
creation process.
5. Click
Next.
The Database Middleware page appears. It lists the database and middleware
that correspond to your Data Access driver key.
6. Expand
the node for your target OLAP datasource.
This is the target database for the connection. The node expands to the
supported middleware.
7. Expand
the middleware node.
The OLAP data access driver appears. This is Business Objects data access
driver for the OLAP middleware.
8. Click the data access driver.
9. Click
Next.
The Login Parameters page appears. For SAP BW, you have the following logon
options:
| Logon options | Description |
|---|---|
| Type | Security level for connection. You must use a secured connection to export the universe to the CMS. |
| Name | Connection name. This is the name that appears on the list of connection available to the universe. |
| User name | Your database user name |
| Use Single Sign-on when viewing reports | The user name and password used to access the CMS are automatically used as database login parameters. See the BusinessObjects Enterprise Administrator's Guide for information on setting up Single Sign-On. |
| Password | Your database password. |
| Server | Name or IP address of the BW server that contains the target cubes. |
| System | Required SAP login information. For example 00. |
| Client | Required SAP client number. |
| Language | Connection language. For example EN for English. |
User
name and password stored in the connection string are only used to create
the universe, and for end-users to create and run queries in the event
the SSO option is not activated.
10. Type
or select logon options and click Next.
The Cube browser appears. This shows all of the OLAP cubes available to
the target server.
You have the following features available to facilitate cube searching:
| Cube browser tools | Description |
|---|---|
| Favorites | Folder that holds links to cubes that you select for quick access. To add a cube to Favorites, right click a cube in the OLAP cube browser and select Add to Favorites from the contextual menu. |
| Search | Searches the names of available cubes for a text string. Type a string in the text box and click Search. Each found instance is highlighted. Click Search to continue searching. |
11. Expand cube nodes to display the cubes and query cubes available. Select the target cube. This is the cube that you want to use to create a universe.
12. Click
Next.
The Advanced page appears. This lists connection parameters that you can
set to manage the connection. See the Data Access Guide for information
on setting Advanced parameters. You can accept the default settings when
you create the connection and modify them at any time later.
13. Type
or select Advanced options and click Next.
The Custom page appears. There are no parameters listed on this page for
OLAP connections.
14. Click
Next.
The Connections list appears. The new connection appears in the list.
15. Click Finish to complete the connection creation.