cancel
Showing results for 
Search instead for 
Did you mean: 

Uploading InfoProvider Documents

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

there exists an How-to on this topic:

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

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

Best regards,

Stefan

Former Member
0 Kudos

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

Former Member
0 Kudos

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?