You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cleardata rule - How to exclude certain accounts?

edited Jun 1, 2018 6:10PM in Planning 3 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!