Restrictions between two UDs dimensions ?

Sergey
Contributor III

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,

2 REPLIES 2

ChristianW
Valued Contributor

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
Contributor III

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,