Need some help on the cube designing

I have 2 measure namely Sales and Judgment. Sales is the money that
collected from selling the products and Judgment is an adjustment that made
on the spending.
I have any hierachy for shops arround the region. Different shops + products
has different spending and judgment.

Here is the diffult part:
1. Spending will roll up accordingly from product to shop to HQ but judgment
is not a rollup value.it is the value enter by management in HQ to adjust
the sale. This value can be enter at shop level and product level or even HQ
level. See the example below:

HQ Total: 38; Judgment: -2
---Shop A Total Sales: 18; Judgment: -3
------ProductA Sales: 5; Judgment: 0
------ProductB Sales: 6; Judgment: 0
------ProductC Sales: 7; Judgment: 0
---Shop B Total Sales: 6; Judgment: 0
------ProductA Sales: 1; Judgment: 0
------ProductB Sales: 2; Judgment: 0
------ProductC Sales: 3; Judgment: 0
---Shop C Total Sales: 9; Judgment: 0
------ProductA Sales: 3; Judgment: 0
------ProductB Sales: 3; Judgment: -2
------ProductC Sales: 3; Judgment: 0
---Shop D Total Sales: 5; Judgment: -1
------ProductA Sales: 1; Judgment: 0
------ProductB Sales: 2; Judgment: -4
------ProductC Sales: 2; Judgment: 0

My questions:
1. How my fact table will looks like if i need to accomodate this judgment
values? Where to store this judgment value?
2. How can build a cube to illustrate it? Is it possible to build such cube?
The measure does not rollup but instead overwrite by a row from fact.
3. Can I build a calculated measure for Sales - Adjustment?

High appreciated for any help given. thanks

Anyone can help?
"Joel Leong" <ch_leong (AT) hotmail (DOT) com> wrote