Hyperion Essbase creates a data block for every unique combination of the members of the sparse dimensions D and E providing that at least one data value exists for the combination. If you remember, the calculations above created 66, and 63, blocks for the one without the if and with the if, respectively. Remember, turning this on will go through ever possible block and if it needs to be created it will create it. You have a typo and the! That is a really long way to say, hey, thanks for sharing all this.
nest...