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

Custom Copy Planning Function in IP

Hi all,

I have a requirement wherein I need to copy the content of one cube to another cube based on certain conditions that are to be handled explicitly.

I cannot use the standard copy function.

So i need to model my own planning function to meet the requirement. Can anyone provide a template based on which I can proceed and create a custom planning function for copying the data from one cube to another cube.

Rgds

Syam

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 09:09 PM

    Hi Shyam,

    Did you try a FOX formula with planning area as one of the fields to be changed?

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Syam,

      another way to copy is tp create a multiprovider, which has both the cubes i.e. 'from' cube and 'To' Cube.

      Then create an aggregation level on the multiprovider and then copy the data.

      (precaution has to be taken in creating the aggregation level as this has to have releavant characteristics to copy).

      thanks

      abhijit Misra

  • Posted on Nov 26, 2007 at 09:18 AM

    Hi

    in this case you can very simply load data in your cube in a BW way - with mapping and trasformations if you are on BI 7 or with update rules in BW 3.5

    Instead of using COPY function and FOX ( in this case you should create a multiplanning area with your two cubes and create a copy functon or a fox formula for more complex requirements )

    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.