topic Re: Data Model Question in QlikView

Data Model Question

vikasmahajan — Thu, 09 May 2013 11:36:54 GMT

Dear All,

Suddenly I want to add new field Base Division inthis data model I have brig BASE_DIV in all transaction but how to accomplish in data model without making lot of chages in data model.

Thanks.

Vikas

Re: Data Model Question

Thu, 09 May 2013 11:57:41 GMT

good luck

Re: Data Model Question

vikasmahajan — Fri, 10 May 2013 04:17:12 GMT

Thanks any idea how to acheive the same ?

Re: Data Model Question

Fri, 10 May 2013 04:41:18 GMT

Can u explain more ?

u already have BASE_DIV, where do u want to add ?

what do u mean by brig BASE_DIV ?

i thing i can see is that u also need to remove the circular loops in ur model

Regards

Re: Data Model Question

vikasmahajan — Fri, 10 May 2013 04:47:39 GMT

Thanks for Reply , There is a confusion it solved with no changes in data model.

Re: Data Model Question

Vidit — Mon, 13 May 2013 09:53:54 GMT

Hi Vikas,

first of all you need to check the usage of that column that you want to add.

1)If its just a measure i.e. some data you want to display or use, than simply add it to any of your fact tables where it is most relevant. and no change in data model is required.

2) ifs its a column thats important from data reterival point of view and on who's basis you want to join your several tables, than you need to add it in all your tables and that will require change in data model.

Leo

Re: Data Model Question

vikasmahajan — Mon, 13 May 2013 12:44:15 GMT

Thanks for your reply , This is resolved actually. But good if suddenly We have got this type of requirement then

we have think.

Vikas