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

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

Restrictions between two UDs dimensions ?

Hi,   Is it possible to define restrictions for input in a cube view between two UDs dimensions ? In order to "guide" the user in their input, I would like to define a restriction between UD4 a...
Metadata
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago

Hi Sergey

You can use this from a financial business rule:

 

Case Is = FinanceFunctionType.ConditionalInput
	If (api.Pov.Flow.Name.XFEqualsIgnoreCase("BegBal") Or api.Pov.Flow.Name.XFEqualsIgnoreCase("Movement") Or api.Pov.Flow.Name.XFEqualsIgnoreCase("Change")) And (api.Pov.Origin.Name.XFEqualsIgnoreCase("BeforeAdj") Or api.Pov.Origin.Name.XFEqualsIgnoreCase("Forms")) Then
		Return ConditionalInputResultType.NoInput
	Else
		Return ConditionalInputResultType.Default
	End If