Hey there
We are currently setting up BOARD as a reporting tool in our company. We use v10.6.
We are trying to get our sales budget data into board to compare them with our actual data.
Thus, there is no data entry or anything at that point.
Unfortunately, we have encountered a problem:
Our sales budget data comprises sales in units and € and is structured by country, month and product class.
However, the product class used for budgeting purposes is not the most granular product class that we have employed in BOARD.
E.g.: We have a product class "A" that is used for the budgeting process.
But product class A is comprised of several product groups A1, A2, A3 etc. on a lower level.
Product class Product group
A A1
A A2
A A3
Now the data reader seems to assign the budgeted values for product class A to every group A1, A2, A3, etc. because he finds these groups in the hierarchy below its respective product class. In this example this would result in 3 rows instead of one expected row.
We are aware of the mechanics behind that and understand that now and would like to find a solution without artificially splitting our budget data. Is there any quick fix that we missed or a setting in the cube / data reader that we forgot to set?
Thanks already in advance!
Kind regards
Markus
------------------------------
Markus Seuffert
Controller
------------------------------