Has anyone managed to use Cognos against Analysis Service 2005 cube? If so any help or point of reference welcome!
Thanks
Sutha
Hi Sutha,
No direct experience I'm afraid but I was talking to Allan Mitchell last night (and where were you, eh?) and he mentioned that he'd had Cognos people in to do a PoC on one of his AS2005 cubes and they were unable to get it to work properly either. Drop him a mail and he might be able to fill you in with the details.
Chris
|||Since I'm also interested in finding out how well Cognos 8 leverages the AS 2005 feature set, I've Googled some relevent yet "only slightly better than nothing yet" findings this morning, and I'm posting summaries and links here...
Cognos Link to 7/11/07 article indicating Cognos 8 Controller 8.2 Software Environments
Updated: July 11, 2007 ... support of AS 2005 SP2, is listed by Cognos as "compatible", meaning partially tested by Cognos and/or tested or asserted by a Cognos Partner (vs. "Active" (fully tested and supported) or "not supported").
http://support.cognos.com/en/support/products/controller82_software_environments.html
Older Cognos Link to 7/11/2006 article indicating Cognos 8 MR2 does (at least at time of article) [or did] NOT SUPPORT SSAS 2005 cubes. http://support.cognos.com/en/support/products/cognos8mr2_software_environments.html#olap
Request Feedback from Anyone Directly Experienced in Attempting to Connect Cognos 8 with AS2005 Cubes.
As an AS2005 worker (not Cognos), I'm keen to hear how well Cognos' 8's reporting and/or "downstream-from-OLAP" analytics environment can leverage the AS2005 feature set. It's scary not seeing an "Active" (fully tested, Cognos-approved) rating by Cognos in the above link.
Daniel Upton
www.decisionlab.net
|||Hello! I have came across some implementatiions of Cognos on top of SQL Server 2000 and SQL 2005.
My conclusions are:
Cognos work best with its own cubes, read Transformer. The support for AS2000 cubes, last year, did not include named sets, six years after the release of AS2000, The support for SSAS2005 was nonexistent.
Cognos supplies products on top of other suppliers RDBMS products and is very frequently bought by customers that do not know that SQL Server 2005 includes SSAS2005 and SSRS2005. I have seen customers who have bought SQL Server 2005 and wasted money on Cognos 8 on top of that.
|||I don't know if you mean how to use Powerplay against an AS Cube, but this is from a link from cognos support on how to use AS2k5 as a datasource.I don't have a Cognos Series8 install here to test this with, and it surely didn't work in Series 7 
Title:
How to use Microsoft Analysis Services 2005 Cubes in Cognos 8.2
Document#:
1031921.1
Updated:
Jun 21, 2007
Applies To:
Cognos 8 BI Analysis Studio 8.2 | Cognos 8 BI Cognos Connection 8.1 | Cognos 8 BI Framework Manager 8.2
Cases:
3
Collection:
KB
Description:
How to setup Microsoft Analysis Services 2005 Cubes in Cognos 8.2 as Data Source
Environment:
Win 2003 Standard Edition/ Enterprise Edition, SQL Server 2005 (SP2), Cognos 8.2
Steps:
Run the Cognos 8 service as a Domain Account (ie Cognos_service)Add (Cognos_service) to SQLServer2005MSOLAPUser$<server_name>$<instance_name> Group on the machine running SQL Server 2005
Add (Cognos_service) to the role for under the database running the Analysis Service Cube
(Open MS Server Managerment Studio > Login to Analysis Services Server > Open the Database running the cube > Create a Role and assign read access to at least one cube inside the database and add (Cognos-service) to the role).
Go to Cognos Connection > Tools > Data Source > New Data Source > Name the Data source > Type ( Analysis Service 2005 ) > Host Name <Enter the host name of SQL Server 2005> > Named Instance <Enter the Instance Name of SQL Server>
{ If you don't have a defined instance leave this field blank. To check the instance name logon to MS Server Management Studio. Expected format <Host Name>\ <Instance Name> ( MS Analysis Server 9.00.XXX ) - <Host Name>\< user name>.}
Test the connection.
Finish|||Oh, scratch that, i guess you were looking to use PP, guess i should have read the topic, and not the post
|||
Chris,
Actually, if you were describing how to connect the Cognos reporting environment (with which I'm not familiar) to an AS2005 cube, then that is relevent. I don't currently plan to use a PP cube. Thx.
Of course, just connecting from Cognos does not mean that Cognos really leverages the AS2005 feature set, right? On that note, do you have any feedback on that question?
|||OK. You're confirming my suspicions, which is helpful. Thanks, Thomas.
However, Cognos' support of AS2005 SP2 was quoted as "compatible" on the Cognos site (link is on my initial post on this thread.
Has anybody at MSDN has seen this alleged Cognos "compatible" support of AS2005 SP2 in action? If so, how did it do?
Daniel Upton
www.decisionlab.net
|||According to this page AS2005 is still not supported:
http://support.cognos.com/en/support/products/cognos8mr2_software_environments.html
Not Supported
Not Supported
I supect that the support, when it arrives, will be limited for business logic, like named sets, because PP have it own calculation engine for that. Their strategy is to use other suppliers cubes as nothing more than data stores and keep the business logic inside its own products.
Regards
Thomas Ivarsson
|||Interesting. So, let's suppose for a moment that Cognos 8's interface has great capabilities to build, on a raw AS2005 cube, with queries, calculated members, named sets, KPI's, by visual interface and/or MDX -- and create dashboards, reports, etc. Finally, let's also assume that no cube transactions or actions are necessary. In this context, what really bad limitations will be encountered by, say a legacy Cognos Team newly implementing AS2005, with doing that biz logic outside of BIDS and Analysis Svcs? Let's also suppose here that no cube translations or actions are necessary.
|||No limitations except that all your business logic will reside in Cognos and you are unable to use tools from different suppliers. This strategy is almost the same as ProClarity have used except that ProClarity supports business logic in AS2005(MDX scipts) and provide its own tools for that.
And when organizations and business migrate to Office 2007, Excel 2007 will support SSAS2005 features.
Regards
Thomas Ivarsson
|||I totally agree with you on that. Thanks very much, Thomas, for the extended dialogue. Very helpful!
Daniel Upton
|||Cognos 8.2 supports AS2005 SP2 and AS2000 as a datasource. I have implemented that at our site. Yes you don't need cognos once you have SQL Server. But sometime politics plays a role.Best Regards
|||
Hello Jason,
Yes Cognos8 work on SSAS, but performance are very slowly, and nothing to help for this problem, Cognos say look at MS, and Ms don't say nothing.
Why an Excel is 10 time faster than Cognos 8 analysis studio when we are querying an SSAS CUBE?
Customer are nos so happy at end !!!
pascal
|||Hello Chris.
I use Cognos 8 with SQL2000 cube, and with SQL2005 cube,
the main problems are :
1 - to publish SSAS cube we use Framework Manager and we can't add filters, properties, calculations.
2 - Performance are incredible, i say 10 time slower than Excel or Cube Browser, and we have nothing to help .
3 - Sometime i try to play with Reporting Services, but customer's say "i'ts not standard !"
Any idea to check performance at all levels ?
Merci de Suisse .
No comments:
Post a Comment