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

JK12's avatar
JK12
New Contributor II
1 year 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
1 year 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
    1 year ago

    Thanks Terasa

    We managed to solve this

    • jayaleck's avatar
      jayaleck
      New Contributor III
      1 year ago

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

      • JK12's avatar
        JK12
        New Contributor II
        1 year 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