5 Replies Latest reply on Dec 10, 2012 7:16 AM by Alex Kerin

    Creating a set of data from multiple joined dimensions

    Chris Payne

      Hi,

      I have requirement to a create set or combination of data from dimensions that are linked by an identifier.

       

      I have a vehicle fact table which contains details of a specific vehicle, the structure is shown below:

       

      Vehicle A, Engine  Desc, Transmission, Order Date

      Vehicle B, Engine Desc, Transmission, Order Date

       

      I then have a vehicle options table, with the following structure:

       

      Vehicle A, Paint, Green

      Vehicle A, Wheel, Alloy

      Vehicle B, Paint, Blue

      Vehicle B, Wheel, Steel

       

       

      What I would like to do is create a Set of Paint and Wheel, so I can determine the number of vehicles that contain combinations of these two .  At the moment, I am getting a Null in either of these two fields.

       

      Can anyone help me with this?

      Thanks