SPCOPYCATEGORY

[Former Member]

Hello,

This seems to be a 5.1 stored procedure, how do i find out what it does? we have sql 2008 and this stored procedure is encrypted so there is no way to find out. Could someone please explain me what it does? I did see its got something to do with summarization, but thats it.

Thanks.

[Former Member · Accepted solution]

Hi,

It seems that the MS version has few undocumented SPs which are supposed to be supported as per SAP note 1446515.

SAP has replied to a support query as follows:

In fact COPYCATEGORY - Carry-forward rules give you the ability to
generate the Opening Balance of any category based on this properties:
Opening category in the Category dimension
This procedure can be used to initialize a new reporting period with
the closing balances of the last period from the previous year into
the opening balances of the current period. In a legal consolidation
application, such balances are usually identified as members of the
FLOW dimension. In simpler applications, however, it is also possible
to store them as additional accounts in the ACCOUNT dimension.
The syntaxe should be the following:

RUN_STORED_PROCEDURE = SPCOPYCATEGORY([%APP%],[%CATEGORY_SET%]
,[%CATEGORY_SET%],[%CURRENCYMBRS%],[%PROPERTYNAME%],[%SCOPETABLE%],[%LOGTABLE%])

I'd assume this SP would do basically the same thing as Carry-Fwd.

Madis