06-09-2022 09:40 AM - last edited on 05-03-2023 09:18 AM by JackLacava
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,
06-09-2022 10:30 AM - edited 06-09-2022 10:31 AM
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
06-09-2022 11:29 AM
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,