How to allow users to upload a flat file to BW

[Former Member]

Hi All,

For a planning application I would like to permit our users to upload a flat file on their local desktop to the infopackage and execute the load.

We would like to empower the users to prepare and upload their flat files into BW from their desktop without asking for BW support.

Please let me know if any of you have followed this approach.

Thanks

Karen

[Former Member · Accepted solution]

If you want to upload flat file in plan cube, you can simply write a planning function exit for that and provide access to that planning function to user via planning folders or web interfaces.

[gregor_dieckmann · Accepted solution]

Hi,

simply check the existing how to paper for file upload

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90cef248-29e0-2910-11bb-df8dece7...

Regards,

Gregor

[former_member181964]

Hi,

The possible steps..

1. Create a small program and then give

Selection Screen:

FIle name : -

---

Note: Ask users give always same file name i.e. xyz.csv

Once user will give file name and execute it then file will save in Application Server (You fix the path like /usr/sap/BI1/DVEBMGS00/work, you create seperate folder in Application server)

2. Create a small Program with is using Events..

REPORT  ZTEST_EV.

DATA: EVENTID LIKE TBTCJOB-EVENTID.
DATA: EVENTPARM LIKE TBTCJOB-EVENTPARM.

      EVENTID = 'ZEVENT1'.
      EVENTPARM = 'ZEVENTPARAM'.

CALL FUNCTION 'RSSM_EVENT_RAISE'
          EXPORTING
            I_EVENTID                         = EVENTID
            I_EVENTPARM                  = EVENTPARM
          EXCEPTIONS
           BAD_EVENTID                            = 1
           EVENTID_DOES_NOT_EXIST       = 2
           EVENTID_MISSING                     = 3
           RAISE_FAILED                           = 4
           OTHERS                                    = 5
                  .
        IF SY-SUBRC <> 0.
                 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
                 WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
        ENDIF.

3. Once user will upload the file in Step 1, then he need to run this Program,.

4. You craetea Process Chain using this Event, then once User will run this program then the Data Loads will happen through Process Chain.

Note: Eventhough this is lengthy process, it is protected 100%, because we are not giving any access to User, we just given reports/programs to execute.

Thanks

Reddy

Thanks

Reddy

[Former Member]

hi karen

There is one more possibility just check

In RSA1->TRansport connection Tab

Object Changability there is an option for infopackage changeability

this will allow changes to infopackage

hence users can themself provide the path in the infopackage and hit a Schedule

[shanthi_bhaskar]

users can fallow usual method that a BI guy fallows. But we need to provide Datasource ready to upload the .cv file in correct format