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
=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
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.