Copy data from multi-level category to single category

[former_member591760]

I need to copy data from a category which has multiple children levels below it to a standalone category.  I want to use a so I can schedule it run automatically each night.  Below is a tree representing the structure of the tiered category.  The parent "L1" is the top level and contains the calculated data I want to copy.  There are six "L2" levels directly below L1 and one of those six has another three "L3" levels below it.  Using the standard copy package it errors saying there is no data in the selected region.  If I try listing each of the base level categories it will error saying the number of categories do not match.

L1_AAA

   L2_AAA

      L3_AAA

      L3_BBB

      L3_CCC

   L2_BBB

   L2_CCC

   L2_DDD

   L2_EEE

   L2_FFF

I also tried writing a logic script for the copy but can't get past the following error.  I copied an existing package and removed the user prompts as all variables are hard coded in the logic but I keep receiving the error below.

Execute formulasError

Invalid selection passed:

%SELECTIONFILE%

We are running BPC v10 MS.

Thanks

[former_member186498 · Accepted solution]

Hi Pablo,

to use the standard copy package you have to specify all the children (not parent) on the left side and write the same numbers of destination category on the right (separating these by a comma).

If your destination category is L4 e.g.

source                                                                      destination

L3_AAA ,L3_BBB,L3_CCC,L2_BBB,L2_CCC, etc.          L4,L4,L4,L4,L4, etc.

Regards

     Roberto

[former_member591760 · Accepted solution]

Hi Robert,

I would never have thought to give that a try but it did not work at first.  It kept giving me the error saying the number of members in the source and destination should be the same.  I finally got it to work when I entered the destination category using a combination of different case settings, i.e. all caps, all lower, mixed case, etc.

Thanks for the tip!

Regards