Nice Read: A Quik Look at QlikView
Funny, while Oracle is still denying the fact that Qlikview is a real competitor to the solutions offered by Oracle on BI I was very surprised by the fact that one of the blogs I’m following for a long long while and that is (in my humble opinion) an authority on Oracle BI related issues writes a little review about qlikview. Mark Rittman (an oracle ACE) and the specialist on Oracle BI, essbase, hyperion etc. writes:
“the total size of the QlikView document (including the data) was only 4MB and took about 1 minute to load and prepare, whereas the corresponding Essbase data set (as built in this OTN article) took up several gigabytes of space and took over an hour to load and prepare. Impressive stuff.”
And:
“This ability to report against normalized data obviously makes setting up the data model easier compared to OBIEE (notwithstanding the need to rename columns to make and break associations) “
And:
“Where QlikView is weaker in my view, compared to any of the Essbase-backed query tools, is around number-intensive and hierarchy-intensive applications. It’s not easy to select dimension members via a hierarchy, the scripting and calculation language that comes with the tool obviously doesn’t support the richness of languages like MDX and Essbase calculations scripts, and of course there are not the applications such as Planning and Financial Management that you’d expect to make use of in the Finance Department. “
I think it is a fair review of the product. And nice to see that an authority on Oracle BI is relatively possitive on Qlikview. You can read it here: A Quick look at Qlikview
Stu said,
I’m having a problem executing a stored proc that returns a result set, from a temp table it creates. The sproc works fine in SQL Server, but fails on ODBC connection, on exec in Qlikview. I added ‘mode is write’ to my ODBC CONNECT, and clicked the Setting radio button ‘Open Database in Read and Write mode’.
Any ideas how I can get this result set back to Qlikview? ALl other stored procs work fine in the tool.
Add A Comment