Metadata Mayhem & Business Rules
This member property determines whether data is manually entered or system-calculated.
What is the calculation/data storage property (Base vs. Calculated)?
Manually rebuilding a broken Excel model from scratch vs. this common consultant nightmare.
What is debugging someone else's undocumented business rule?
This planning approach starts with corporate targets and pushes them down to business units.
What is top-down planning?
This OneStream tool lets you view and enter data in a grid format based on a defined POV.
What is a Cube View?
This beverage is the unofficial fuel of every remote consultant.
What is coffee?
or Monster, Redbull, Tea, Meth.
This dimension tracks consolidation stages, like local currency, translated, and adjusted values.
What is the Consolidation dimension?
Sitting through this recurring meeting vs. a two-hour month-end close call that runs long.
What is a status update meeting that could've been an email?
This forecasting method continuously extends the horizon forward, regardless of fiscal year-end.
What is a rolling forecast?
This feature lets a user click a data point to see the underlying transactional detail behind it.
What is drill-down (or drill-back)?
This piece of furniture separates "professional you" from "couch potato you" during work hours.
What is a desk?
This rule fires automagically when Workflows are unlocked
What is the Workflow Event Handler rule?
This dreaded calendar notification vs. a surprise "quick sync" that turns into an hour.
What is a meeting invite with no agenda?
This scenario type represents the original approved plan, typically locked after submission.
What is a Budget scenario?
What is an Action Button?
Forgetting this is on before a call is the most classic remote-work faux pas of all time.
What is your microphone (or camera)?
This loop structure repeats code a fixed number of times using a counter.
What is a For...Next loop?
This term describes distributing a top-level number down to lower entities or accounts based on a driver.
What is an allocation?
This design principle means limiting a dashboard to only the metrics that actually drive decisions, rather than everything you can measure.
What is signal-over-noise (or "less is more") dashboard design?
This background trick says "I have my life together" without actually cleaning your home office.
What is a virtual background (or blur)?
18
How many dimensions does a cube support?
This .NET-based language is the primary scripting language for OneStream Business Rules.
What is VB.NET?
This term describes populating actual periods in a forecast scenario.
What is "seeding"?
This term describes the exact combination of dimension members (Scenario, Time, Entity, etc.) that defines what data you're viewing.
What is a POV (Point of View)?
This clothing strategy involves dressing professionally from the waist up only.
What is "business on top, pajamas on the bottom"?