The RevRec Canvas
Book 38: One report, two populations cover

Home › Reporting and analysis

Book 38 · Alteryx workflows for SAP RAR

One report, two populations

Four month-ends of the RAR waterfall and of the legacy deferred-revenue run-off in one report: one layout from two, cost-type POBs out, migrated contracts counted once, a dashboard in month order, and a control that proves every snapshot adds up.

  • Reporting and analysis
  • Intermediate
  • 91 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

Legacy and RAR deferred revenue in one report across four month-ends, with no double counting. A second workflow rolls the RAR waterfall forward month by month and checks the revenue: posted at double the schedule, not posted, posted on a cost POB.

What you get

  • The ebook: a 91-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (38_Legacy_and_RAR.yxmd, 38b_RAR_Rollforward.yxmd)
  • Synthetic sample data (11 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 1One report, two populations
  2. Chapter 2The ten files
  3. Chapter 3One layout from two
  4. Chapter 4One table, then cost types out
  5. Chapter 5Migrated contracts out
  6. Chapter 6The detail, the summary and the dashboard
  7. Chapter 7Mapping failures and the overlap control
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Does the waterfall roll forward?
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 38: One report, two populations table of contents
Contents
Book 38: One report, two populations first page
First page