How to find and use the Island Resorts Marketing database and universe in BI 4.x
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
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
Verify your new connection is being used by the universe
Select View|Refresh Structure
When prompted to refresh out of date tables, click OK
Then click Ok again when it states they are updated.
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!
You can now use the Island Resorts Marketing universe for your testing needs!
Hope this helps!