Forum Discussion

kakouchtim's avatar
kakouchtim
New Contributor III
3 years ago

Returning Value of a parameter in a XFBR

Hi OneStreamers,   I am trying to build an XFBR which I will link to a CV Column, that will either "True" or "False" Depending on the value of a parameter.   However I am finding trouble retu...
Cubeview
Dashboards
  • db_pdx's avatar
    db_pdx
    3 years ago

    Hi kakouchtim: try passing in the parameter to the BR rather than using the BRApi functions.

    For example:

    If args.FunctionName.XFEqualsIgnoreCase("CheckScnForVisibleColumn") Then

    Dim ScnParamName As String = args.NameValuePairs.XFGetValue("MyParam")

    ....business logic that checks ScnParamName against a predicate and returns True / False

    Usage would be:

    XFBR(Your_BR_Name, CheckScnForVisibleColumn, MyParam=[|!3_cm_param_S_SelectFC!|])

    This assumes usage in an XFBR String Business Rule, but that sounds like what you are after.  Hope this helps!

    -db

db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

Hi kakouchtim: try passing in the parameter to the BR rather than using the BRApi functions.

For example:

If args.FunctionName.XFEqualsIgnoreCase("CheckScnForVisibleColumn") Then

Dim ScnParamName As String = args.NameValuePairs.XFGetValue("MyParam")

....business logic that checks ScnParamName against a predicate and returns True / False

Usage would be:

XFBR(Your_BR_Name, CheckScnForVisibleColumn, MyParam=[|!3_cm_param_S_SelectFC!|])

This assumes usage in an XFBR String Business Rule, but that sounds like what you are after.  Hope this helps!

-db