Different type of xml tags in bi publisher

Not Null:


< ? if@column: G_MON1_QTY_MON1!='' ? >

If not null :

< ? xdoxslt:ifelse(UNIT_PRICE!='',UNIT_PRICE,0) ? >

If null then:

< ? xdoxslt:ifelse(UNIT_PRICE ='',UNIT_PRICE,0) ? >

< ? xdofx:if TOTAL_COST = '' then 0 end if ? >

< ? xdofx:if TOTAL_COST = '' then TOTAL_COST= 0 end if ? >

If with <  or   > process:

< ?xdofx:if ITEM_COST <10 else="" end="" if="" mith="" ohn="" then="">

write decode condition in xml tag

< ? xdofx:Decode(tag_name ,'',0,tag_name? >



For loop:

< ? for-each:G_1 ? >

< ? end for-each ? >

Percentage calculation:

< ? xdofx:if COL2=0 or COL2=  ' ' then '     ' else ((COL18-COL37) div COL37)  * 100 end if ? >


Above Percentage is calculated for tag's < ? COL1 ? >,< ? COL2 ? > and prior to calculation always check denominator in not null or 0.


Note: Always place all the tags in field  ,do not hardcode it on rtf as shown below.

Work around for editing presentation names in OBIEE 11g

We can not edit presentation names in latest versions of OBIEE (ex: 11.1.1.9). As a work around to this bug we can follow below steps to edit the names

Step 1:
Tools>Options...




Step 2:
In general tab , tick the check box 'Edit presentation names'