Multiple Dimensions is QlikView Data Model using one source table

[#1]

Hi Experts,

We have one source table and have to design multiple dim tables in QlikView Data Model using the same Source table.

I thought of to load the source table into one QVD at first level and in the second level select the same fields for multiple dim tables using alias. Concern is data will be stored multiple times.

Any thoughts from experts to achieve this in an optimized way.

Thanks in advance.

Regards,

Manjula.B

[Anonymous]

QlikView only stores unique values of fields, so storage of duplicate values is not a concern.

A valid way of loading in your data would be into one big Fact table with all the dimensions within it.

Jonathan

[#3]

Thanks Jonathan for your reply.

When I make alias names it will store as different columns right and data will be stored column wise right.

Please comment.

Reagrds,

Manjula.B

[Anonymous]

Yes, if you rename a field using the AS command, then it will store a duplicate of that dimenions values. For example, you might store multiple types of months and year combination to server different purposes. These can be thought of as being aditional columns of the same table if seen in a spreadsheet-type layout. There are often not enough dimenison values for such duplication to be a problem though.

Jonathan