I am trying to create a OLAP connection in webi XI R2 for Sql Server 2005. When I select New -> OLAP Intelligence Connection, I got a screen to enter Title, Description and Type (With dropdown).
In Type dropdown box, I only see 3 types:
Hyperion Essbase (7.0, 7.1) / IBM DB2 OLAP (8.2) Enhanced
IBM DB2 OLAP Server (Legacy)
Hyperion Essbase (Legacy)
How do I create a connection for SQL Server? Do I need to do anything in CMS? Or, do I need to change something in config files?
I did a search in this forum, but didn’t find anything related.
I am having the same issue, and it looks like it might be a license issue fr me. I am testing on XIR2 SP2 with the Prod. Pack installed. This includes Voyager. BO gave me two new license keys (my old OLAP keys were not valid) and I am now in the process of creating a new Voyager Connection in the CMC. Before adding the license keys i was getting the error “You do not have a license to create new Voyager objects”. Now i am gettign the message “Please check if the MDAS server is running, or if the database client software has been installed on the MDAS server”. It looks like i am in the right direction, but not there yet.
Have you contacted BO Licensing for new keys?
I will update this posting once i add a OLAP/Voyager connection.
On the Business Objects Server box, install the SQL Server 2005 Client tools. Once you do this and reboot the server, you will see the “Microsoft OLE DB Provider for Analysis Services 9.0” which corresponds to SQL Server 2005 OLAP Engine, for SQL Server 2000, install the SQL Server client tools on the BOXI server and you would see “Microsoft OLE DB Provider for OLAP Services 8.0”. We have both links working with Voyager in our company. Hope this helps.
Apparently, I was wrong. I thought I had SQL 2005 Analysis Services connection visible within the Universe Designer and that does not seem to be the case. Anyone who has converted a SQL 2005 OLAP cube into a XI R2 Universe? Is this an option that will work in 3.0? Sorry for the confusion and appreciate any feedback.
Hello Experts,
I have BOXI 3.0 and MSAS2000 on a machine. I installed SQL Server Express 2008 and analysis services 10.0 OLEDB Provider in the same machine.
When I try to create Voyager connection on CMC, I see only Microsoft OLE DB Provider for OLAP Services 8.0 only.
What should I do to get 10.0 provider in the dropdown.
(BOB member since 2002-09-05)
(BOB member since 2003-12-17)
(BOB member since 2005-01-06)
(BOB member since 2005-01-06)