Microsoft Analysis Services problem

ths · Post by **ths** » Fri 30 Dec 2011 08:07

Hello,
we tried to use dotConnect for Oracle provider (newest version) within Microsoft Analysis Services and could not do it. What happened is the following:
First step - create data source:
1. In the direct=true configuration the connection test from the Data Source Wizard of Analysis Services is successful. The connection is successfully created.
Second step - create data source view:
2. In the direct=true configuration the dialog from the Data Source View Wizard comes with info:
"No foreign keys were found. You can create logical relationships on matching columns."
This is already not ok because the actually available metadata were not retrieved.
In the next step you are presented with the list of database tables.
After selecting just 4 tables and pressing "finish" we get the message "Index was outside the bounds of the array".

MSAS is installed on the machine with Windows Server 2008 R2 Standard x64. From this machine we tried to access Oracle 11g x64 running on the machine with Windows 7 x64.

Any hints? We want to avoid installing Oracle Client on the server.

Vladimir

P.S. The result is the same with direct = false

Shalex · Post by **Shalex** » Tue 10 Jan 2012 10:44

We cannot reproduce the problem with dotConnect for Oracle Professional v 6.60.268 at the moment. Please give us the following information:
1. The version (2005 or 2008) and capacity (x86 or x64) of your SSAS?
2. The version (x.xx.xxx) and edition of your dotConnect for Oracle. You can find it in the Tools > Oracle > About menu of Visual Studio.
3. The options you have selected on the Name Matching step of Data Source View Wizard.
4. Please create a user with a limited privileges (not DBA, remove the privileges SELECT ANY TABLE and EXECUTE ANY PROCEDURE, set access only to the DEPT and EMP tables). Then create the DEPT and EMP tables in this schema (%ProgramFiles%\Devart\dotConnect\Oracle\Samples\tables.sql). Does it work in this case?

ths · Post by **ths** » Mon 16 Jan 2012 15:05

Hello,
Sorry for delay with answer.

1. The version of SQL Server is 2008:

select @@version
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

Microsoft SQL Server Analysis Services Designer
Version 10.50.1600.1

2. dotConnect for Oracle Professional Edition 6.60.268.0

3. Same name as primary key.

4. The example with EMP and DEPT works without error.

Shalex · Post by **Shalex** » Wed 18 Jan 2012 14:48

ths wrote:4. The example with EMP and DEPT works without error.

Could you please try to localize the issue? Send us the DDL of a particular schema and the steps we should follow to reproduce the error.

Shalex · Post by **Shalex** » Tue 31 Jan 2012 13:10

The bug with using SQL Server Analysis Services ("Index was outside the bounds of the array") is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Shalex · Post by **Shalex** » Fri 10 Feb 2012 12:12

New build of dotConnect for Oracle 6.70.302 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23367 .