Writing to the Cube using Confirmation Rule?
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 cube can'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