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

[its_anandrjs]

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

[SunilChauhan]

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

[#4]

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

[vardhancse]

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

[its_anandrjs]

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

[#7]

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

[vardhancse]

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

[its_anandrjs · Accepted solution]

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

[#10]

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 .........