We will assume a basic understanding of
Cognos PowerPlay throughout the article, as well as a proper installation of
the software in general, as we noted in the introduction above. This article
assumes a "default" installation of Cognos PowerPlay (PPES and
PPWIN components), as well as the correct installation of Cognos
Connect. I am assuming, furthermore, that you are configured as a Cognos
user in Access Manager and have the appropriate rights / privileges to
complete the steps in this article, or that you have been allowed temporary
privileges. (I will be acting as the Administrator on my server, with my
user set up in Access Manager, but with little else configured in the
way of sophisticated security.) Finally, the article assumes you have access
to the MSSQL Server / the Analysis Services sample cubes, be it via Windows
Authentication Mode or Mixed Mode (for purposes of this article, I'm using SQL
Server authentication). Keep in mind that the multiple potential security
configurations in our individual environments may result in some differences in
the steps (log in requests, etc.) as we proceed.
to MSSQL Server OLAP Cubes in Configuration Manager
The following steps are critical in
establishing connectivity to cubes that reside on a server with PowerPlay
client; we also must have connectivity established to view cube data from the
web. We begin by taking the following steps to configure PPES to access
the appropriate driver:
Click the Start button.
Select Programs -> Cognos
EP Series 7.
Select Tools from the Submenu
Select Configuration Manager,
as shown in Illustration 1.
Illustration 1: Select
Manager Welcome dialog, Introduction tab appears, as shown in
Illustration 2, unless the feature has been disabled prior to this use.
2: The Configuration Wizard - Welcome Dialog, Introduction Tab
The Configuration Manager Welcome
dialog, Start tab appears, as shown in Illustration 3.
3: The Configuration Wizard - Welcome Dialog, Start Tab
Click the Open the Current
Configuration button on the Start tab (shown circled in Illustration
The Configuration Manager dialog
(my Current Configuration appears as "Untitled") appears, as
shown in Illustration 4.
4: Current Configuration Dialog (Compressed View)
the Configuration Manager dialog did not appear as shown above, simply select File
> Open Current Configuration to reach the same point.
Expand the server (in the left
pane), as shown in (partial view) Illustration 5 (mine appears in the
illustration as MOTHER), by clicking the "+" sign to
its left, if necessary.
5: Expand the Server (Shown as MOTHER) ...
Expand Services within
the hierarchy of the tree.
Expand OLAP Data Access
under Services, as shown in Illustration 6.
6: Expand OLAP Data Access, under Services (Partial View)
Select 3rd Party
(the default) to "1" in the right pane, just to the right of Microsoft
OLAP Service, as depicted in Illustration 7.
7: Enabling MSSQL Server OLAP Cube Selection (Compressed View)
Right-click OLAP Data Access in the left pane.
The context menu shown in Illustration
8: OLAP Data Access Context Menu
Click Apply Selection to
apply the change made in Step 11 above.
A warning message box appears.
A status meter indicates update
progress, and then a message box appears confirming successful application of
Click File ->
Save to save our change within
Configuration Manager. If prompted to assign a name / location for the .ccs
file, do so.
Select File ->
Exit to close Configuration
We have enabled the creation of
connections with MSSQL Server OLAP cubes. Now, let's take the steps to connect
to our Analysis Services cube. First, we'll introduce PowerPlay Connect.