Read data from file in BPC Server

[Former Member]

Hi,

I have a requirement to update a Custom table on BW System. The source to update this table is a File on BPC 10.0 Server - The user will update the file with values and store it in BPC 10.0 server (\ROOT\WEBFOLDERS\APPSHELL\CONSOLIDATION\EEXCEL\MAPPING\POSITION_MAPPING.XLS)

My Question is

1. Unable to read this BPC 10.0 file path - When tried to access this file path - system is throwing an error - File path directory/ folder does not exist.

When tried to dig further, I see that the data is stored in a Table UJF_DOC with data in DOC_CONTENT field.

The problem here is this data is in Hexa Decimal Format (X STRING). I need this data in ASCII format (a File/ table format) same as the user uploaded it.. so that I can upload this in BW Application server and read the data through an ABAP program and update the Custom table.

2. Is there any Function Module or Class -> Method which can suffice my purpose?

3. I don't see any Method in CL_UJF_FILE_SERVICE_MGR Class is able to meet this requirement (i.e. read data from BPC server and upload to BW Application Server).

4. Atleast can any one tell me how to convert this XString data to Normal ASCII format?

  Thanks for your Help.

Regards,

Ravikiran

[Former Member]

Hi Ravikiran,

Did you ever solve this issue?

I have a similar request and so far I have been unable to read the data in table UJF_DOC, DOC_CONTENT

Regards,

Gudmundur

[Former Member]

Hi Gardarsson,

It's good to know that you are able to read data in user understandable format (file/table) from DOC_CONTENT.

Could you please share with me those details on converting the hexadecimal data in DOC_CONTENT field to ASCII format.

Once you extract the data... we just need to save this data in a temporary table which in turn is passed to BW File server. Will share that code soon.

[sap_user62]

Hello,

I have not implemented this, but you can have a look at this thread. Hope it throws some light

http://scn.sap.com/thread/3222953

Thanks

Ed.

[Former Member]

Hi Ed,

Thanks for the reply, But this is where I'm stuck as well (i.e. unable to get the data in required format to Application server) where as I don't see any problem when downloading to Presentation Server (desktop).

If you feasible solution is found. Please let me know.

Thanks,

Ravikiran.