Skip to Content
0

Issue :Import Hierarchies into DataStore BODS

Feb 24, 2017 at 10:25 PM

118

avatar image

error1.jpgerror2.jpg

We are trying to use hierarchie as a data source in sap bods datastore. In the earlier time, I tried to import by name, but it gave me error message which looks as screenshot 1. And then I open the workspace of datastore, click on 'external metadata' and 'Hierarchies'. tried to import from there. However, it's nothing happend. After click on 'import', could not find it from the list of 'Hierarchies' of Data Store. Checked some resource online, one user who has similar issue but no solution provided. Also, someone suggested to check on the DS function. Not sure which particular function he mentioned. We are using BODS 4.2 sp5. We have no isse to import ODP /table/function from the Datastore. Just for the hierarchies source, there is no way to import.

Appreciate on any suggestion!

Thanks!

error1.jpg (28.8 kB)
error2.jpg (97.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Rakesh Yadav Feb 28, 2017 at 05:27 AM
0

Can you please ask your SAP Basis Team to grant SAP_ALL rights to the RFC_BODS User

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Rakesh,

Thanks for your suggestions. I would ask the security team to apply a trace for the first and then decide on next action

0
Arun Sasi Feb 28, 2017 at 10:54 AM
0

Cindy,

Can you please ask your SAP Security Team to Apply a trace on the BODS user when you try to import ERP hierarchies. This will help them to check which Authorizations are missing for importing hierarchies in Data Services.

***Dont provide SAP_ALL authorization to the BODS user. This will cause an issue when you later on move to Acceptance and Production Environments.

Once the missing Authorizations are determined, ask SAP Security team to provide necessary Authorizations.

I have never worked on hierarchies, but found a useful information in SAP Supplement Guide. Hope this is useful

Hope this is useful!!

:)

Regards

Arun Sasi


znzsd.png (11.4 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Arun, thanks for the comments. I'll work with security person to see if it causes the issue.

0

Hi Arun,

Just checked with security, we already applied the above authorization. From the trace, everything looks fine. Would you have any other idea on this?

Thanks a lot!

CC

0

Cindy,

Thats strange. Can you please check if the hierarchies actually exists in SAP system. Looks like there is some issue with the code

Regards

Arun Sasi

0