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 and UD5, so that only specific UD5 elements (in columns) could be editable based on the UD4 (in rows).

I don't see any restrictions on UDs elements in the datamodel, so what would be the best way to achieve this ?

 

Regards,

Metadata

2 Replies

  • 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

     

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

    Hi Christian !

    This is very nice, thanks !

    I was also testing whith the Cube "Data Cell Conditional Accesses" which also seem to achieve the same result.

     

    Best regards,