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]
TIA,
J.W.
------------------------------
"No matter where you go, there you are." - TAoBB:AtED
------------------------------
#cabiboxi #boxi4.1 #webintelligence #IES10060