How to connect to BO from Excel 2007

[Former Member]

Hi everyone,

as I am new to BO I need help how to establish connection to a BO Universe from Excel 2007 - what components I need to install to be able to make the connection, and steps for creating the connection

Thanks in advance,

Maria

[Former Member · Accepted solution]

You need Designer and Microsoft drivers to create a Universe from Excel

below are the steps:

1) Create a DSN

2) In Designer, Create a Connection

3) Design Universe, Create classes and objects

4) export

[DDortants]

Hello Mario,

It looks like what you are looking for is the "live office" plugin/toolbar that is added to excel that allows you to import WEBI reports based on universes into excel.

Check this link for more info:

[http://www.sap.com/usa/solutions/sapbusinessobjects/large/business-intelligence/information-infrastructure/enterprise/live-office/index.epx]

Regards,

Duncan