Forum Discussion

JK12's avatar
JK12
New Contributor II
10 months ago

Locking of Text Commentary

Hi Everyone, Does anyone know whether it is possible to Lock V#Annotation for input? Any assistance will be appreciated Thank you!
annotations
T_Kress's avatar
T_Kress
Icon for OneStream Employee rankOneStream Employee
10 months ago

One option would be to use a conditional no input Finance BR and attach that to your cube(s).  The no input rule would appear as follows:

Case Is = FinanceFunctionType.ConditionalInput
						
						If api.Pov.View.Name.XFEqualsIgnoreCase("Annotation")
							Return ConditionalInputResultType.NoInput
						End If
						
						Return ConditionalInputResultType.Default

This would make all V# Annotation intersections Read Only, always.  If you need to only have them be Read Only in certain instances, you can include other IF statements.

JK12's avatar
JK12
New Contributor II
10 months ago

Thanks Terasa

We managed to solve this

  • jayaleck's avatar
    jayaleck
    New Contributor III
    4 months ago

    What was the solution, if you don't mind sharing?

    • JK12's avatar
      JK12
      New Contributor II
      4 months ago

      We used a no input rule.

      Dim ProfileInfo As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk)
      Dim wfPk As New WorkflowUnitClusterPk(ProfileInfo.ProfileKey, si.WorkflowClusterPk.ScenarioKey, si.WorkflowClusterPk.TimeKey)
      Dim wfStatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, wfPk, False)
       
      If wfStatus.Locked And api.Pov.View.Name = "Annotation"
      Return ConditionalInputResultType.NoInput
      End if