Use TWO data provider in a custom Excell BEX template

[former_member489165]

Hi gurus,

We are using a custom Excell template (copy of SAP default template and adapted to my company with logos, styles and custom macros VBA)

We've added a new sheet on this template, adding there a new grid panel (GRID_2) and we assigned in its properties a DATA_PROVIDER_2 with a query that we want to use, where its result will be used by our custom macros.

The idea is, when we execute any query in excell, the BEX analyzer will use this custom template and will show in the "Table" sheet the query you want to execute (it uses the GRID_1 and the DATA_PROVIDER_1) and in the new sheet the should be shown the result of the query fixed in the DATA_PROVIDER_2.

The issue is, when we execute a query, it query is used by both data providers and the query fixed, as default in the custom template, is missed.

Any one knows how to assing a fixed query to the DATA_PROVIDER_2? Maybe using VBA?

Thanks in advance.

Carlos

[mgubco]

Hi Carlos,

I'm facing the same problem. Did you find any solution?

Thanks,

Marek