topic Re: Select statement on SAP BW DSO object in SAS Data Management

Select statement on SAP BW DSO object

edv2017 — Wed, 06 Dec 2017 14:57:57 GMT

Hi,

We have installed the Surveyor and follow a parallel approach. First approach is transferring the metadata and transfer specific BW infoprovider transactional content afterwards.

We also have a second approach to select data directly using SQL. Is this possible?

We do not seem to have a correct statement.

The source system is BW on HANA.

Technical name of advanced DSO: CDDPOA02

We are trying statements like this:

LIBNAME SAPBW SASIOSR3 sysnr=10 ashost=asapbwci00.hosting.corp trace=0 destgroup="SAS1" BatchMode=1 language=EN

! Client=100 USER=TESTSAS PASSWORD=XXXXXXXXXXXX;

NOTE: Libref SAPBW was successfully assigned as follows:

Engine: R3

Physical Name: asapbwci00.hosting.corp

PROC SQL;

SELECT count(*)
FROM SAPBW.CDDPOA02;

And get errors like these:
ERROR: Exception while using RFC to SAP: TABLE_NOT_AVAILABLE

We also tried:

SELECT count(*)
FROM SAPBW./BIC/ACDDPOA022;

or some more statements. All to no luck.

Any idea which statement works?

Best Regards,

Eelco de Vries

Re: Select statement on SAP BW DSO object

LinusH — Tue, 05 Dec 2017 16:54:46 GMT

Contact your SAP BW admin to verify that you have the necessary rights and set correct options to be able to access that specific table. He/she should also be able to check the logs for more specific information about your access attempt.
You could also add
Options sastrace=',,,d' sastraceloc = saslog nostsuffix msglevel=i;
to possible get out more info in the SAS log.

Re: Select statement on SAP BW DSO object

edv2017 — Wed, 06 Dec 2017 12:29:08 GMT

Hi LinusH,

Indeed we are also testing new BW authorizations, but this is not where the solution is expected.

Since when we try a normal metadata table in BW we get the authorization message:

SELECT count(*)

FROM SAPBW.RSDIOBJT;

ERROR: Exception while using RFC to SAP: NOT_AUTHORIZED

And not the TABLE_NOT_AVAILABLE message.

So it is purely how to access the BW advanced DSO object via a SQL statement.

Best Regards,

Eelco de Vries

Re: Select statement on SAP BW DSO object

edv2017 — Thu, 07 Dec 2017 16:10:50 GMT

We found the solution by using aliases in the PROC SQL FROM statement to the BW DSO tables.