Skip to Content

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.

IslandResortsLocation.png

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

Once it is open, click on File|Parameters

IslandResortsFileParam.png

Under the Connection drop down, select New

IslandResortsNewConn.png

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

IslandResortsConnName.png

Select Microsoft|MS Access 2007|ODBC Drivers then Next

IslandResortsMSAccess.png

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)

IslandResortsDataSourceName.png

Click on Test Connection

IslandResortsTestConnection.png

Click OK then Next

Click Next again

Click Finish.

Verify your new connection is being used by the universe

IslandResortsConnUsed.png

Click Ok

Select View|Refresh Structure

IslandResortsViewRefresh.png

When prompted to refresh out of date tables, click OK

IslandResortsRefreshOk.png

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

IslandResortsExportLoc.png

Click Ok then Ok again to export it

IslandResortsExportSuccess.png

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Carly Thomas

    Nice work.  I have to do this a lot when validating certain WebI issues.  Mainly those requiring a date object.  It’d be cool if we shipped it with the secured connection like we used to (and do for eFashion).

    (0) 

Leave a Reply