Skip to Content
avatar image
Former Member

Issue :Import Hierarchies into DataStore BODS


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!


error1.jpg (28.8 kB)
error2.jpg (97.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 28, 2017 at 05:27 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Feb 28, 2017 at 10:54 AM


    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!!



    Arun Sasi

    znzsd.png (11.4 kB)
    Add comment
    10|10000 characters needed characters exceeded