April 10, 2009 at 11:12 am
Our BI team invested in the QlikView BI platform. Has anyone used this before? What is different about QlikView vs. Microsoft Reporting Services and Analysis Services. I read something about Microsoft Gemini BI tool. I'm still doing some research but I just wanted to get feedback if anyone is using it or have used it.
Thanks
April 12, 2009 at 1:00 am
Hey greggoble2,
I've used QV a fair bit. I would encourage you to download the free trial and experiment. Your question is just a little to broad to reply in detail.
FWIW, I would love to see in-memory analysis entirely replace the over-complex and inflexible nonsense that is (M/R/H)OLAP-based cubes.
Cheers,
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 13, 2009 at 2:11 am
Hey greggoble2,
QV is now the leading product in in-memory based solutions for analysis and is a serious challange to what Paul says about OLAP.
Try it and Google about other opionions
/Gosta
April 13, 2009 at 5:37 am
From what I have heard it is a quick startup solution to implement analysis for business that do not have OLAP (like with Business Objects), but it is not a solution that will scale well for hundreds of users. If you are looking for that type of solution you would want to stay with SSAS. If in-memory capability is something you are looking for then this will be coming next year with Kilimanjaro release and Gemini.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 5:46 am
Dan
"From what I have heard it is a quick startup solution etc"
I don't agree. Take a look at the product.
/Gosta
April 13, 2009 at 6:07 am
Ok, you are entitled to your opinion and I looked at the product and I don't expect everyone to agree with everyone else. This is a potentially quick startup solution like I stated for companies that do not have a scalable OLAP solution like SSAS already in place. Maybe 'quick' is not accurate, since I have never used the product, but just viewed the videos. If you are using Business Objects I could see how this would be something that you might want to consider to implement in order to get OLAP functionality without using SSAS.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 3:06 pm
Hey Dan,
In my experience, it is SSAS (and cubes in general) which do not scale well.
The last QV solution I worked on had 2,500 users (admittedly only 50 or so were hard-core analytic types, but still...)
QV can easily handle billion-row "fact tables" (the terminology does not translate exactly), with more joins than you can throw a large stick at, on commodity hardware (out server cost GBP 10K) - returning results usually sub-second, worst case a few seconds. Not bad for a model which allows true freedom of selection, without worrying about supporting aggregates, for example.
Anyone who thinks it is too good to be true shares my initial attitude. I would encourage you to try it out 🙂
Paul
(no association with the company or its products other than as a end-user developer, so don't get the astroturf out...)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 17, 2009 at 2:39 pm
Thanks all
April 28, 2009 at 11:55 am
This was a good article about my question.
April 29, 2009 at 3:56 am
Yes - I read that today, though I thought it was a bit light on specifics, it is not a bad general overview.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply