Forum Discussion

pranav46's avatar
pranav46
Contributor II
5 months ago
Solved

Constraints Reports by Dimension

Are there any out box reports available to show constraints by dimension?
Cube View
Dashboards
Reports
  • sameburn's avatar
    sameburn
    5 months 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

pranav46's avatar
pranav46
Contributor II
5 months 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 III
5 months 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

  • pranav46's avatar
    pranav46
    Contributor II
    5 months 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.