4 Replies Latest reply: Sep 23, 2014 11:47 AM by Prashant Sangle RSS

    Set Analysis and Data Model

    Sarah Sullivan

      I have a question about how set analysis expression evaluate depending on your data model.  I have a situation where I have cases and each case has several materials associated with it and each material is either used or unused.  I wanted to use set analysis to get the set of cases with certain materials that were also used (the intersection of the set containing just those materials and the set containing only used materials).

       

      The case identifier is linked to the material usage with a key dimension.  Like this:export.png

      When I use the expression that does the intersection and returns the Key dimension, the intersection works properly.

      ({<Material = {'A', 'B'}> * <Qty = {'>0'}>} Key)

       

      When I use the expression that does the intersection and returns the Case dimension, the intersection does not work properly and returns additional cases as belonging to the set.

      ({<Material = {'A', 'B'}> * <Qty = {'>0'}>} Case)

      Capture.PNG.png

      I have attached an example QVW illustrating this example.

      Obviously there is something that I don't understand about how set analysis expressions interact with the data model.  Any help or explanation is much appreciated!!