Data Modelling

[deepakqlikview_123]

Hello All,

Please find attached data model from etl side.

"I have four fact tables

1  Row_indicator_by_country_F

2  Row_indicator_by_Location_F

3  Row_indicator_by_Region_F

4  Row_indicator_by_Sector_F

Can you please suggest how shall i go ahead for performing data modelling in qlikview.

Thanks

[deepakqlikview_123]

Hello All,

Is it need to keep calendar separate if so can you please suggest in which scenario's we need to keep calendar separate and in which scenario there is no need to do so.

Thanks

[jagan]

Hi Deepak,

It is not mandatory to keep the Calendar as a separate table.  Suppose for example if your data is not having transactions for some dates assume that Mar month do not have transactions, but if you want to show the March month in the Month field then you need to go for Master Calendar as a separate table.  In Master Calendar you have all the dates from Start to End date even if you have transactions or not.

Hope this helps you.

Regards,

Jagan.

[deepakqlikview_123]

thanks jagan for valuable input.