Does anyone know if there is a system Metadata Dashboard that will show me when relationships change in a dimension? I seem to only see the ones that show Insert/Change/Delete members, nothing about relationships.
Darryl,
There are audit tables (listed below) that house data pertaining to what changes have been made on the Relationship Properties tab of the Dimension Library. You could easily create a dashboard if looking at the audit table is insufficient. Attached are screenshots of the audit tables and audit records. I modified the Aggregation Weight of an account from 1 to 2 and then 2 to 1. Hope this helps.
These tables exist in the Application Database
Navigation: System tab of OneStream > Tools > Database > Application Database > Tables (scroll down)
AuditRelationship
AuditRelationshopProperty
Thanks, Chad.
What I wanted to share here also is that on the advice of Steve Booker, we downloaded the Marketplace solution "Application Reports" (RPTA) which also has a Relationship report, which I think will solve our question as well without needing to build a new dashboard.
