Can we pass values/Results from multiple Qvws to single Qvw file...?

[Anonymous]

Hi Experts ,

I Have a different requirement in My project , we have to develop 10 Qvw files individually , in each Qvw file we are showing success rate in a Text Object..

here my requirement is I want to use the success rate of all the 10 Qvws file in Final Qvw file and I have to calculate the average of  all success rates in that final Qvw application...

I feel like this is very Interesting and Challenging too...

My friend suggested that I can use N Printing for this , but am new to this I don't know how to use N Printing to achieve this..

please guide on approach and let  me know if you have any other alternate ideas to get this...

thanks in advance...

Best Regards

Anusha..

[jonathandienst]

You can binary load from a single qvw file. If you need data from several, then have each source qvw drop a qvd file for each table that is needed by the target. the target qvw can then load all the qvds and perform any further calculations.

[Kushal_Chawda]

Store the Calculation of each QVW in QVD. So you will have 10 QVDs for this.

Now load this 10 QVDs in final application and do the Avg

[Anonymous]

Hi Jonathan,

thanks for your response.

looks like your method may be going to work, but can please  elaborate more by step wise , so that I will start implementing on my Application.

regards

Anusha

[Anonymous]

Hi Kush141087,

thanks for your response..

Can you please explain little bit more on the steps to follow...

regards

anusha

[Anonymous]

Hi,

If all the existing apps are based on the same model, but different UI, reuse this model and copy all the charts  to the new qvw.

If they are  using different data model, you first need to build a data model that will cater for all your Business requirements.

[Anonymous]

Use Binary Load

[#8]

Create 10 qvd File and load all qvds in 1 qvw file and load  success rate column different name as sucessrate1 using resident load like this do for rest of the qvd later use expression like this load toatl = sucessrate1 +  etc / 10

[Kushal_Chawda]

Application 1

Load scripts;

//Here do your calculation

Calculation1:

load *,

sum(Value)

.

.

Resident Data;

Store Calculation1 into Calculation1.qvd;

like wise for all 10 application create the QVDs

Now in final application load all 10 qvds

load *

from Calculation*.qvd

[Anonymous]

thanks Kush141087 for your brief Explanation,

According to your Explanation I have to store each and every Qvw final result in a Qvd , in the last Qvw file I have to load all these Qvd's Right....? okay this is superb

but am using set Expression to get the Final success rate in my Application 1...and in remaining Qvw applications also I have to use same type of Set Expressions, and I don't think that set Expression is going to work in Script level...

how to overcome this , Whether I need to get the same functionality without Set expression or any other Alternate methods are their for this...

let me know the best possible solutions for this...

Thanks in Advance..

Anusha..