SAP GRC 10.1 AMF No data selected when adding duplicate fields from separate tables for configurable data sources

[Former Member]

Hi There,

In SAP GRC 10.0, our team had an issue where we could not add duplicate fields from separate table (see ). This was resolved by the SAP Note 1904313/ 1904314 (http://service.sap.com/sap/support/notes/1904313).

We upgraded our system to SAP GRC 10.1 SP05 and could now add the duplicate fields from separate tables. SAP Note 1904313/ 1904314 was part of SAP GRC 10.1 SP03 so it makes sense that we, in a higher version (SP05), would be able to do this.

The issue now is when we add the duplicate fields from different tables and run the Ad-hoc Query to test if the data source works correctly, the No Data Selected warning persists. This means that the data source provides no data for analysis, which is required to write our business rules.

Below is an example:

• Basic data source with just one currency reference field EBAN-WAERS.

• When you run the Ad-Hoc Query you receive data.

• Basic data source with second currency reference field EKKO-WAERS.

• When you run the Ad-Hoc Query no data is found.

Please also make reference to the following thread logged by my colleague ()

Any assistance to receive data with duplicate fields from separate tables will be highly appreciated.

Thanking you in advance.

Regards

Gary Khan

[gaurav_234]

Hi Gary,

Hope you are doing good!

Please let me know if you were able to resolve this issue as we are getting same problem after we moved from GRC 10 to 10.1 SP08

Waiting for your comments,

Regards,

GV

[gaurav_234]

Just want to add our analysis.

We find that when we are adding a field of type D, P, X we are not getting Data even for one Table. For e.g. ISEG table, when we are excluding posting date which is of field type D we are getting Data but once we are adding it, we are getting "No data Selected"

[Former Member]

Hello Gary, Gaurav,

I have the same issue and we are in GRC 10.1 SP08.

I opened a ticket to SAP but no news for the moment.

Have you been able to sort your issue?

Regards,

[gaurav_234]

Hi Mathieu,

Yes, please implement below note:-

2158349 - DS returning inconsistent result in adhoc query

Regards,

Gaurav

[Former Member]

Thanks Gaurav.

Unfortunately I already implemented this SAP note and I still have the issue.

Regards,

[former_member197694]

Hello Mathieu,

did you get chance to check the below sap note,

2155943 - No selected data in Ad-Hoc Query

Regards

Baithi

[Former Member]

Hello Baithi,

Yes, I implemented the following without any success:

1930781

1972490

1988286

2109711

2115704

2125606

2148056

2155943

2158349

2183254

2188874

Regards,