Dear Gurus,

I am working for a local bank implementing a financial statistical system.
We proposed to use SQL Server 2000 Analysis Server but the clients want to
use Cognos Powerplay for data analysis. Can Cognos Powerplay connect
directly to SQL Server 2000 Analysis Server without using Cognos Impromptu
as adaptor?

thanks in advance.

from,
Steven


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003

Hi,

There are some "advanced" features in MS OLAP Cognos doesn't support... i.e.
Actions and Drill Through. Thats why I don't recommend using Cognos wiht MS
OLAP... For me it's a good marketing instrument for Cognos to get into
projects with Microsoft backend technology... But when they're in, they try
to sell their own stuff which is very expensive... Cognos really got into
trouble with Microsoft here in Germany because they got leads from MS and
kicked them out later...



Thomas

"Steven" <yongcs (AT) streamyx (DOT) com> schrieb im Newsbeitrag
news:OYgN610XDHA.2476 (AT) tk2msftngp13 (DOT) phx.gbl...

Steven,

Yes it can. You will need to use the PowerPlay Connect tool to set to
establish a link to Analysis Services. Once you have created the stub
file using Powerplay with Analysis Services is fairly much the same as
using Powerplay with a transformer created cube.

Somewhre in your Cognos documentation you should find a guide called
"OLAP Server Connection Guide".

Regards

Rob

--
Posted via http://dbforums.com

PowerPlay is strong on graphical design of Olap reports. But the client does
not support writing MDX select statements, which is important for some
advanced reports. The need to configure a connection file(Power Play
Connect) for each new cube is to complicated and may require an
administrator. Powerplay is expensive and below average in supporting
important Analysis Services features. It is not my first choice.

/Thomas Ivarsson

"Steven" <yongcs (AT) streamyx (DOT) com> wrote

Thanks a lot for all the response. It is not our choice to tell the client
not to use Powerplay as they had purchased over 200 plus licenses quite a
while ago.
But Excel Olap is not able to perform something as flexible as Powerplay in
ad-hoc data calculation. and
my boss initially thought Excel OLAP is powerfula and flexible as Powerplay.

Anyway, thanks a lot and I appreciate all the advice. Really helps me.


"Thomas Ivarsson" <thomas_ivarsson_malmo (AT) hotmail (DOT) com> wrote


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003

Hi Reg,

My client is using Windows 2000 Professional with Cognos Powerply version
6.6 or 6.0. I can't remember the version exactly. regarding that you have
enabled the user to use excel to connect to the cube, can the user create a
local cube from that connection? coz' my client is really
concern about the staff creating local cube to be copied home. the data is
confidential coz' my client is a bank. they only let the staff analyze data
not to bring the whole cube with confidential data home.

"Reg Besseling" <reg.usenet.nospam (AT) epic-sc (DOT) com> wrote


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/13/2003