Forum Discussion

pranav46's avatar
pranav46
Contributor II
9 days ago

Constraints Reports by Dimension

Are there any out box reports available to show constraints by dimension?

Cube View
Dashboards
Reports
  • sameburn's avatar
    sameburn
    7 days ago

    Hi pranav46 

    I believe you can do this already using the Dimension Library in OneStream.  For example, navigate to Application -> Dimensions.  In Dimension Library.  Select the Dimension you want to check.  Select the Grid View tab and pass in (a) a Member Expansion for that Dimension e.g. A#AllAccounts.Base and (b) the Member properties you wish to review e.g. UD1-UD8 constraints using Grid Settings.  This will return a Grid View of what you want to report on (which can also be exported e.g. by right-clicking).  See below.

    Hope this helps?

    Sam

  • T_Kress's avatar
    T_Kress
    Contributor III
    9 days ago

    I am not aware of any reports under "Standard Application Reports" (RPTA) market place solution that show constraints.  Constraints are a read only property using an api:

     

    Dim mbr As Member = api.UD8.GetUD1ConstraintMemberForDimType(ud1MemberId, dimTypeForConstraintMember, varyByCubeTypeId)

    So you could probably create a dynamic U8 calculation to pull this through and display on a cube view or in a dashboard but I do not know of something existing already.

    • pranav46's avatar
      pranav46
      Contributor II
      9 days ago

      Yes, I have seen this as well and thought about it but have many constraints against dim so, might need to generate a dashboard or you mentioned cube view.
      I will wait for couple of days if someone does not respond then add this item to idea stream.

      • sameburn's avatar
        sameburn
        Contributor II
        7 days ago

        Hi pranav46 

        I believe you can do this already using the Dimension Library in OneStream.  For example, navigate to Application -> Dimensions.  In Dimension Library.  Select the Dimension you want to check.  Select the Grid View tab and pass in (a) a Member Expansion for that Dimension e.g. A#AllAccounts.Base and (b) the Member properties you wish to review e.g. UD1-UD8 constraints using Grid Settings.  This will return a Grid View of what you want to report on (which can also be exported e.g. by right-clicking).  See below.

        Hope this helps?

        Sam