The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Constraints Reports by Dimension
Are there any out box reports available to show constraints by dimension?
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
4 Replies
- T_Kress
OneStream Employee
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.
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.
sameburnHi 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
