Home » Fusion Middleware & Colab Suite » Business Intelligence » rtf optimization
rtf optimization [message #479512] Mon, 18 October 2010 02:18
Messages: 1
Registered: October 2010
Location: Hyderabad
Junior Member
I have a report Purchase price variance(XML) which has been running for hours and hours when I submitted it for a date range.

I have the below code in the rtf file for one field

<?if:xdoxslt:ifelse(((ancestor-or-self::*/P_ORDERBY) and ancestor-or-self::*/P_ORDERBY != ''),(ancestor-or-self::*/P_ORDERBY = 'BUYER'),false())='true'?><?value-of:C_BUYER_SUBTOTAL_DISP1?><?end if?>

Here the P_ORDERBY is the input parameter to the report.

<dataTemplate name="POXRCPPV" defaultPackage="PO_POXRCPPV_XMLP_PKG" version="1.0">
<property name="xml_tag_case" value="upper" />
<property name="scalable_mode" value="on" />
<property name="db_fetch_size" value="20" />
<property name="include_rowsettag" value="false"/>
<parameter name="P_ORDERBY" dataType="character"></parameter>

So Can I access the P_ORDERBY parameter directly like /POXRCPPV/P_ORDERBY in the above condition instead of ancestor-or-self::*/P_ORDERBY?????

Do I need to add any property to access the parameter value using the syntax /POXRCPPV/P_ORDERBY

Can any one please tell me is this syntax correct or not?
And will it make any improvement in the over all report performance??

Previous Topic: Unable to start presentation service
Next Topic: Oracle OLAP
Goto Forum:

Current Time: Tue Jan 19 07:02:11 CST 2021