topic Re: Suggest Best Data Modeling in this situation?? in QlikView

Suggest Best Data Modeling in this situation??

Thu, 24 Jul 2014 05:02:06 GMT

Hi All,

I have four tables

1.Material Base (like master)it contains "plant&material". it doesn't contain year and month.

2.Mard

3.Mssl

4.ZZMM

rest of the three contains plant,material,year&month.

In the front end we need to use plant,material from "Material Base" only and common year and month for all tables.

we need to show mard-stock separately,Mssl-Stock separately and ZZMM-Stock separately for plant and material wise which is coming from Material Base table.

What i did : created hard coded master calender and outer join with Material Base table after that i given link to all other tables with "Plant&Material&year&Month". But i think this is not accurate because with out any reference i joined calender and Material base table.

so suggest me any good way.

Thanks in advance,

Ashok.

Re: Suggest Best Data Modeling in this situation??

umerikhlas — Thu, 24 Jul 2014 06:43:19 GMT

Can you add more details about your tables? fields for every table separately. so that it could be more easy to understand your need.

Re: Suggest Best Data Modeling in this situation??

Thu, 24 Jul 2014 07:10:31 GMT

If possible can u share the table view of your data that will be more easy to understand and help you.

Re: Suggest Best Data Modeling in this situation??

avinashelite — Thu, 24 Jul 2014 07:15:17 GMT

Hi Ashok,

Please share sample data, so that it will helpful for to suggest.

Regards,

@vi

Re: Suggest Best Data Modeling in this situation??

Thu, 24 Jul 2014 07:35:24 GMT

Material Base-Table

Plant , Materialgroup , Material

MARD-Table

Plant ,Materialgroup, Material, Year, Month , Stock

MSSL-Table

Plant ,Materialgroup ,Material, Year, Month, Stock

ZZMM-Table

Plant , Materialgroup , Material ,Year , Month , Stock