Writing to the Cube using Confirmation Rule?
Originally posted by James Kirkby Hello: I want to have a confirmation rule write a value to a single intersection (api.data.calculate) by either calling a finance business rule or writing the calculate directly into rule text. The rule loops thru base entities and certain accounts, then writes the value stored there to a single member; basically, a check to ensure that all base members foot to the top of a hierarchy in USD (We have had issues with this in the past, and now have historical data that doesn't foot in certain areas identified in our most recent conversion.) I don't want this to run on a member formula as it will significantly slow down consolidation on all other data units, and this really is a confirmation by nature; a data quality check. Our consultants suspect that this may be by design; that during the running of confirmation rule, the cubecan't get written to. PS - I can confirm the data calculate is in fact running as I'm writing the calc string to the error log; also that the intersection I'm writing to is in fact open for writing. Let me know your thoughts and thank you: James Kirkby
Customize answers to the certification questions
Hi all, Is it somehow possible to customize the answers to the certification questions? We would generally only want yes/no, but by default there is now a whole list of possible answers. We are looking for a way to limit this list. With kind regards, TimI want to return a warning if a user certifies phase 2 on a workflow without having certified phase 1 when using workflow channels
Originally posted by Tommy Sandi 3/10/2020 I want just to return a warning if a user certifies phase 2 on a workflow without having certified phase 1 when using workflow channels. I can stop the user from doing that with an event handler and a throw XFException but that would stop the certification process, while i'd rather give the warning but still complete the certification. I suggested the use of confirmation rules as a better alternative but the customer wants popups messages. I can also throw an error in a IsBeforeEvent=False, but still that would log as an error, while it is only a warning
