topic Re: How to access multi-provider object from SAP BW in SAS Data Management

How to access multi-provider object from SAP BW

anilawate — Wed, 07 Aug 2019 06:45:45 GMT

Hi,

We are using SAP/Access Interface to R/3 which is configured to access objects from SAP BW. But we are unable to register the multi-provider objects from SAP BW using R/3.

My query is, can we access multi-provider objects from SAP BW using R/3 ? If not How to access this objects.

Thanks.

Re: How to access multi-provider object from SAP BW

JBailey — Wed, 14 Aug 2019 16:56:26 GMT

Hi @anilawate

SAS/ACCESS Interface to R/3 does not support Multi-Providers. It may be possible to query the individual components separately; I don't know. An alternative is to use BAPI to extract the data from the MultiProviders; this would require custom development on the SAP side.

UPDATE: A friend told me that it may be possible to create a view on the Multi-Provider and read it with SAS/ACCESS Interface to R/3, SAS Data Surveyor to SAP, and SAS/ACCESS Interface to SAP HANA

UPDATE UPDATE: It turns out that the user must extract all the basic components from the multiprovider and rebuild it in SAS. @LouGalway_sas is the man on SAP!

Best wishes,
Jeff

Re: How to access multi-provider object from SAP BW

anilawate — Sat, 10 Aug 2019 09:26:39 GMT

Hi @JBailey,
Thank you for the information.

Does the SAS/ACCESS Interface to HANA supports multi-providers?

Re: How to access multi-provider object from SAP BW

JBailey — Tue, 13 Aug 2019 19:42:03 GMT

Hi @anilawate

I have updated the original post with new information.

Best wishes,

Jeff

Re: How to access multi-provider object from SAP BW

anilawate — Wed, 14 Aug 2019 13:13:57 GMT

Hi @JBailey ,

But Multi Provider is itself a view. How / is it possible to create a view of view ?

Wishes,

Anil

Re: How to access multi-provider object from SAP BW

LouGalway_sas — Wed, 14 Aug 2019 13:26:30 GMT

Anil,

My apologies, when I gave the advice to Jeff about views, I was mistakenly thinking about ADSOs. For a MulltiProvider, as mentioned above, a user must extract all included basic providers and reconstruct the multiprovider in SAS.

Regards,

Lou

Re: How to access multi-provider object from SAP BW

anilawate — Fri, 16 Aug 2019 05:36:23 GMT

Hi @LouGalway_sas @JBailey,

Thank you for the reply.

But if Multi-provider hold multiple view of objects, then it would be time consuming to extract one by one and then re-construct in SAS.

Regards,

Anil