Home Forums SQL Server 2005 Business Intelligence Requesting Suggestions for Affordable Reporting, Analysis Services SSRS or Qlikview RE: Requesting Suggestions for Affordable Reporting, Analysis Services SSRS or Qlikview

  • Well good for you that you have access to both SSAS and Qlikview, Being a Data Warehouse Lead Developer i could great a great set of reporting and analytic applications with those.

    Anyway comming back to to your Question.

    There are more intricate differences when you ask the difference between those two.

    SSAS You have more no of people who are aware of Sql Server T Sql

    Qlikview You might have to bear training costs for training your staff to learn AQL QlikView proprietary language similar to SQL.

    SSAS It uses Cubes i.e. data is aggregated by using a set of pre defined dimensions, based on the client requirements.

    Works best for smaller data sets.

    Lots of Support Available.

    Cost wise it depends on what your trying to accomplish because when i checked there was

    Sql Server Enterprise Edition Standard License vs Sql Server Enterprise Edition Premium License not really sure but cost wise Standard License was better as it was giving the option for Client License i.e. your client will be paying the bill and you dont need to worry about the licenses.

    Disadv

    Cube creation is quite complex especially on large data sets.

    If you need to perform any modifications in future, then Cube refresh takes some time.

    Difficult to query dimensions with high cardinality.

    Qlikview i dont really have a clue about their licenses but their pricing was little steep for a new product which they claim is cheaper. I have past data but the Qlikview Server costs 21K$, Publisher 12K$ something not sure, i am not a representative.

    Qliview

    Runs Sql Queries which store data in intermediate tables called aggregation tables(microstrategy not sure if qlikview does the same)

    In memory analysis which allows you to analyze data as its stored on RAM.

    Lots of hardware RAM required depending on the size of data your trying to analyze, as all the data is stored onto RAM.

    Works better on Large Data Sets.

    Dis

    Unsure if Qlikview follows ROLAP, if it does Not suitable for complicated financial calculations, i mean complicated not simple, it will work great if your trying to process your account or billing information but for stuff like trading, budget it might not.

    You could get a demonstration from the SSAS, Qlikview consultants themselves and evaluate as to which is better i.e. which of those meets your budget allocation, requirements, technical aspects.

    Let me know which you choose and why.

    Regards.