Quickly creating Cube and Server OLAP connections

This post and accompanying video illustrate how to quickly create new OLAP connections in CMC by reusing the information already entered for another existing OLAP connection.

Normally, when creating new OLAP connections using New Connection menu, BI administrators would need to type in a number of entries such as the server name, language, or authentication information, which are typically the same for every connection off the same OLAP server.

To create new connections a bit quicker, instead of using New Connection menu, BI administrators could copy existing ones by invoking Copy menu item from Organize right-click context menu off an existing OLAP connection. This will result in a new connection being created with already prepopulated entries except for the connection name and the actual cube to connect to. The newly created entries can be further refined or simply saved as is.

The following video demonstrates how to perform these steps when creating a couple of new OLAP connections off SAP BW specifically Cube and Server connections.