FactorPrism®
Recipe

"Why Did We Miss the Quarter?" Answered With a Bridge That Ties Out

Every FP&A team builds the variance walk by hand. FactorPrism® takes your plan as the baseline and builds it automatically: every miss located at the place in the business where it acts, every dollar reconciled — inside your Snowflake account.

The Challenge

"We're 1% Off Plan." That Sentence Is Hiding Something.

A 1% total variance can be exactly that — or it can be a 20% collapse in one region's product line masked by an unplanned beat somewhere else. The roll-up cancels the story out. The variance bridge auditors and CFOs actually want doesn't just say which line items missed; it locates the causes — across region × product × channel at once — and proves they sum to the total.

The Problem

FP&A Tools Flag Lines. They Don't Locate Causes.

Planning suites compare plan to actual line by line and template a narrative around the biggest deltas. Three things go missing:

−
Offsetting misses vanish A beat in one place and a miss in another cancel in the roll-up — the report says "on plan" while two real problems go unexamined.
−
Line items aren't causes A hundred line items missed because of three underlying factors. Listing the lines tells you where variance showed up — not what happened or where it lives.
−
The narrative doesn't reconcile Templated commentary explains the big deltas and waves at the rest. When the explanations don't sum to the total variance, finance stops trusting them.
The FactorPrism® Way

Your Plan Becomes the Baseline. Everything Else Is Identical.

Point FactorPrism® at a table with your actuals and your plan column, select the window — the quarter, the half, the month — and the engine explains the variance the same way it explains any change: factors located where they act, reconciled exactly.

+
Misses located, not just listed A broad-based shortfall across the whole business is reported once, at the top; a problem specific to one region's product line is pinned exactly there.
+
Offsetting variances surfaced, not cancelled "On plan overall" decomposes into the beat and the miss that produced it — the warning sign templated reports structurally cannot show.
+
The bridge ties out to the dollar Factors sum to exactly the total variance. No plug, no "other" bar — the standard your auditors already hold you to.
+
Explained in plain language Snowflake Cortex turns the factor analysis into narrative — beats and misses against plan, not jargon — ready for the ops review.
FAQ

What Does My Data Need to Look Like?

One table: your dimensions, actuals, and a plan column

A date column, your business dimensions (region, product, channel…), the actuals column, and a plan/budget column alongside it. Grant read-only access, pick the plan column in Setup, choose the window to explain, and run. If your plan lives in a separate table, a one-line view joining the two is all it takes.

Related: Revenue bridge · Margin bridge · Churn & net-adds movement · vs Snowflake's built-in functions

Run it on this quarter's plan today

Install from the Snowflake Marketplace, or try the built-in demo first — no data connection needed.

Get it on Snowflake Marketplace