Saving calculated Cube View data for Confirmation Rules
We have a lot of Cube Views and most of them have multiple validations some of which are quite complex.
We also want to use Confirmation Rules to check that these Cube View validations have been cleared. The prospect of duplicating the Cube View validations in Confirmation Rules is not pleasant so we are looking for alternatives. We were thinking of adding a summary validation to every Cube View in the same place and then (somehow) saving that single value to an account with a split on UD6 for the Cube View. That would mean the Confirmation Rules are very simple to write. The question is can you save a value calculated on a Cube View to the Cube? The FormsEventHandler only references data that has been input (happy to be corrected on that). Suggestions on how to do this or a completely different approach are very welcome.
Thanks