Friday 18 July 2014

Diffrence between Qlikviews and Business Objects(BO)?

Qlikviews Business Objects(BO)

Qlik View         BO
1. Qlik View has strong community                     1. Has poor Support
support and generally has vendor
   support
2. Does not require data warehouse,                  2. Requires Data Warehouse and a full
    time to go- line trends to be much                       scale long term project
   shorter than BO(QV claims ¼ of the
    time)
3. Has a pack  and go solution of for    3. Has no pack and go solution and very
    offline work and supports smart                          partial smart phone support(only for                      
    phones, iphones, ipads                                          web reporting tool)
4. Has both a web-only(AJAX) and                        4. Uses web browser as its only client
client application, the later tending                      application
    to provide significantly better
    performance

Schedule the report daily, monthly, weekly and involved in the BO report level testing?

Schedule the report daily, monthly, weekly and involved  in the BO report level testing                                                                                        
BO
a)Universe connection with Data Source
b)importing data from data source(tables)
c)create joins & contents
d) create hierarchies(year,month,quarter)
e) create more new objects, resolve the loops & same the universe in UNV format
f) check integrity and export to the repository
g)we can apply filters at universe level
Repository Domains:
1. Universe Domain
2.Document Domain
3. Security Domain
By the queries we will get data we will import data into designer
save the document and export to repository

Thursday 17 July 2014

Performance tuning in Qlik View?

Performance tuning in Qlik View:

Number of rows & columns:  we should be selective about what fields are to be included in the qlikview document and eliminate those fields which are currently not in used. We can load five years of data in QV instead of loading 10 years of data.

Number of Distinct Values: Fields with distinct values use the most space. Using count(distinct) forces QV to switch from using multicore to use only one core. Time stamps with mins or seconds can be truncated to store only date thus reducing the processing time.

Data Model: Qlik View can analyze multiple data sources but works most efficiently with Star Schema or Snow flake Schema, The Star Schema Consists of few fact tables possibly only one ,referencing any no. of dimension tables

User Interfaces:  Resource intensive expression like count(distinct) if() should be avoided. Set analysis should be used instead. Complex script should be done in script
rather than in charts/tables. Macros should be replaced by built in QV functions. Expressions which are used frequently in more than one chart/table should be stored in a variable which reduces the calculation time. Minimize the chart objects which are less important as chart expressions in minimized objects are not calculated.

What are the New Features in Qlikview Server?

New Features in Qlikview Server:
i) Content Sensitive Help
ii) Configurable LDAP
iii)audit logging by document
iv) Enable/Disable document download exporting and printing document and user
v) supporting task for QVD creation
vi) Distribution to Email with in a QVW document
vii) Alert Email to Document Administrators
Viii) License tracking
ix) Distribution and Reload Performance
x) Loop and Reduce
xi)Qlikview Management Console(QMC) user interface
xii) Reduction with log files
Xiii) Improved logging
xiv) QMC and QEMC are QMC
xv) Access point remake
xvi) Load Balancing Improved

What are the new features in QV 11?

a) Container Object- Grid Style
b)Granular Chart – Dimension Control
c)Actions like, clear filed, reset button
d)conditional enabling of dimensions and expressions
d)meta data
e)comparative analysis(multiple state selections)

What is Relative Path?

Relative Path: If we select Relative path, then we the work path is defined by directory statement. If it is not selected, the path of the QVW defines work directory. The work directory can be found in the system variable QVWORKROOT which should not be changed manually.

What is the difference between Straight Table and Pivot Table?

Difference between Straight Table and Pivot Table:
Pivot                                      Straight
1) Multi-dimensional with one or more        1) one dimension with multiple
 Measurements                          measurements
2) Displays Sub Totals                       2) do not display sub totals
3) Pivot table will show cross table              3) can’t show cross table