Forum Discussion

sfilho's avatar
sfilho
New Contributor III
3 years ago

Getting the Workflow Profile Text1 attribute value using BRApi

I am trying to get the Text1 field value using a Business Rule and put this value in a cube view that is being used as Form. Does anyone have done this before? Is it possible to get the Text1 value...
Admin
  • sfilho's avatar
    sfilho
    3 years ago

    Yes it is ugly. I could not get this piece working properly:

    GetAttributeValue(BRApi.Finance.Scenario.GetScenarioType(si, args.SubstVarSourceInfo.WFScenario.DimId).Id

    I replaced with:

     

    Dim wfClusterPK As WorkflowUnitClusterPk = si.WorkflowClusterPk

     

    Dim wfScenarioTypeID As Integer = BRApi.Workflow.General.GetScenarioTypeId(si, wfClusterPK)

     

    Dim sVarStep2 As String = BRApi.Workflow.Metadata.GetParent(si, args.SubstVarSourceInfo.WorkflowUnitInfo.ProfileName).GetAttributeValue(wfScenarioTypeID, 18000)

    It brought the correctly value.

     

JackLacava's avatar
JackLacava
Honored Contributor

If you're in a XFBR, you should be able to use args.SubstVarSourceInfo.WFText1 .

 

MarkHoughton's avatar
MarkHoughton
Contributor
2 years ago

Hi,

A few months ago I used the recommended solution of 

Dim wfClusterPK As WorkflowUnitClusterPk = si.WorkflowClusterPk

Dim wfScenarioTypeID As Integer = BRApi.Workflow.General.GetScenarioTypeId(si, wfClusterPK)

Dim sVarStep2 As String =BRApi.Workflow.Metadata.GetParent(si,args.SubstVarSourceInfo.WorkflowUnitInfo.ProfileName).GetAttributeValue(wfScenarioTypeID, 18000)

And it gave me the correct value I was expecting, however, since moving to 7.3.1.14520 my cubeview BR will not retrieve the Text1 value from the WF.profile. Has the "18000" id value changed in this version ?

If I hard code my WF.Text1 value into my BR I can still pull my UD4.Textx value which alters by time and scenario, so unusual that the WF profile Text1 is not pulling through. I have tried recompiling as well as amending the variable names to see if that will kick it back to life.

Any thoughts as to why it will not work ?

Regards

Mark

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Have a look in the backend database tables, they should tell you if that ID has changed.

    • MarkHoughton's avatar
      MarkHoughton
      Contributor
      2 years ago

      Hi,

      I tried searching through the database tables, but could not find anything relevant. I don't understand why the code worked to retrieve the Text1 field value a few months ago but does not work now. Nothing has changed in the Business Rule. 

       

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        2 years ago

        Table WorkflowProfileAttributes will have the relevant properties, search for the value in the ProfileAttributeValue field to identify the record and then use the related AttributeIndex value.

  • MarkHoughton's avatar
    MarkHoughton
    Contributor
    2 years ago

    Finally got this to work when I realised that it will not drive from "CubeViews" unless the particular sub profile of the entity profile has been activated in the workflow. I was "trying" to test it by running it from the cubeview menu and couldn't understand why sometimes it displayed my results when i changed entity and sometimes did not. Eventually I realised that it needed in this case to have the BS Analysis profile activated otherwise it would not retrieve the value in the Text1 field.