topic Using QVD files in QlikView

Using QVD files

Tue, 22 Mar 2011 15:45:46 GMT

Hi.

I want to read dimension and fact tables from a dwh. I want to save dimension tables in an unique QVD file. I have tried to do it by using STORE statement, but when I select the QVD from a new QVW I can see only the last table stored in the QVD file.

Well, isn't possible to save more tables in the same QVD file?

Thanks

AW:Using QVD files

brenner_martina — Tue, 22 Mar 2011 15:48:02 GMT

Hi,

no, one table = one QVD, but you can create a table by concatenate, so you can get all your dimensions together in one table!

AW:Using QVD files

Tue, 22 Mar 2011 15:58:32 GMT

What a pity!

In this case, it is preferrable to create one QVD for one dimension.

However, have you an example to concatenate more dimension tables read from a SQL Server dwh? F.e. having Customers, Vendors and Time as dimension tables?

Thanks

AW:Re: AW:Using QVD files

brenner_martina — Tue, 22 Mar 2011 16:06:01 GMT

Hi,

in QV it is very easy, load at first all your tables from DWH, than load a new table p.e.

Dimensions:
Load Dim1, Dim2, Dim3,... Resident Table1;
Concatenate (Dimensions)
Load Dim21, Dim22, Dim23,... Resident Table2;

and so on

Store Dimensions Into $(Path)\Dimensions.qvd;

AW:Re: AW:Using QVD files

Tue, 22 Mar 2011 16:17:15 GMT

Hi Martina, I'm perplexed.

Dim1 is a (dimension) table, Dim2 is a (dimension) table, Dim3 is a (dimension) table , ... and Table1?

After the second LOAD does it take Concatenate(Dimensions)?