Wednesday, April 27, 2011 0 comments

BI Publisher: XDOXSLT:IS_NUMERIC Not Handling Negative Numbers

We have an inbuilt function IS_NUMERIC in BI Publisher template builder.  This function is mainly used to validate whether a given value is a numeric value or not. Based on that, this function will return either TRUE or FALSE.


Thursday, April 14, 2011 2 comments

BI Publisher: Handling NULL XML Value

There will be three possible scenarios for the value of an element in a XML data, 

1. XML tag value present in the XML data, and it has a value which is not NULL
for ex:
<PO_NUMBER>123</PO_NUMBER>

Suppose you want to give some condition to check not null similar to the one we give in PL/SQL as,
IF value IS NOT NULL THEN
---
---
END IF;
BI Publisher syntax for this is,