Question on nesting
I would say that you should abstract the logic into a flow chart of some sort
(diagrams.net is a great chrome addin - https://chrome.google.com/webstore/deta ... a?hl=en-GB)
no matter how simple or complex that may be. from that, you'll be able to identify the lowest level moving part and thus have a unit that you can (potentially) create and test in isolation.
now that BA has the ability to use preloaded (or dynamically loaded) csv files to interact with guardian, to a large extent, the need for Excel has gone away (if you have th ability/resource to create the application code required to load the csv's with the required data). what this means in real terms is that we can place a 25/75 split of the logic across BA/application code, thus any changes in logic at a core level MAY only require changes to be made to the code that poplutes the csv, thus leaving your BA rules intact and untouched.
that's the theory anyway
(diagrams.net is a great chrome addin - https://chrome.google.com/webstore/deta ... a?hl=en-GB)
no matter how simple or complex that may be. from that, you'll be able to identify the lowest level moving part and thus have a unit that you can (potentially) create and test in isolation.
now that BA has the ability to use preloaded (or dynamically loaded) csv files to interact with guardian, to a large extent, the need for Excel has gone away (if you have th ability/resource to create the application code required to load the csv's with the required data). what this means in real terms is that we can place a 25/75 split of the logic across BA/application code, thus any changes in logic at a core level MAY only require changes to be made to the code that poplutes the csv, thus leaving your BA rules intact and untouched.
that's the theory anyway