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