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

DTP load from planning cube

Dear experts,

A DTP can load all data from a planning cube (real-time) to another cube if the planning cube is set to "loading mode" and all requests are hence closed.

For some planning applications, switching from planning to loading mode might not be a good option, though (downtime of the planning application), but not switching and then running a DTP wouldn't include all those records that are in the open planning request.

So here's the question: Which option exists to load all data from a planning cube via a DTP to another cube, without having to switch its loading mode? Closing requests (is there some ABAP function module?) might be a last option since the planning application shouldn't be flooded with new requests.

All help highly appreciated!

Regards,

Tilman

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 15, 2010 at 03:40 AM

    Hi Tilman,

    I am not an expert with Planning but try this, create a cube which would be a copy of your main planning cube into which you will load the data through a copy function. Now switch the behaviour of the copy cube to loading and use a DTP to load it to further data targets. If you wish, you can then delete the data in the copy cube to avoid having the same data in two cubes.

    Hope this helps

    Sujeer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 15, 2010 at 08:51 AM

    I am also not an expert on planning in BI but when you load data from planning cube by running DTP, it extracts only requests with status green. As far as I know as long as you are writing into planning cube, the status of request in planning cube is yellow.

    Aban

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 15, 2010 at 09:12 AM

    The program RSAPO_CLOSE_TRANS_REQUEST_ALL3 close all opened requests from all the transactionnal cubes of the system.

    You can easily adapt it to work only on the cube(s) you are interested in.

    Regards,

    Fred

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 15, 2010 at 09:30 AM

    I am used to work with real time infocubes (on the SEM-BCS module) and I am sorry to confirm that you need to close the latest open request to be able to load the up to date data to another cube.

    In BCS, you have several SAP documents that explain that constraint.

    From BW 7.00 you have a standard job in the process chain to swtich the cube load mode and plan mode (no need to create a program anymore)

    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.