Aggregation script to be used on forms, aggs the scenario selected on the form.
SET AGGMISSG ON; SET CACHE HIGH; SET UPDATECALC OFF; SET LOCKBLOCK HIGH; SET EMPTYMEMBERSETS ON; /*Forecast Agg*/Fix (@Remove({Scenario}, "OEP_Plan"))Fix ({Scenario} AND "OEP_Forecast")) /* cleaner way to use the Fix */ Fix ("OEP_Working", &OEP_FcstStartYr:&OEP_FcstEndYr) Agg ("DataSource", "Detail", "Entity", "Function", "Intercompany"); Endfix Endfix /*Budget Agg*/Fix (@Remove({Scenario}, "OEP_Forecast"))Fix ({Scenario} AND "OEP_Plan")) /* cleaner way to use the Fix */ Fix ("OEP_Working", &OEP_PlanStartYr:&OEP_PlanEndYr) Agg ("DataSource", "Detail", "Entity", "Function", "Intercompany"); Endfix Endfix