Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Block Creation Advice

edited Nov 21, 2019 4:38PM in Planning 4 comments

Summary

Tested a number of different ways to create blocks and the least desirable - SET CREATENONMISSINGBLK - seems to be the only option.

Content

Hi, apologies if this has been asked before, however, in the below script for PBCS, which is quite straight forward, we have made it possible to either submit a driver to an assumption group, or to the base level location. If the base level location is empty, it will always go to the assumption group to get the driver to use.

All dimensions are sparse except for View (which includes "Periods"), Account and Period.

I am optimising rules at present and, as best practice suggests, SET CREATENONMISSINGBLK should never really be used due to the performance hit. Or at least, traditionally that has been the advice. However, in the context of below it seems, through my testing, the only command which will create the necessary blocks from within the script. Or maybe not. I feel like I have missed something. I am glad it works, but with SET CREATENONMISSINGBLK, however, is there a better alternative?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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