DTP using BW Query as Datasource

[mrj_marcelo]

Hi, I need to use a Query as a data source for a ADSO, but the query has input filters, so how can I use it as a data source to a ADSO, I have rebult the same query, without the input filters, it works file, but when I use that in DTP as a datasource, it throws TSV_TNEW_PAGE_ALLOC_FAILED error during extraction sometimes, I belive because the high quantity of records returned. So what is the best way to use query as a ADSO data source in bw and avoid the TSV_TNEW_PAGE_ALLOC_FAILED error? If I filter the extraction in DTP, does it helps the query? I am using a query as datasource, because it has a lot of complex calculations.

Thanks and best regards.

[Abhishek_Hazra]

Have you tried applying same input filters in the DTP while extracting? That should be the most optimal approach.

Regards,
Abhi

[ferdtulu · Accepted solution]

set a fixed filter (not variable) on the query in the filter area (filter: fixed values) and then try again.

[mrj_marcelo · Accepted solution]

Yeah, it works, but I want to pass a filter dinamically to query filling the filter in process chain. Can I do that?

Thanks.