Cleardata rule - How to exclude certain accounts?
Content
In our Forecast Cube we are loading the Revenue Forecast to several different regions (i.e., REV_Region1,REV_Region2, REV_Region3, REV_Region4), these revenue accounts have no associated actuals, but I still want to keep the data for these accounts. Before loading the actuals we clear the Scenario. How can I exclude certain accounts from getting cleared out. The rule is below.
Code Snippet
Fix (USD, {RTP_Years},{HypFcst_Mth1}:{HypFcst_Mth2},{HypFcst_Versions}, @IDESCENDANTS("Account SUMMARY")) Cleardata {RTP_Scenario}; EndFix FIX ({HypFcst_Versions},"USD",{RTP_Scenario}) FIX ({RTP_Years}) Calc Dim ("BusArea"); ENDFIX ENDFIX
Tagged:
0