Skip to Content
0
Former Member
Sep 10, 2007 at 02:17 PM

Oracle Query as Extractor

15 Views

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,