Forum Discussion

Davy's avatar
Davy
Contributor
3 years ago

Use BusinessRule.DashboardStringFunction XFBR string rules to extract text out of V#Annotations?

Happy Labor Day!! How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations? We ...
Cubeview
XFBR
  • ChristianW's avatar
    ChristianW
    3 years ago

    DataCellInfoUsingMemberScript doesn't have a DataCellAnnotation property, you need to go down one more step and select the DataCellEx property first:

    BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCellAnnotation

     

    And for a consistent result, you should specify the full POV to avoid problems.

Davy's avatar
Davy
Contributor
3 years ago

 

Thanks. Based on your telling me that XFBR rules are resolved before retrieving datacells, that would mean that I would not use this code as I need to know the cell's POV before I execute :
BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCellAnnotation

As I need to pass it the cell's full POV.