Revenue Shortfall

Cube

Demand

Description

Revenue shortfall from target by more than 10 percent

Type

Regular (Batch and Interactive)

Priority

Medium

Measure

Demand Plan Revenue

Owner

admin

Due Date

+10 days

Formula

Revenue_Shortfall."Demand Plan Revenue"[level(Fiscal.Fiscal.Quarter)] [level("Product Family")] assert (pct("Demand Plan Revenue","Target Revenue") > 90 or isPast() or (isNull("Demand Plan Revenue") or isNull("Target Revenue")))