Virtual Info Providers via Direct Acess DTP

[former_member189845]

Hi All,

I'm trying bit to understand  the features of SAP BW7.3 on HANA and how possible we can make use of 7.3 objects .

on Weekly users will upload some four flat files in application server ( al11 ) and from AL11 our process chains picks and load it to DSO and info cube. But every time is an drop and reloads data.

So, Is it possible that we can achieve this type of scenario through VPs via direct access DTP ?

If yes, I can handle some business logic in VPs transformation level  ? also I need to change the all info objects type as master data access as remote ? and if it so how about the attributes for that object.

And how do i do reporting on VPs ?

Please suggest and I have read all the document related to VPs via direct access,

Thanks,

Siva

[Former Member]

So, Is it possible that we can achieve this type of scenario through VPs via direct access DTP ?

Yes- Create datasources -> extraction tab ->direct - allowed and adapter as load file from application server and choose al11 files. If file name is changing then, use abap to define logic of filename.

Then create VP with direct access dtp and trfn.

If yes, I can handle some business logic in VPs transformation level  ? yes between DS-VP

also I need to change the all info objects type as master data access as remote ? and if it so how about the attributes for that object.  -> no required.

And how do i do reporting on VPs ? Normal Bex queries( make sure you activate direct access before display or running report )

Regards,

Sandeep