Help needed for the Summarize-Procedure

[Former Member]

Hello,

I want to copy "reduced" data from one to another category using the SPCOPYCATEGORY procedure.

The logic is quite easy:

*RUN_STORED_PROCEDURE=SPCOPYCATEGORY('%APP%','%CATEGORY_SET%','OPJ1_C','LC','COPYCATEGORY','%SCOPETABLE%','%LOGTABLE%')

*COMMIT

The clue seems to be the COPYCATEGORY parameter. I defined it as a property in my dimension SEGMENT.

ID PARENTH1 COPYCATEGORY

CSTE5 CSTE

CSTE5_INP CSTE5 CSTE5

CSTE52 CSTE5

CSTE51 CSTE5

My Intent is to summarize the values below the CSTE5-hierarchy from the leaves CSTE51 and CSTE52 to leave CSTE5_INP.

When I run the logic, no data was found to copy. (I doublechecked the facttables.)

What's wrong?

Jochen Kowalski

[Former Member]

The answer to my own question:

This procedure works only with the account-Dimension.

Other dimensions like a userdefined product-dim cannot be processed.

Thanks to reading that fine documentions of BPC I only spend half a day

for this problem.

Bye

[Former Member]

Hello Rahul,

if you want to check the records written back by an input schedule, you will have to look

at the database using the sql server management studio.

For each appset there is a database, and for each application there a three tables:

tblfact<appname> (the content here is the same as in the cube)

tblfac2<appname> (used for light cube optimization and some bpc procedures)

tblfactwb<appname> (here the input schedules store their data)

Hope that help's

Jochen

[Former Member]

Jochen,

Sorry I can't answer your question. But you seem to have answer to one of my questions. How do you check entries in Fac2 and Facttable?

Thanks, Rahul