Adding an Olap Data source in Studio with the same cube alias name as a Relational data source

Technote (troubleshooting)


Problem(Abstract)

In Clarity Studio, when adding an OLAP data source with a cube alias name identical to a relational data source (inside web\bin\config.xml), Clarity Studio will add the OLAP data source as a relational source.

Symptom

When you right click on the added source, the menu options that are available to a relational data source are available for the added OLAP data source.


Cause

The name of a relational data source is the same as the alias of an OLAP data source (OLAP Manager)

Environment

Server: 7.0.1.230

Studio: 7.0.9.4043

SQL Version: 2005 9.00.5057 00 (x64)


Diagnosing the problem

Check the Code View in Studio, the Provider is "Relational" instead of "AnalysisServices"

Also, a relational icon is displayed next to the added OLAP data source.

Resolving the problem

While there is no permanent fix, there are a few options to work around this issue:

1) Change the Alias of the Cube in OLAP Manager

2) Change the value of the Provider attribute from "Relational" to "AnalysisServices"

An APAR has been created PM68123.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Clarity 7
Clarity Studio

Software version:

7.0, 7.2, 7.2.1

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1606803

Modified date:

2012-11-20

Translate my page

Machine Translation

Content navigation