It was difficult to select the appropriate title for my question.Background:
The business analyst specify the following report (this is the simplified version):
Also to simplify sopose that I have two "Fact Tables"
- Purchase Orders:- Inventory:The challenge:
I'm trying to build a cube in order to create a powerpivot report that looks like in the specs.The drawback:
the purchase orders table and the inventory table have both the Article and Country dimension. The problem arises when I want to include the time dimension in the pivot, because the inventory is not related to the time dimension.Alternative 1:
we added a dummy time id to the inventory table and then we could hide columns in the report with NULL valuesAlternative 2:
include the quantity or sold articles in the purchase order pro month as a calculated member
I'm not satisfy with this solutions and I think I'm missing something here from the theory.
Any comment or suggestion about how to tackle this issue will be appreciated.