Skip to Content

BCS to BCS migration: First run of CoI when?

Hi All,

We are migrating from BCS 4 to BCS 6

Our requirements,

a. BCS 4 has 7 years of data

b. BCS 6 needs 2 years of history (p12, 2009 to p12, 2011)

c. Go live is p2, 2012 (first collection from SAP R/3 and running of tasks could be p1 or p2)

d. PL00-30 is migrated into BCS 6 (no rerunning of tasks),

e. Conversion of many fields during migration (eg Items, Units, Groups), some fields disappearing, some new fields.

f. Tasks and document types are different in BCS 6

g. Target is the Transaction Cube (to allow future hierarchy re-organisations, restatements etc NOT possible if migrating to a Reporting cube only)

h. We required a clean run of CoI by p6, 2012 (at the latest)

Bearing these in mind, what should the following be;

-First period of consolidation on the cons units?

-First run of CoI in the new system?

-Manual adjs in target BCS system?

Anything else that we should consider?

COLLET Thibaud has a good blog here with the technical migration proposals; /people/collet.thibaud/blog/2010/10/18/sem-bcs--refresh-your-test-system-with-productive-data-using-a-datamart-interface but it doesn't answer these questions.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 26, 2011 at 11:03 PM

    This is quite a challenge. I've had a similar situation. In that case we converted all of the data, including the documents, inverstments DSO, equity DSO, etc. This also included all of the balances for the statistical items for COI. The 1st period of consolidation on the cons units did not change; nor did the 1st run of CoI in the new system.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 26, 2011 at 10:43 AM

    Actually, you do not need to re-execute the tasks for the historical data that you've copied...

    In other words, if you already have executed the first consolidation in your source, no need to re-execute it in your target : all documents are copied...

    or maybe there's something in your question that I didn't get ?

    Add a comment
    10|10000 characters needed characters exceeded

    • Actually, you do not need to re-execute the tasks for the historical data that you've copied...

      > In other words, if you already have executed the first consolidation in your source, no need to re-execute it in your target : all documents are copied...

      >

      > or maybe there's something in your question that I didn't get ?

      Agreed that we don;t need to run the task again on the migrated data

      - but when should we run it first in the new system, and what do we need to do to genrate the right results going forward?

      (so we could choose not to migrate PL30 at all and just rerun CoI from the very first period in the new system,

      or we could migrate everything and run CoI in the first go live period,

      or somewhere in between...

      We could even go live and not run CoI at all, just post manual PL30 for the first few periods)

  • Posted on Aug 26, 2011 at 05:14 PM

    Hi MontyBurns,

    e. Conversion of many fields during migration (eg Items, Units, Groups), some fields disappearing, some new fields.

    f. Tasks and document types are different in BCS 6

    -- Wow, a lot of very thorough work:

    -


    conceptual design: data basises and ConsAreas, attributes of characteristics, validities, BAdI, DocTypes transformation;

    -


    evaluation of proposed changes to the consolidated reporting, especially to disclosures/notes;

    -


    decision of what to do with Cons Groups changes (both, in the CU hierarchies and in journal entries);

    -


    changes in time-dependent hierarchies (first of all, CU hierarchies) must be done very-very accurate;

    -


    if tasks are different, probably a replacement of some tasks or insertion of new ones will be needed;

    etc. etc.

    g. Target is the Transaction Cube (to allow future hierarchy re-organisations, restatements etc NOT possible if migrating to a Reporting cube only)

    -- consider reloading the most of closed periods into basic cubes under one multiprovider.

    h. We required a clean run of CoI by p6, 2012 (at the latest)

    Not many time left with such a tremendous volume of work, ha? And very large part of it is the arcitectural one.

    -First period of consolidation on the cons units?

    -First run of CoI in the new system?

    If to rely on the docs copying only, I'm afraid, you will encounter problems with some parameters, especially that the system calculates by itself in CoI. I'd prefer to make first consolidation in ... - wanted to say in p12, 2011 -- but considering the large volume of historical data for which some related with equity reports might be needed, I think this is an open issue required a special analysis.

    -Manual adjs in target BCS system?

    - adj to CoI due to the date of first consolidation and/or changes in accounting standards - evaluate if JEs in restatement periods might help;

    - adj due to Cons Groups changes;

    - adj due to not 1:1 transferring of data for some objects (e) and f) bullets above);

    - they will be a lot, and I'm afraid that many of them will appear during some testing runs before go-live;

    Anything else that we should consider?

    - little time;

    - probably little qualified people (remember about the architect, it must be a very good one);

    - go-live period is to be very hard for your team.

    COLLET Thibaud has a good blog here...

    COLLET Thibaud - Congratulation! Good work!

    Add a comment
    10|10000 characters needed characters exceeded

    • -- consider reloading the most of closed periods into basic cubes under one multiprovider.

      Good idea, this was our preferred option, but we need to migrate the data to a Transactional cube for restatement reporting using Reporting mode R

      ... I'd prefer to make first consolidation in ... - wanted to say in p12, 2011 -- but considering the large volume of historical data for which some related with equity reports might be needed, I think this is an open issue required a special analysis.

      Yes, trying to analyse it now, wondering if the best option is to run CoI from the start (see reply to THIBAUD Collet above)

      - adj to CoI due to the date of first consolidation and/or changes in accounting standards - evaluate if JEs in restatement periods might help;...

      > - adj due to Cons Groups changes;

      > - adj due to not 1:1 transferring of data for some objects (e) and f) bullets above);...

      Thanks for all of this,

      last question - a unit can technically exist in a hierarchy BEFORE its first period of consolidation - but what impact does it have on reporting (unit not displayed in heirarchy?)

      impact on first run of COI (CoI error?)?

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.