topic Re: BI lifecycle flow within tool in QlikView

BI lifecycle flow within tool

Mon, 25 Feb 2013 08:26:08 GMT

Hello Friends

This Tool is new for me and started learning the same.Installed the free version and able to do the conection from oracle/sqlserver database.

Can anybody help me to understand how the BI lifecycle flow within Qlickview tool.

As i have read their are server/Desktop/report designer etc

For Example:

In sqlserver we have database we use MSBI for BI lifecycle

like SSIS for making transformations

SSA for cubes

and SSRS to make reports

In this case ....How this Qlikview work like MSBI?

vikasmahajan — Tue, 20 Aug 2013 04:28:23 GMT

Hii ,

- Create Local database in SQL (Qlikview Server)

- Create Scripts for pulling data from software where you want to fetch records.

- Schedule Jobs for duration of 30 mins or 1 hrs (This will update data from source & destination)

- After this create temp views and temp tables to load data into qvw.

- Create QVD

- Load QVD in Qlikview

- Schedule QVW file in QMC for refreshing data.

Hope this helps you.

Vikas