The RevRec Canvas
Book 45: Setting SSP: the observable-price study cover

Home › Contracts and obligations

Book 45 · Alteryx workflows for SAP RAR

Setting SSP: the observable-price study

Build the standalone selling price from the sales themselves. Keep only the sales that are evidence of a standalone price, take the median per product group and channel, test whether enough sales sit close to it, compare with the SSP table in use, and write the rows that update it.

  • Contracts and obligations
  • Advanced
  • 85 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

533 sales lines studied for 14 product groups and channels. Three SSP updates, one new SSP and three groups that need an estimate. A second workflow compares the study with last year's and checks that last year's approved SSPs reached the SSP table.

What you get

  • The ebook: an 85-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (45_SSP_Study.yxmd, 45b_SSP_Refresh.yxmd)
  • Synthetic sample data (8 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1Where does the SSP come from?
  2. Chapter 2The data and what is hidden in it
  3. Chapter 3The price population
  4. Chapter 4The median, computed explicitly
  5. Chapter 5The band and the study
  6. Chapter 6The update file, the exceptions and the controls
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9The annual refresh
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 45: Setting SSP: the observable-price study table of contents
Contents
Book 45: Setting SSP: the observable-price study first page
First page