1 person found this helpful
I have a deja vu. This was not working since many versions back. The same with Expense reporting. Once switched on, one could not switch it back.
You described one way of getting it undone: via the rebuild of the dimension, but that was too tricky in my situation. The chance of errors and data loss was too large.
In that time, I went into manual mode. Removed all Two-pass and Expense reporting. Added them again. Then excluded them from the dimension build. If a change was needed, I went there in the manual mode.
A quick check in the DBAG under Working with Rules Files, there is an entry explaining how to reset a property to it's default values. Under the Field Properties->Dimension Field Properties is a checkbox that reads "Delete when the field is empty" which should be selected.
Hope that helps you.
EDIT: Apologies for not reading your post fully. I'm intrigued now though.
Thank you Philip. I think we are going to have to pursue a similar approach setting those "other" properties manually.
That setting, "Delete when field is empty", will reset the DataStorage and Consolidation properties to their defaults (Store and Add respectively), but does not affect TwoPassCalc, VarianceReporting, TimeBalance, or TimeBalanceSkip; at least not in release 126.96.36.199.
you might have to rebuild or use custom API to make changes accordingly.
I think these will not be reset to default with the rule file