Skip to Content
author's profile photo Former Member
Former Member

Uploading InfoProvider Documents

Hello,

we are migrating data from a sql-server to SAP BW. In sql-server long texts/descriptions were entered by the user, which were stored in fields within tables.

Within SAP BW I cannot use Characteristics to keep documentation, and would like to, therefore, use the document management for InfoProviders.

However, I do not see a possibility to upload large numbers of texts. I have an Excel document with the project, fiscal period, and text, and would like to import these texts by dynamically reading the project and fiscal period to assign these to the properties of the document, and then read the text as the document.

Does anybody know of a way to mass-upload documents?

Thank

Svenja

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2006 at 01:43 PM

    Hello 😊 sVenJa,

    How r u ?

    You can load the Long Texts from SQL to BW, check these

    Blogs:

    /people/sap.user72/blog/2006/05/27/long-texts-in-sap-bw-modeling

    /people/sap.user72/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-analyzer-introduction-to-excel-workbooks-formatting-part-i

    /people/sap.user72/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-analyzer-introduction-to-excel-workbooks-formatting-part-ii

    /people/siegfried.szameitat/blog/2005/07/18/text-infoobjects-part-1

    Threads:

    Also, you could create Views on SQL itself for splitting the Long Texts so the performance could be maintained in BW. Check the idea of this in the Comments area of this blog,

    /people/sap.user72/blog/2006/06/03/long-texts-in-sap-bw-modeling-150-follow-up

    Best Regards....

    Sankar Kumar

    +91 98403 47141

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your help.

      However, as the Texts in the SQL Server can be up to 1500 I would need 25 InfoObjects to put this method into working order, which seems a little too much.

      I gather there is no way to upload more than one document as an infoprovider document as part of standard SAP BW methodology then?

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:51 PM

    Hello,

    there exists an How-to on this topic:

    HOW" target="_blank">www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/8046aa90-0201-0010-5e99-962948c83331">HOW TO… MASS UPLOAD DOCUMENTS TO BW

    In the paper it is described for transactional data but it should work similar for what you are looking for.

    Best regards,

    Stefan

    Add comment
    10|10000 characters needed characters exceeded