Using QVD files

[#1]

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

[brenner_martina]

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!

[#3]

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

[brenner_martina]

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;

[#5]

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)?