Hi friends,
I'm new in BI. I have next query to get Inventory values by material code, and I want to use it as 'Data Source' to fill an ODS InfoProvider.
select lfgja||lfmon, werks, matnr, sum(labst)
from sapr3.mard@dwh_sap.world
where substr(werks,3,2) in ('76','77','65')
and lfgja = 2007
and labst != 0
group by lfgja, lfmon, werks, matnr
As you can see, the query is built using Oracle, against MARD table. I try to avoid create a table in an Oracle Database with the contents of the query and to use a DB Connect against Oracle. My goal is to use the query as definition of the DataSource ... Is this possible ?
Best Regards,