The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
MarcusH
3 years agoValued Contributor
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 cle...
JackLacava
OneStream Employee
3 years agoI wouldn't store anything. Just set up your checks in Dynamic Calc accounts or UDs, so that those accounts will return 0 or 1 when the check is passed or not; bring the accounts in your cube view (replacing your previous stuff), then use GetDataCell in your Confirmation Rules to simply retrieve that value. If the name of the account or UD is self explanatory (e.g. PositiveBalanceCheck), simply returning that as description of the error should be enough of a clue to figure out what should be corrected.
In this way you've written your check once, in one place, and reference it from both CV and ConfRules.
Related Content
- 2 years ago
- 8 months ago