MetaManager - Administrative Tools for IBM CognosPricing starting at $2,100Download Now Learn More
Started by matrixfree, 27 Apr 2016 12:47:19 PM
Quote from: matrixfree on 28 Apr 2016 10:15:17 AMThank you Lynn,mainly at those spread-heads who simply insist on living in a green world of numbered rows and lettered columns with the word Excel ==> I agree with you.p.s by the way are they very expensive tools ?
Quote from: Lynn on 28 Apr 2016 03:50:14 AM I think it is aimed mainly at those spread-heads who simply insist on living in a green world of numbered rows and lettered columns with the word Excel somewhere in constant view. Sort of like a two-year-old who insists on having a particular blanket or favorite stuffed toy always in sight :D
Quote from: hespora on 17 Aug 2016 02:33:15 AMI gotta say, I actually take offence to that. ;)One of the main differences of Cafe over RS is the fact that all except the most basic calculations are done completely client side in Excel, rather than by the query service. For a certain group of my org's users, I've developed a report in RS that would allow them to analyze historic pricing. The whole thing is laid out as an interactive report in html. Now, thanks to cognos' piss-poor performance when it comes to master-detail relationships, this thing takes 6-8 minutes to run (3 repeater tables containing a list and a chart object, to each of which the detail query is a staggered join), which of course renders it completely unusable for ad-hoc analysis. Built the whole thing in Excel with Cafe, runs in 40sec. Knowing which tool to use when is key. Don't bash a tool just because you haven't found a use for it yet. ;)
Quote from: hespora on 18 Aug 2016 02:06:04 AMThe point is using or not using the tools *available*. I am business, I am not IT. As in, I am a report designer slash analyst with access to packages published by IT. If my org's IT only publishes certain data in a relational package rather than dimensional, there's nothing I can do about it except make do with what I got. And thus, from the limited resources I have available, I need to choose the best tool available for the job./Edit: Also, wha makes you think you know that an OLAP cube would have performed any better in this particular task? The report encompasses a dynamic calculation actually on row level of the DB which, as both user inputs via prompts and Facts from row level go into it, kills each and any performance advantage a precalculated and -aggregated cube would have.