Two facts in PowerPivot RRS feed

  • Question

  • Hello All,

    Basically, i have two tables --one is orderHeader(orderID, amount) and the other is orderReason(orderReason{PK}, orderID{FK}, reasonDesc). bascially I create the 1 to m (orderHeader to orderReason) relationship in powerpivot design view.

    When I create the pivot table  based on this model, I try to drag amount into aggregation and put resonDesc into row label. But it tells me "no relationship". The amount can not be break down by the reasonDEsc even they are dupliacted.

    For sure, i can create a factless table and one more reason dimension table. However, it seems the m-to-m relationship can not work in my powerpivot. 

    Anyone can share some knowledge on this?

    BTW: 2012Rc0+powerpivot 2.0 


    Saturday, February 11, 2012 5:59 AM