Suppose this month you had an analysis that takes some input parameters (ABC) and runs some logic to generate a results table (XYZ). Next month comes along and you want to look-back at these results and perhaps compare the values to last month. You realize that the data in the .dxp you’re using is linked to source and when you opened this .dxp all of the values are updated with no way for you to view what the values were previously.
But wait. There’s hope! This secret I’m about to share with you will demonstrate how to generate a third table that will store values from columns you specify with a “scenario” value you input. Can you think of other reasons why knowing this TOP SECRET trick might be useful in your day-to-day?