Skip to Content
0
Jun 16, 2014 at 02:46 PM

Copy data from multi-level category to single category

20 Views

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