0EC_PCA_3 cumulative balance issue

[Former Member]

Hi,

I am using 0ec_pca_1/3/4 extractors and loading into the same cube via ODS.

We need to get cumulative balances for every week ,for the inventory accounts.

We have the folloing constraint for 0EC_PCA_3 extractor

<b>The extract structure does not contain the BALANCE field. To get the inventory for balance sheet account, 0BALANCE can be filled in BW in den updating rules. For further information, see note 577644.</b>

In the notes ,they have a fix saying to write the code in the start rotuine. The code takes each transaction and add to the cube with the periods leftover in that fiscal year.

<b>For eg: If we have a transaction in 006/2006 ,it adds 10 more records 1 for 007/2006. 1 for 008/2006... and goes on upto 016/2006. 12 periods are regular periods and 4 are spl. periods.</b>

In R/3 we will be having 2 million records every month so when we load the data it comes to 20 million avg which is very high.For 1 yr it will be upto 300 million records

Can you please help me in this regard, how to get the cumlative balance with out repeating the records?

[Former Member]

You wouldn't create a cube at document number level for PCA3 (it doesn't make any logical sense trying to calculate a balance figure at document level because by definition in PCA the balance must be on aggregated data) - and PCA1 is a totals table anyway

And two when you compress these aggregated records .... the additional records all go into one per period

Message was edited by:

Simon UK03878

[Former Member]

Hi,

We want the cumulative balance for every week and we are using the same extractor at the record level for other reports.

Is it possible that we can do the calculation in the report itself.

If so how can I calculate the balance?

Thanks for your reply.

[Former Member]

How to calculate the Balance - every week - well that means you can't use PCA 1 because thats fiscal period based (ie month)

So now you use PCA3 and create a Z charcterisitc to hold week

Unfortunately you may have a problem with the Balance Sheet (because PCA3 does not cater for year end roll overs)

So you can calc the balance but you have to add everything up since the beginiing of the year (period 000.2006 from PCA1 for the year b/f for the balance sheet)

The good thing about using the OSS note - is that it shows a balance even though nothing (ie no journals were posted) may have happened that month

This is obviously better than adding up everything

If it were me -and i had to do weeks - then I would use PCA1 into period 000 and use the balance and then deltas of PCA3 and use the balance - drop the doc number - put the week number in then compress asap

May need refining - but I would look along those lines

[Former Member]

Hi,

Thanks very much for your reply. I am also trying on the same lines.

So to get the cumlative balance for week 26 I should add the balance of period 000 and add the balances upto 26.

I will try on this line and I will let you know.

Thanks again

[Former Member]

Yes - to period 000 to period 26 to get balance sheet and P&L balances

[Former Member]

Hi,

Thanks for your reply.

I am a bit confused because we need for the inventory accounts, is that affect anyway.

We need to load the 0EC_PCA_1 a full load or a delta load,When can we schedule the loads for 0EC_PCA_1.

0EC_PCA_3 is delta load.

How do we need to load the data for 0EC_PCA_1? Please tell me.

Thanks once again.

[Former Member]

PCA1 load full load for period 000 at the beginning of the year (see th help files - but basically it days load PCA3 in deltas and load PCA in repair full mode each year when they do the PCA roll over and load for period 000 only)

BTW - PCA3 does not include the sub ledger ccounts posted to by 1kek etc - you need to load either PCA4 in full mode for the period or PCA1 in full mode with activity type = PRC4

(read the help files!)

[Former Member]

Hi,

Thanks for your help. I will do that way and let you know how it works.

Thanks once again