Importing cube using XMLA

Hi,

We're trying to import cubes from SASS 2005 into Oracle BI EE (Siebel Analytics) using XMLA.

I tried to use SDK for Analysis 1.1 with the file msxisapi.dll but it uses msolap.asp on the AS server and I don't get any response from it (written in log).

In this forum I got a reply to use msmdpump.dll in order to create http access to SASS but it won't work with Siebel (shows empty list of databases) becaues I must use XMLA protocol.

Moreover, I don't think it's a security issue because I had managed to access the cube via Excel.

I will be graeful to gain some help.

> In this forum I got a reply to use msmdpump.dll in order to create http access to SASS but it won't work with Siebel (shows empty list of databases) becaues I must use XMLA protocol.

AS2005 aways uses XMLA protocol when you connect over HTTP (i.e. through msmdpump.dll). You may want to pursue this issue with Oracle (Siebel) to understand why you are getting empty list of databases.

|||Hi. I'm experience the same problem that you described, do you any solution?
Thanks.
mreyes@.itsolutions.com.gt

Importing AS 2000 cube into SSAS 2005

Is there any way to import a cube created in AS 2000 into SSAA 2005? If not a direct import is there any way to make that job easier? Any suggestions/pointer/comments would be helpful.

I have a lot of AS 2000 cubes and I am really sick of that development environment!

You can use the Migration Wizard (search for MigrationWizard.exe in the SQL installation folder, or right click on the server node in SQL Management Studio and use 'Migrate ...'). The wizard requires AS2000 to be running and can generate a migration script (that can be later run on AS2005 with SQL Management Studio) or can migrate directly to AS2005.

You cannot restore AS2000 backup files (.cab) on AS2005.

Adrian Dumitrascu