Example 3 tracks the inventory level for the following product, region, and months:
The trigger is activated after the update action is complete. If the inventory of Colas in the eastern region falls below 500,000, the example logs an entry in the file Inventory_East.
create after update trigger Sample.Basic.Inventory_east where "(crossjoin ({children([Qtr1])}, {([Market].[East], [Product].[100], [Inventory].[Ending Inventory])}))" when [Ending Inventory] < 500000 then spool Inventory_East end;