topic Partitioning BIG Fact QVD file into multiple QVD Files? in QlikView

Partitioning BIG Fact QVD file into multiple QVD Files?

Mon, 16 Mar 2015 04:16:44 GMT

Hi Members,

I have more than 600 million records in one of my fact tables and this table holds exactly 2 years of data in my DWH which is having daily partition in SQL Server DWH DB. So In SQL Server DB, I have total 730 partitions for this fact table.

Question arises, is that possible to partition QVD file? If yes I would like to partition my fact QVD into 8 quarters (2 years of data) so that we should not face any performance issue. Maximum users browse recent 3, 6 months data but few users go for 1 year or 2 years data.

2nd query, What would be the script in dashboard which should dynamically point to right partition based on user selection.

If anyone has done any such implementation please provide steps and script if any.

Message was edited by: Shivendoo Kumar

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

rwunderlich — Mon, 16 Mar 2015 05:37:11 GMT

Take a look at QlikView Components http://qlikviewcomponents.org to segment your QVDs. Specifically, the routine

Qvc.SegmentedStore

If the correct segmentation is not available for you or you need help on syntax ask for help on the QVC User Forum at

Google Groups

-Rob

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

Tue, 17 Mar 2015 01:30:35 GMT

Hi Rob,

I have gone through the link you have provided. Before looking into code, I need to know the basic of QVD segmentation.

Could you please explain it in words?

My Architecture is DWH (SQL Server Sources)-->QVDs--->Dashboards

I was thinking that we should partition the QVD in 8 physical QVDs files like SALES_Q1 to SALES_Q8 and all will have 3 months of data.

Is this possible of not? If yes then can you explain me how can I see the data just for Q1 in Dashboard and What script developer should write?

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

jagan — Tue, 17 Mar 2015 03:51:38 GMT

Hi,

Check this link

http://community.qlik.com/message/556995#556995

Regards,

Jagan.