- OneStream Community
- Forums
- Reporting
- Metadata Dashboard for Relationship Changes?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Metadata Dashboard for Relationship Changes?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2020 02:14 PM
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.
- Labels:
-
Dashboards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-02-2020 07:48 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-02-2020 09:00 AM
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.
