BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BO to MSTR or Cognos


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
Rich
Forum Associate
Forum Associate



Joined: 04 Oct 2002

Posts: 910
Location: London


flag
PostPosted: Tue Jan 14, 2020 9:12 am 
Post subject: BO to MSTR or Cognos

I've been asked to look at migrating off BO to MSTR or Cognos, the powers that be have stated these are the only two products I can migrate to and I must pick one.

Currently we have a typical BO setup with lots of schedules and powers users building reports etc etc in Webi, looking to migrate around 300 reports. I don't know MSTR or Cognos apart from some vender demos we have had and what I have seen myself from looking online / youtube.

Anyone who knows these products and has real world experience of it if you were asked to move off BO what would you pick MSTR or Cognos ?

thanks

_________________
Business Objects v5, v6, XI R2 and R3.1. Oracle 9i - 11g. OBIEE 10g - 11g (Oracle Business Intelligence Enterprise Edition), OWB 10g, 11g (Oracle warehouse builder). SAS 9.2. Sybase ASE and IQ. Qlikview. Spotfire.
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1919


flag
PostPosted: Tue Jan 14, 2020 11:14 am 
Post subject: Re: BO to MSTR or Cognos

Like for like I think Cognos (it`s called Cognos Analytics now) is probably most BI 4.2 a like. Server side is horrible though (seems very resource heavy to me) and so are the thick client tools, some look to have been written in the 1990`s. The web front end is nice though, albeit from what I could tell not as powerful as Webi. Would be a lot of work involved re-doing the Universes into Cognos packages too, it`s basically a complete re-write.

Personally, unless this is for costs (which I doubt it is coz neither are cheap!) I wouldn`t bother!

_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
Back to top
Rich
Forum Associate
Forum Associate



Joined: 04 Oct 2002

Posts: 910
Location: London


flag
PostPosted: Tue Jan 14, 2020 12:35 pm 
Post subject: Re: BO to MSTR or Cognos

Thanks - luckily I don't have to manage the backend server side these days we just use a central shared platform where I work for all the reporting tools.

Agreed it is a rewrite whatever we go to, its not something we want to do but its being forced on us as part of a wider company initiative to ditch BO completely. I've told them it will be a nightmare to do and also we are the first in the company to do it. The BO platform we have is around 11 years old so I'm currently trying to decom as much crap as I can. We have Tableau already but just not what we need to replace the type of BO reports we have and the type of scheduling we need.

cheers

_________________
Business Objects v5, v6, XI R2 and R3.1. Oracle 9i - 11g. OBIEE 10g - 11g (Oracle Business Intelligence Enterprise Edition), OWB 10g, 11g (Oracle warehouse builder). SAS 9.2. Sybase ASE and IQ. Qlikview. Spotfire.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11526
Location: Manchester, UK


flag
PostPosted: Thu Jan 16, 2020 8:03 am 
Post subject: Re: BO to MSTR or Cognos

Why swap out BO for Cognos, it can't be for cost reasons!

I'd also go for Cognos - Framework Manager you'll find is very much like UDT/IDT with its three level approach to the semantic layer. The reporting tool isn't as good but if you do any OLAP work, then Cognos beats BO because it has its own cube functionality.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1919


flag
PostPosted: Fri Jan 17, 2020 4:51 am 
Post subject: Re: BO to MSTR or Cognos

There`s not any functional reasons in Cognos for the change is there?, they have this really cool tools in the stack, like event studio where there`s no comparison in SAP BI. I did a migration study for a customer recently where the idea was going Cognos > SAP BI, however, they were heavily dependant on some of these niche things Cognos did.

In terms of the reporting tool being better, that depends if you look at the newest version of Cognos Analytics. It`s moving into the more data visualisation sphere as opposed to reporting (it looks more like SAC than it does old Cognos!).

_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11526
Location: Manchester, UK


flag
PostPosted: Fri Jan 17, 2020 9:37 am 
Post subject: Re: BO to MSTR or Cognos

I agree Andy - it would take a significant functional requirement to ditch the overall investment (training, experience, development, etc.) in BO to move to Cognos (or vice versa to be fair). It's only when a tool isn't fit for purpose (functionally or financially) that you should be looking at moving.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Rich
Forum Associate
Forum Associate



Joined: 04 Oct 2002

Posts: 910
Location: London


flag
PostPosted: Sat Jan 18, 2020 2:59 pm 
Post subject: Re: BO to MSTR or Cognos

Cheers ABILtd and Mark P.

Yeah it a crazy idea to move off BO to a different tool I totally agree, the amount of work required is massive for no real benefit, where I work though BO is now none approved technology and anyone on BO has to move to either Cognos or MSTR. Not sure why its not approved but its coming from the top so have no choice.

_________________
Business Objects v5, v6, XI R2 and R3.1. Oracle 9i - 11g. OBIEE 10g - 11g (Oracle Business Intelligence Enterprise Edition), OWB 10g, 11g (Oracle warehouse builder). SAS 9.2. Sybase ASE and IQ. Qlikview. Spotfire.
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1919


flag
PostPosted: Thu Jan 23, 2020 4:59 am 
Post subject: Re: BO to MSTR or Cognos

Drop a 300 day migration project plan on someones desk, it might help sway the decision icon_smile.gif
_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0422 seconds using 17 queries. (SQL 0.0095 Parse 0.0009 Other 0.0318)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo