How to Combine multiple QVWs into a single QVW?

[dmohanty]

Hi All,

Incase I have 2 QVWs (let 2 as of now) with data for two different Regions, Suppose for 1st QVW, Region = IND and for 2nd QVW, Region = USA. Both the QVWs have same data model script and same GUI. Only data is different.

Now I want to combine these QVWs into a single QVW, so that in the new QVW I can have a single List Box as Region which would show a list of regions and also the same GUI as like individial QVWs. If I would select IND, the QVW should show data for IND and if I select USA, QVW should show data for USA. I can select multiple Regions as well.

Similarly I have 11 QVWs. Now I need to know the approach on how to combine into a single one? Please help in providing the steps and approach.

Regards.

[rajni_batra]

You can create 1QVW with all 11 transaction tables from QVWs concatenated in one in dtaa model and then use same GUI.

[dmohanty]

Hi Kaushik/Mohit,

Thanks for a feasible solution.

In all my QVWs, the data model script and all the table structure are same. So when I do a Binary Load as suggested, will it not form Synthetic keys?

As I am facing the same problem. Will the Binary approach work if all the QVWs have the exact same script?

Regards.

[luciancotea]

OK, you have one QVW developed for a single region. But you have in fact 11 Regions. Right?

The result should be all regions data in one QVW and one more field in the interface: Region.

If that's the case, you need to add the Region dimension in one of the tables (where it makes most sense) and make sure that all your keys (links between the tables) contains the "Region" info: LOAD autonumber(OLD_ID, Region) as ID;

So, when you select one Region, the section will propagate through all the tables in your schema.

[#5]

can u try this?

below script is used to load the qvd files from different folder.

Set vConcatenate = ;
sub ScanFolder(Root)
          for each FileExtension in 'qvd'
                    for each FoundFile in filelist( Root & '\*.' & FileExtension)
                         if(wildmatch(FoundFile,'Invoice_tab*'))
                              FileList:
                              $(vConcatenate)
                              LOAD *, '$(FoundFile)' as SourceFile
                              FROM [$(FoundFile)] (qvd);
                              Set vConcatenate = Concatenate;
                         end if
                    next FoundFile
          next FileExtension
          for each SubDirectory in dirlist( Root & '\*' )
                    call ScanFolder(SubDirectory)
          next SubDirectory
end sub
Call ScanFolder('D:\qvd\Region') ;

Like that u can add the all the qvd in to one qvw file, so that all region comes under one qvw file.

Regards,

Kabilan K.