3 Replies Latest reply: Apr 19, 2018 2:45 AM by Andy Saile RSS

    Pivot table with dimensions from two different fact contexts

    Andy Saile

      I have a concatenated fact table with two fact contexts and corresponding dimensions:

           

      FactNameCargoIDCargoGroupPathNameDateIDDamageTypeName
      Transport1PackageA-->B20180101
      Transport1PackageB-->C20180201
      Transport1PackageC-->D20180301
      Transport2EnvelopeA-->B20180201
      Transport2EnvelopeB-->D20180301
      Damage1PackageA-->B20180101Chipped
      Damage1PackageA-->B20180101Scratched
      Damage2EnvelopeA-->B20180101Crushed

       

      I calculate the measure Count({<FactName = {'Transport'}, DamageTypeName =>} distinct CargoID) in a pivot table with dimensions DamageTypeName and CargoGroup. The result looks as follows:

      Edit: Problem here is the fact context "Transport" does not have dimension values for DamageTypeName. Nevertheless I want calculate the total value for number of transported cargo to show for each DamageTypeName.

       

       

      What I want it to look like is:

      Attached is an example, which I used to test different behaviours.

       

      Does anyone have an idea?

       

      Kind regards,
      Andy