Audit Trail for Calculated amounts
I currently have a UD8 that pulls the current timestamp anytime a user updates an intersection and it works just fine. The issue I am having is that when I run a calculation to push an amount to an intersection, there is no audit trail for that. Is there a table where this calculated audit information is stored? I haven't been able to find anything and I would think that OneStream should be able to track the audit trail of calculated members.
I assume the DM job is triggering a Custom Calculate. The behaviour you describe is by design. Custom Calculate works outside of the DUCS, targeting specific slices of data, so it doesn't generate auditing traces at the same level of detail of DUCS operations.
This said, you can address this in two ways:
- Set the "Use Detailed Logging" option to True on the DM Step. This will report in Task Activity all DUs touched by the job. The DM Step configuration is audited, so you can certify what the step looked like at any point in time. Note: if you're looking at things via SQL, Task Activity lives in the Framework database (not Applicatlion).
- If that is not enough, you can do your own logging in the Custom Calc rule. Changes to the rule are audited, so you can certify what the rule looked like at any point in time.
This difference in auditing trace is one of the reasons to consider when deciding whether to use Custom Calculations or Member Formulas. We discuss it in training material, we should probably make it a bit clearer in documentation.
- Set the "Use Detailed Logging" option to True on the DM Step. This will report in Task Activity all DUs touched by the job. The DM Step configuration is audited, so you can certify what the step looked like at any point in time. Note: if you're looking at things via SQL, Task Activity lives in the Framework database (not Applicatlion).
