Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Audit Trail cube will allow to check status of roundtrip across FIN Version, T Year-Month (we have issue with having two different dimension for time in roundtrip objects), FIN Company, FIN Consolidation Value Measure (by default we are loading data descending from ).

Status with numeric codes in ascending order, so we can calculate min and max within certain rollups to see if status codes are consistent. That means the code needs to be a measure rather than a dimension. We can use ConsolidatedMax and ConsolidatedMin functions to see both min and max status code values. If they are equal then we know status codes are consistent. A good prerequisite will be to have non-zero status codes so if min=0 we would know there are some nodes in un-initialized state. This would work nicely with ViewZeroOut. We need to have some free codes between each roundtrip step to allow adding new steps.

  • No labels