Drill Through Origin to FIM 10.0 data through SAP BPC 10.0 MS

[Former Member]

Dear Experts,

I am trying the Drill through origin option to check the source data loaded through Sap FIM.

I am receiving no results from the server:

"This can happen when none of the parameters passed to the server matches transaction table column names."

Please suggest the way forward.

Environment: SAP BPC 10.0 MS, SAP FIM 10.0

Below are the steps followed. click on Test

Result:

FIM JOB:

Transaction table structure:

Thanks,

Srikant

[Former Member]

Hello,

Please refer to the attached KBA : 1740326 - FIM: Error message "The server returned no results" is displayed when using Drill to origi...

Regards,

Soumaya

[Former Member]

Dear Sirine / Soumya,

I have already tried the option, I am using the admin ID and it is already added to BOAFIM Administrator,BOAFIM Business group.

Please find the below screenshot of Job and also CMC.

Please advise.

Thanks,

Srikant

[Former Member]

Hello,

A FIM user should be part of ONLY one group .For your case , it is part of admin and business group.

Please add it to  only one group and test the issue

Regards,

Soumaya

[Former Member]

Dear Soumaya,

I have removed the other groups and kept only business group.

tested the functionality still receiving the same error message.

Thanks,

Srikant.

[Former Member]

Hello,

Could you please check the number of line of your transaction table  via the following querie :

Select count(*) from 

Regards,

Soumaya

[Former Member]

Dear Soumaya,

Total 171 rows for the entity i am querying out.

Am i following the correct approach in setting the Drill through through Administration client?

I mean column names, because i am receiving below error.

The server returned no results.

Note: This can happen when none of the parameters passed to the server matches transaction table column names.

Thanks,

Srikant.

[sirine_belhadjrhouma]

Hello Srikant,

Could you please check if the user running the Drill To Origin is added to the Job users list in FIM?

Regards

Sirine.