topic Can we load a Database View into qlikview then what about Incremental load in QlikView

Can we load a Database View into qlikview then what about Incremental load

kkkumar82 — Thu, 21 Apr 2016 06:26:36 GMT

Morning all,

I have a issue here, I want to load data from a database view (ebs) due to multiple joins it has which I tried in Qlikview to do but couldn't do it. So finally decided to load to the view as it because in the front end I have only one straight table (report) to be created.

What pinching me is , in the view there are nearly 15 tables with multiple joins, my concern is how to perform incremental load on this view.

Hope I am not confusing you guys.

Kiran Kumar

Re: Can we load a Database View into qlikview then what about Incremental load

Gysbert_Wassenaar — Thu, 21 Apr 2016 06:33:56 GMT

As far as Qlikview is concerned the data in your view is just another table. If that view / table has a primary key that uniquely identifies an entity (an ordernumber of an order for example) and a modification field like a modification date or revision number then you can do incremental loading.

Re: Can we load a Database View into qlikview then what about Incremental load

kkkumar82 — Thu, 21 Apr 2016 06:51:32 GMT

As far I know I am new this data source which Oracle EBS and the final select statement after executing all the joins is this

SELECT the_table.so_yr_qty,

the_table.mo_yr_qty,

the_table.org,

the_table.item_number,

the_table.description,

the_table.product_line,

the_table.item_type,

the_table.COST,

the_table.usage_past_yr,

the_table.usage_past_qtr,

the_table.usage_current_month,

the_table.avg_monthly_usage_qtr,

the_table.avg_monthly_usage_yr,

the_table.avg_monthly_usage_yr_dol,

the_table.avg_forecast_out_6_mos,

the_table.avg_forecast_out_6_mos_dol,

the_table.fs_spares_qoh,

the_table.fs_spares_qoh_dol,

the_table.net_qoh,

the_table.forecast_balance_mos,

the_table.this_mos,

the_table.month2,

the_table.month3,

the_table.month4,

the_table.month5,

the_table.month6,

the_table.month7,

the_table.forecast_designator,

the_table.make_buy,

the_table.lead_time,

the_table.full_lead_time

...

....

...

I think I have to find the unique columns and also the modification columns in the above

Re: Can we load a Database View into qlikview then what about Incremental load

Gysbert_Wassenaar — Thu, 21 Apr 2016 10:40:07 GMT

That looks like data that's already aggregated at a point of time. You probably do not want to do incremental loading with that kind of data. At best you could use then month-year field for incremental loading to load each month only the data for that month.

Re: Can we load a Database View into qlikview then what about Incremental load

kkkumar82 — Thu, 21 Apr 2016 11:16:16 GMT

Hi Gusbert,

The problem here is we are taking the OLTP data model and making it OLAP because we are not using any ETL in between the ebs and Qlik.

PFA the original view just for reference.

Can you throw some light on it and more over we don't have any transformation layer in between the qvds, as of now we have all qvds individually , I proposed joining of some the qvds for speeding up things.

Re: Can we load a Database View into qlikview then what about Incremental load

kkkumar82 — Thu, 21 Apr 2016 11:18:24 GMT

PFA view which we are trying to use to get the final select statement into Qlik.

Do you think this will take enough time to do in Qlik or any suggestions would be great.