I have a client with a multi-year model. In the initial build, we used the Select Time function to select the specific fiscal year we wanted the formula to pick up. However, as the client uses the model in future fiscal years, this means a relatively long manual exercice of changing these formulas to go from Select Time FY 14 or Select Time Dec14 to 2015 periods and then 2016 etc.
We also have a control module which specifies things like current fiscal year and prior fiscal year; obviously these are easy changes to make and need only be done once per year.
Querstion - can we write the Select Time function with a reference to another module? EG: Select Time: Control Module.Prior Fiscal Year. I didn't write the sytax correctly but trust you follow my question Thanks
... View more
I have a client with a 4 level hierarchy for customers. For ease of wording, lets call them Channel (eg. retail, wholesale), Channel Region (eg. Retail USA, Retail Europe, Wholesale USA, etc), Channel Country (e.g. Wholesale UK & France etc rolling to Wholesale Europe), and then Customers (aggregating to each Channel country). They would like to delete all customers at the lowest level, but keep the existing list items under Channel Country.
Choosing Delele All Leaf Items selectes everything in the customer list except the very top level, so deletes far too much. Choosing Delete Descendents provides two essentially two options: (i) if I don't choose anything from the left side of the screen, then it would delete everything; or (ii) I can select one by one the 2nd lowest level elements to delete which puts say all the Wholesale UK customers AND Wholesale UK in the delete list - but since I want to keep the level Wholesale UK, I select that to keep.
Question is this - how can one select ALL of the lowest level items only in a composite or mult level hierarchy?
... View more