Developing potential Product List RRS feed

  • Question

  • We have all these Territories with salespersons, stores, Customers & Products.  We combined all these to form a dimension of potential products that can be sold to customers, etc.  To create this dimension, it becomes a giant table of Products joined to territories, etc.  Its like a Cartesian join.  Then we compare to what was actually sold.

    Is there a better way to do this?  Without the huge table?  Or processing all those records.  Maybe this would be better done in SSAS and DAX?

    Any info or thoughts appreciated.



    Monday, January 13, 2020 5:00 PM