BI Publisher (MOSC)

MOSC Banner

Need to compare multiple fields in BI Report output

edited Apr 15, 2014 12:00PM in BI Publisher (MOSC) 4 commentsAnswered

We have a requirement like that depend on output of multiple fields a column output need to be evaluated. Please find the use cases below.
 
Field Name: Compliant
1. If if SOURCESTATUS=ADSTATUS then 'Yes' 
2. if (xdoxslt:date_diff('d',DISABLED_DATE, REVOKE_NOTI_DATE, $_XDOLOCALE, 'America/Los_Angeles')) > 2 then 'No'. That is if difference between Disabled and Revoke noti Note is greater than 2 the Compliant field is No.
 
We are able to get the value(difference between dates) by using the condition <?xdoxslt:date_diff('d',DISABLED_DATE, REVOKE_NOTI_DATE, $_XDOLOCALE, 'America/Los_Angeles')?>.
 
But when we are using this condition along with xdofx condition to evalute multiple condions then it is not working. Please find the condition we are using below and let us how to evaluate multiple conditions to display in output

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center