Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member184995
Active Contributor


Hello everyone,

I have seen posts and gotten support cases asking about where the Island Resorts Marketing sample database has gone in BI 4.0 and 4.1 and decided to write up this quick blog that shows how to find it and publish it to BI.

On the server go to <Install Dir>\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Samples\webi

You will see the club.mdb and Island Resorts Marketing.unv.



Open the Universe Design Tool and Open the Island Resorts Marketing.unv

Once it is open, click on File|Parameters



Under the Connection drop down, select New



NOTE: In 4.3, you will need to open the ODBC 64 bit panel, delete the club-webi connection that is installed (as by default it uses MS Access 2007 ODBC) and recreate it using the 2019 version. You can then continue on below, making sure to select 2019 for the middleware section.

Create a new Secured Connection, naming it whatever you want and click Next



Select Microsoft|MS Access 2007|ODBC Drivers then Next



On the Data Source Name drop down, select club-webi, which is a DSN created when you install the product. If it is not created you will need to create a DSN yourself to the Island Resorts mdb (for example on your desktop machine)



Click on Test Connection



Click OK then Next

Click Next again

Click Finish.

Verify your new connection is being used by the universe



Click Ok

Select View|Refresh Structure



When prompted to refresh out of date tables, click OK



Then click Ok again when it states they are updated.

Click Save

Click File|Export

Browse to the location in BI that you want to store the universe



Click Ok then Ok again to export it



You can now use it to create sample reports!

That's it!

You can now use the Island Resorts Marketing universe for your testing needs!

Hope this helps!

Jason

1 Comment