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

CRM (Market Planning) and Integrated Planning--How To?

Hi,

AT my client we want to bring in Market Planning Data in BW especially Campaign Planning. According to CRM consultant..he wants us to do the integrated planning in BW but in all SAP material on SDN I have not seen single post where we are planning on CRM Cubes ...

Does any one has experience in this area where we can plan on CRM Cubes (Campaign Analysis).

Or We do the planning in CRM and just bring in the Actuals in BW.

Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 05:39 PM

    Hi John ,

    The planning is always done on IP module , part of BW . The project shoudl create an interface to accept the planned figures based out on a file ( text or XML) and load on to the Aggregation level of IP. For this you need to model a BW real time cube to capture the data from the file .

    Then the actuals should flow in to merge with the plan and a Multi provider can get you Plan Vs Actual scenario .

    I am currently working on this kind of project and hope this helsp you. Assign points if it helps

    Cheers

    Raja

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Harsh,

      Thanks for your reply.

      The problem has been solved but the solution goes like this. In CRM, SAP has given capability to use planning but using SEM-BPS rather than IP (don't know why..but it is there).

      So users are going to plan in CRM and their data will be brought into BW in cube 0CRM_C01 where we have uploads based on planning profiles.

      It is quiet complex to send back the data to CRM (Market Planning) because we have to upload the file or use APD but the basic problems was where to upload as the tables have to be identified .

      Moreover CRM is transaction oriented as it creates documents so uploading into CRM (Market Planning) doesn't seem to be easy and verstaile approach.

      Regards

      John

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 09:25 AM

    Hi,

    Please see my reply to Harsh.

    Regards

    John

    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.