want to improve QV performance by using expressions on loader

[#1]

Hi ,

I have serveral expression in publish where its time in calculation and reloading again when I switch from one tab to another tab.

I want to use these expressions on loader side so I can create new table and load result of expression into it and refer new table on publish to show result.

To handle this requirment , I need to use resident load process where want to use different values from different table and load in new table.

e.g

expression:-

=sum(

{<student.admission_date = '01-Jun-2014'>}

if(

aggr(
(count({<student.class = 'B',student.type = 'A'>}student.number)

+

count({<student.class = 'B',student.type = 'A',teacher.name = 'SSM'>}student.number)) > 0,1,0)))

I want this load this calculation while loading in new table using values from two different table.

Please suggest me if is there any another option to handle it,

thxn lot

[Gysbert_Wassenaar]

I want this load this calculation while loading in new table using values from two different table

Then you first need to join one of the two tables to the other (or create a new table where you join the two). Then you need to summarize that table to get the counts.

Btw, the aggr function you posted above seems to be missing the dimensions it should be applied over. I don't see how that expression can work as you posted it.

[#3]

Thnx for your reply Gysbert,

Because of some corporate security  I am not able to post exact code but here I am having same functionality in actual code where used aggregate function and used another table in expression while calculation in expression.

I need to add this whole functionality while loading data in new table , I tried to use resident load process in new table where I am not able to join the two or more tables in resident load process.

Is there any other way to join two or more tables while loading data in new table ?

[Gysbert_Wassenaar]

First create one table then join the other to it. There's no other way. Well, if the source data comes from the same SQL database then you could write an sql statement that executes the join on the database server.