There are three SAP applications dedicated to financial consolidation.
SEM-BCS still has the richest and deepest functionality which is still developed and delivered in Enhancement Packages.
However, it is positioned more as application for the biggest companies. And there are not many left which have no consolidation application.
I want to tell you about one of the last very big SEM-BCS projects.
I do not afraid to call this project as the most unique one. Because of its scope, very rigid Client’s requirements, and technical restrictions of SEM-BCS (due to conformation to these requirements) that nobody met before.
So, the client is one of the world’s economical giant. I was invited by a General Contractor (hereinafter GenC) as a subcontractor and later I came to the project again, this time conducting the project’s Quality Assurance, on behalf of SAP. So, it was very interesting having vision of the project from inside to look at the project architecture from the outside.
The key features / requirements of the project:
For example, the A/R value has the following breakdowns:
- by the partners;
- by the age of indoubtedness;
- by the kind of indoubtedness (trading, for sale of Fixed Assets etc.);
- by the geographical market of the debtor.
So, what’s unusual, aggravating, in this reqirements?
An example. The breakdown A (in thousands): 490, 490, 490, 490, 490, 490, 490, 490, 490, 490
(10 times by 490 thousand).
The breakdown B (in thousands): 1200, 1200, 1200, 1200, 100.
The sum of denominated by 1000 data of the breakdown A gives 0. (We called this case as data degeneration).
The sum of denominated by 1000 data of the breakdown B gives 5.
Which one is true?
The correct amounts are present in the system as totals figures (along with their breakdowns).
Even in the systems which use data with the same precision might occur difference in 0.01 due to rounding after Currency Translation. Here, additionally to usual difference we might have data degeneration in the breakdowns due to denomination to Millions without decimials.
In general, requirements #5, 6 and 7, almost inevitably must destroy the mutual consistency of most of reports (as well as equivalence of the total figure and the sum of its breakdowns).
What were the solutions and which restrictions met?
In order to allow the system to align all the figures with Millions without decimals the Group Currency was created as a new currency code with zero decimals.
The idea – in a precalculation cube (with usual GC with 2 decimals) we bring all amounts to Millions (denomination), then restore data consistency between breakdowns and totals by attributing the diference between the breakdowns and the total to the determined accounts (that of course lead to significant increasing in their number), then restore data consistency among the reports.
After that we reloaded data into BCS cube with Millions without decimals and after execution of the most tasks data would remain consistent in Millions without decimals. Exceptions – are allocations. They may lead to data degeneration.
In general, such restoration of consistency was made on each step of the process:
Because the number of FS items where the differences were attributed to was large, the C/T steps were configured for small groups of items. And here we met
Restriction #1 – number of steps in the C/T method should not exceed 999! (Though, it’s true for other methods too)
The solution for such a situation is to decrease number of steps below the limit by decreasing the number of FS items or rules of their C/T.
The very large amount of tasks brought several restrictions.
Restriction #2 – performance of loading the consolidation monitor (several hours)
and
Restriction #3 – number of tasks in the consolidation monitor should not exceed 999!
and
Restriction #4 – number of columns in the consolidation monitor should not exceed 255!
The 2nd restriction was overcame by the SAP Support by eliminating the bugs in a code. Performance was enhanced drastically, but anyway became rather annoying.
The 3rd restriction was overcame by a dividing of consolidation area into several ones with their own monitors.
The 4th restriction was overcame initially very simply: just by placing the ConsUnits into columns and Tasks into rows. But when the number of ConsUnits increased we met
Restriction #5 – it’s impossible to load the consolidation monitor if you have both, the number of ConsUnits and Tasks exceeding 255 (as a consequence of restriction # 4)
The remedy here is to decrease either the number of ConsUnit to be consolidated or number of tasks in the same Consolidation Area.
The Support guys from Waldforf were very surpised that GenC complained about such restrictions that were not met before by anybody else (though it was not said so, but the reaction was – you are crazy!).
The estimated during QA time of 1-time running of all tasks gave about 10 days that is hardly acceptable if to take into account possible need to make several iterations.
Recently I talked to one of the key persons of GenC and asked about the fate of the project. The asnwer was: the key users sabotage the system because it takes for them less time to consolidate as before, without SEM-BCS.
So, here I wanted to tell about this project experience, what SEM-BCS may and what – not.
It’s also a bright example what may happen with implementation project if to agree on and conform to ALL the requirements of the Client.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |