Forum Discussion

pranav46's avatar
pranav46
Contributor II
25 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
    24 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

sameburn's avatar
sameburn
Contributor II

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

pranav46's avatar
pranav46
Contributor II
19 days ago

Yes I am familiar with this but was looking for one report shows all constraint. I would use this time being and have item added to IdeaStream.