Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 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
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    3 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
    Contributor III
    3 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,