Forum Discussion

MitPower01's avatar
MitPower01
New Contributor II
8 days ago

Hierarchy Comparison Reports or Dashboards

Has anyone built a cube view, or more likely a dashboard, that can automatically compare the base level members of 2 or more hierarchies in a dimension to identify exceptions?  We do this manually now in Excel but was asked by the users to put this comparison in OneStream.

I thought this might be an application report, but I don't see anything close.  Also, we are currently on v7.4, so if there is a feature in the latest version please pass along.

Thanks!

 

Books
Cube View
Dashboards
Excel Add In
Reports

3 Replies

  • MitPower01's avatar
    MitPower01
    New Contributor II
    6 days ago

    Getting an error when loading, searching for solution now:

     

  • T_Kress's avatar
    T_Kress
    Valued Contributor
    7 days ago

    There is a great Solution Exchange tool which does just this!  It is called Hierarchy Validation Tool and can be found as shown below.  It is free to download and easy to set up and use.  I cannot live without it!