Using PowerPlay Web with an Analysis Services Cube

By William E. Pearson III, May 19th, 2003 Posted in Cognos. Subscribe to our RSS Feed

Establishing Connectivity

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 introductory article, Cognos Applications Overview. This article assumes a “default” installation of Cognos PowerPlay (PPES and PPWEB 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’ll be acting as the Administrator on my server, with my user set up in Access Manager, but little else is 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.

See this tutorial for details on Enabling Connections to MSSQL Server OLAP Cubes in Configuration Manager

Once complete, read this tutorial for details on Connecting to the Analysis Services Cube using PowerPlay Connect – Simple Security

Written by William Pearson - Visit Website

Go To Page: 1 2 3 4 5 6 7

All Tutorials by Category:

Entire site Copyright © 1999-2007 2000Trainers.com, all rights reserved.
Content on this site may not be copied or reproduced in any way without permission.

IT Showcase