We help IT Professionals succeed at work.

SAP BI  4.1 - Can't add variable to report in WEBI - IES 10060

Medium Priority
127 Views
Last Modified: 2019-06-14
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)
   ////////////////////////////

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]

Thanks in advance.

'Breeze
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
I generally use the other syntax for the if

=If(IsNull([First_Field]) ;[Second_Field] ;[First_Field])

You could try

=If(isNull([First_Field])) Then [Second_Field] Else [First_Field]

mlmcc

Author

Commented:
@Mike McCraken

Thanks, but the issue occurs with any function that expects parameters inside parenthesis, such as isNull().

If I try:  

 =If(IsNull([First_Field]) ;[Second_Field] ;[First_Field])

Open in new window


This just moves the pointer of the error to position 4 - right where the open parenthesis is after "If".

It is as if it can't see any parenthesis.

'Breeze
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Try

=If isNull([First_Field]) = 1 Then [Second_Field] Else [First_Field]

It works in Webi 4.2 as you are trying to use it.

mlmcc
This appears to be a product issue with no resolution as there is no support contract and the company will not patch/upgrade.  I am closing this as resolved.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.