Skip to main content
A
Anonymous
May 23, 2020

Metadata Dashboard for Relationship Changes?

  • May 23, 2020
  • 2 replies
  • 0 views
Originally posted by Darryl Gerrow

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.

2 replies

A
Anonymous
June 2, 2020
Originally posted by Chad Fortman

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

A
Anonymous
June 2, 2020
Originally posted by Darryl Gerrow

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.

Terms & ConditionsAccessibility statement