This script will replace all the zeros in the scenario Actual with #Missing, thus reducing the size of the database. After running script, must do a dense restructure. SET UpdateCalc Off; Actual = Actual / (Actual != 0);

Smart View Error: Invalid axis type for dimension Entity

Encountered the error "Invalid axis type for dimension Entity" in Smart View at a client. I had never seen this error before and couldn't find anything when I googled it. I was able to sit with a user experiencing the issue and quickly saw what the problem was. The EPBCS application was using the Financials … Continue reading Smart View Error: Invalid axis type for dimension Entity →

Agg w/ EMPTYMEMBERSETS

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"); … Continue reading Agg w/ EMPTYMEMBERSETS →