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

Transactional InfoCube

Hi all,

what are the ways for loading data into a transactional InfoCube? Must i always use BPS, if i dont want to switch the cube to an normal infocube or are there any standard function moduls, which can be used to write into transactional cubes?

Thanks in advance

Frank

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 17, 2005 at 09:42 AM

    Hi Frank,

    transactional infocubes can be filled with data using two different methods: using the transaction of BW-BPS to enter planning data and using BW staging, whereas planning data then cannot be loaded simultaneously.

    Anyway, the data from this kind of infocube is accessed transactionally, meaning data is written to the infocube (possibly by several users at the same time); basic infocubes are not suitable for this. I think this is the only proper use of this type of cube...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Dirk,

      Could you please share "how you have read cube data from "user exit" funciton".

      Have you used any manual planning layout for this purpose and read its data using API_SEMBPS_GETDATA.

      If there is another way, could you please share your idea here.

      This is what am trying to do and am not sure if this the way to go in this scenario.

      I've planning data for version A already loaded into planning cube.

      Now, at the time of version B planning, I need to derive missing characteristic values for each record by looking into Version A as reference.

      To achieve this, I created a manual planning layout & restricted this layout with Version A.

      In the user exit function, I'm reading Version A layout data using API_SEMBPS_GETDATA & deriving missing characteristic values for Version B.

      When I tried for 1000 records in Version A, I can see a status message : "Number of cells to be formed 21000", "formed cells 21000" etc..

      So, If i try for 15000 records, number of cells are going to be more & does this cause any performance or slow due to front-end excel?

      Appreciate your help.

      hari

  • Posted on May 17, 2005 at 09:37 AM

    Hi Frank,

    there is a BSP-like solution that explainshow to load a flat file into the Cube: search in service.sap.com/bi under Service and Implementation for a document named "Load A Flat File Into BW-BPS Using SAPGUI". There is even a similar solution for the Web GUI.

    Hope it helps

    GFV

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.