BPS Processing Question for 2 Planning Cubes
Hello, Can you please give input on the following scenario:
We have 2 planning cubes, cube 1 contains selection
criteria records which will be used to select and
process the detail records from planning cube 2. i.e.
Sales Org = 100, Material= 200, Pct=.05
This cube could have multiple records with different
Cube 2 holds the detail data to be selected and
manipulated based on the records from cube 1. We want
to process each record from cube 1, one record at a
time as selection criteria to select and process the
data from of records of 2nd cube. i.e. Select Sales
Org = 100, Material=200, Cost = Cost * .05 etc.
Do you have a best practice or ideas?
I really appreciate any help. Scott