CA Service Management

Expand all | Collapse all

BOXI 4.1 - IES 10060 error in WEBI trying to create a variable with a function

Jump to Best Answer
  • 1.  BOXI 4.1 - IES 10060 error in WEBI trying to create a variable with a function

    Posted 06-06-2019 12:14 PM
    Edited by J W 07-05-2019 11:36 AM
    SAP BI 4.1 - WEBI
    This has one data source - a derived Universe for CA Service Desk Manager.

    I am trying to add a variable to a report.  This is to check if a field is null.  If it is, return one value; if not, return another.
    NOTE:  This issue occurs with ALL functions which have parenthesis - NOT just "isNull()".

    Steps to Reproduce:

    1.  Open WEBI.
    2.  Open an existing report or create a new one where results return at least two fields, one of which may have NULL values.
    3.  Create a new variable.(example)
    -- Name:  vFirstGroup
    -- Qualification:  Dimension
    -- Formula:
          =If isNull([First_Field]) Then [Second_Field] Else [First_Field]
    a.  Validate the formula.  Results:  The formula is correct.
    b.  Select OK to save the variable.  Results:  Error
        ///////////////////////////////////
    Web Intelligence
    There is no opening parenthesis after function "isNull" at position 11 (IES 10060)
       ////////////////////////////

    Screenshot of error message


    The on-line documentation for "IES 10060" says to add the missing parenthesis.  That is not the case here.

    This does not occur if creating a variable which does not include functions with parentheses.  For example, this works:
      = If [First_Field] = 0 Then [First_Field] Else [Second_Field]

    TIA,

    J.W.

    ------------------------------
    "No matter where you go, there you are." - TAoBB:AtED
    ------------------------------

    #cabiboxi #boxi4.1 #webintelligence #IES10060
    ​​​​


  • 2.  RE: BOXI 4.1 - IES 10060 error in WEBI trying to create a variable with a function
    Best Answer

    Posted 07-01-2019 04:19 PM
    There was no resolution for this.  The customer does not have a support contract.  This pushed report development out to SQL and Power BI until (or maybe even after) they upgrade to SDM 17.1 / CABI 6.3.

    ------------------------------
    "No matter where you go, there you are." - TAoBB:AtED
    ------------------------------