topic Re: Combine 4 datamodel in QlikView

Combine 4 datamodel

Thu, 04 Dec 2014 05:37:33 GMT

how to combine 4 different data model(finance ,sales,operation ) into one single qvw .

I have to create a qvw for the CEO of the company ,which include the information from 4 different dashboard

Re: Combine 4 datamodel

its_anandrjs — Thu, 04 Dec 2014 05:42:23 GMT

Hi,

You can load all the models in single QVW.

1. Use section access for this.

2. Create Inline table to give selection for the different model in front end to end users.

Regards

Anand

Re: Combine 4 datamodel

SunilChauhan — Thu, 04 Dec 2014 05:45:53 GMT

do binanry load . create linke document chaining

finance->Sales

sales->Opertation and operation into finanal app. it will be more easier to comine all data and only thing you need to take care of synthetic keys

Re: Combine 4 datamodel

Thu, 04 Dec 2014 05:51:48 GMT

CEO don't want to click on any button .They don't want Document chaining ,they want to see the entire data in one shot or say one page

Re: Combine 4 datamodel

vardhancse — Thu, 04 Dec 2014 05:57:34 GMT

Hi,

If we combine 4 different data models also,we should think about Section access.

1. is the section access is same across all the dashboard.

2. if not then we can not merge all 3 dashboards

Re: Combine 4 datamodel

its_anandrjs — Thu, 04 Dec 2014 05:59:06 GMT

It seems KPI dashboard for over all applications for this in single QVW you can load all the Qvd from different app and finally create application means. You have different models in the single Qvw like sales, finance etc but here strongly check for same field names because it generate the synthetic table so do not ignore this and then create different field name.

If you have existing applications then load this app into single Qvw by binary nut better way is to load the Qvd of the application.

Regards

Anand

Re: Combine 4 datamodel

Thu, 04 Dec 2014 06:02:46 GMT

Is there is any other way instead of creating a data model,as they use different data source for different dashboard like

sap,oracle,excel

I have to deliver it within 7 days

Re: Combine 4 datamodel

vardhancse — Thu, 04 Dec 2014 06:05:13 GMT

instead of connecting directly to different sources, its better to work on QVD's as @anand mentioned

Re: Combine 4 datamodel

its_anandrjs — Thu, 04 Dec 2014 06:08:12 GMT

Hi,

Another way is load only those Qvd, source (Sap, oracle,excel) which is used to create this dashboard and then create this dashboard for CEO. Also if you have already raw sources then use this here and create the dashboard on the basis of this source files it is easy and fast way to develop a dashboard.

Hope this helps

Regards

Anand

Re: Combine 4 datamodel

Thu, 04 Dec 2014 06:09:35 GMT

Hi,

Could u please tell me in each and every data model how many tables ur using and what is ur data model...

and what architecture u guys ll follow .........

Re: Combine 4 datamodel

vikasmahajan — Thu, 04 Dec 2014 06:09:53 GMT

Hii,

You can use Binary Load and combine all data models in 1 qvw.

Try.

Vikas

Re: Combine 4 datamodel

rajeshvaswani77 — Thu, 04 Dec 2014 06:25:04 GMT

Use binary load, also analyse the model to see how you can relate these, using a common field.

thanks,

Rajesh Vaswani

Re: Combine 4 datamodel

Thu, 04 Dec 2014 06:40:39 GMT

finance-7 table,operation -24 aer0-24

Re: Combine 4 datamodel

SunilChauhan — Thu, 04 Dec 2014 07:11:02 GMT

ya i understartand but after combining data only you could see data @ one page

by doing document chaining in final app you will have all data

finally your choice we could do below ways also

1) create qvd for data from each application and then reload into Qvw

2) export data to excel/csv and load excel csv to qvw. but in this maethod you need to automate export to excel.

Re: Combine 4 datamodel

Thu, 04 Dec 2014 07:15:33 GMT

hi Shweta,

Please try to understand .. for each and every data model how many tables ... those tables are common in other data models ..... ?

Re: Combine 4 datamodel

SunilChauhan — Thu, 04 Dec 2014 07:28:59 GMT

simply i can say only important part say KPI

then you could store that part into qvd and create a model on new app a

hope this helps

Re: Combine 4 datamodel

Thu, 04 Dec 2014 09:59:05 GMT

how i can store a part of KPI into qvd

Re: Combine 4 datamodel

vinay_hg — Thu, 04 Dec 2014 10:18:03 GMT

see first u need to identify the common or a key between ur finance, operation and others there will be a linking field. or if u con=mbine more than one field from the each data model groups (finance , operations ,etc) u can join and create the 1 model.. that u have understand the business need of CEO and based on the same u need to join. once this is done then u can design 1 page dashboard for the same.

even i have done the same in CEO dashboard in my company for

finance, sales,operations,colletions,HR,

note: definatly between data there will be a business link. identify the same and proceed. this is the only way.

Re: Combine 4 datamodel

SunilChauhan — Thu, 04 Dec 2014 11:06:15 GMT

few fields of table into qvd

for example For finance : Booksize,Debtor and Business we need to store and we have this in finance table

then

NewKPI:

Load

Booksize,Debtor ,

Business

Resident Finance:

store NewKPI into path\NewKPI.qvd;

drop table NewKPI;

it will not effect you current application also