Connecting to OLAP cubes

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference > Dashboard Designer > Providing Data >

Connecting to OLAP cubes

Dashboard for Desktop > Dashboard Designer > Providing Data > Connecting to OLAP cubes

The Dashboard Designer provides the capability to connect to an OLAP cube in the Microsoft Analysis Services database using the Data Source wizard.

To connect to an OLAP cube in the Dashboard Designer, do the following steps.

1.Click the New Data Source button in the Data Source ribbon tab.

img18472

2.On the first page of the invoked Data Source Wizard dialog, select Olap and click Next.

img117932

3.On the next page, choose the required Connection type. The following types are available.

oServer

oLocal cube file

oCustom connection string

ExpandedCollapsed Server

If you selected Server, the following options are available.

img118049

•Server name

Specify the name of the OLAP server to which the connection should be established.

•UserId

Specify the user name used to authenticate to the OLAP server.

•Password

Specify the password used to authenticate to the OLAP server.

•Catalog

Select a data catalog that contains cubes.

•Cube Name

Select a cube that provides OLAP data.

Click Finish to create a data source.

ExpandedCollapsed Local Cube File

If you selected Local cube file, specify the path to the requiredOLAP cube. To locate the cube, click the ellipsis button next to the Database field.

img118050

Click Finish to create a data source.

ExpandedCollapsed Custom Connection String

If you selected Custom connection string, specify a connection string in the Custom connection string editor.

img118051

Click Finish to create a data source.

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.