Combine 4 datamodel

[#1]

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

[vikasmahajan]

Hii,

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

Try.

Vikas

[rajeshvaswani77]

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

thanks,

Rajesh Vaswani

[#4]

finance-7 table,operation -24 aer0-24

[SunilChauhan]

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.

[#6]

hi Shweta,

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

[SunilChauhan]

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

[#8]

how i can store a part of KPI into qvd

[vinay_hg]

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.

[SunilChauhan]

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