[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Lazy loading of related parameters  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
samueleorso.spw

Newby

Joined: 08/07/2010 18:07:07
Messages: 11
Offline

Hi all,
I have a document (jasper report) with 3 parameters, where the last one is related to the previous ones. e.g.
parameter1= DATE (input type string)
parameter2= PROJECT (LOV with PROJECT_ID)
parameter3= ISSUE (LOV with ISSUE_ID,PROJECT_ID,DATE)
parameter3 relations: DATE=ISSUE.DATE AND PROJECT.PROJECT_ID = ISSUE.PROJECT_ID

When I start the execution of this document, a lot of time is spent on "Loading Parameters..." phase because, I suppose, the query for ISSUE's LOV is very low (milions of rows inside database table).
Is it possible for related parameters to simulate a lazy loading and execute the LOV query only after father parameters have been selected, and using directly the where conditions in order to reduce the query cost?

In my opinion, the behavior should be:
- father or standalone parameters loading (LOV query execution) on document execution (in my case DATE and PROJECT)
- child parameters not loaded at document execution but only after father parameters have been selected and using directly where conditions (in my case: select * from issue where date = xxx and project_id = yyy)
This should avoid the loading of useless data from db in order to apply after the where conditions.

Any idea about how to do it?

Thanks a lot..


d.synchronized@gmail.com.spw

SpagoBI supporter

Joined: 14/12/2012 05:15:51
Messages: 140
Offline

why dont you try the correlation of the drivers ,so that once you select the father ,the parameters in son are loaded corresponding to the father

regards
dishant
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team