2 Replies Latest reply on Oct 9, 2013 8:33 AM by Cynthia King

    How do I join two result sets from the same data mart?

    Cynthia King

      When someone orders they get an order id on a record.  If they renew that product, that order_id becomes the original_order_Id on a new record and the new record gets it's own order id.

       

      I need to pull all the original orders then match them up to their renewals.  Do I set up two connections?  Or do I pull the full universe and filter from there?  In Hyperion I run two queries and join them order_id +- original_order_id.   I am trying to compare original orders against their renewals.