topic Re: Multiple Dimensions is QlikView Data Model using one source table in QlikView

Multiple Dimensions is QlikView Data Model using one source table

Mon, 24 Jun 2013 07:41:29 GMT

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

Re: Multiple Dimensions is QlikView Data Model using one source table

Anonymous — Mon, 24 Jun 2013 07:57:12 GMT

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

Re: Multiple Dimensions is QlikView Data Model using one source table

Mon, 24 Jun 2013 07:59:56 GMT

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

Re: Multiple Dimensions is QlikView Data Model using one source table

Anonymous — Mon, 24 Jun 2013 08:28:34 GMT

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