Why you are using multiple choose conditions ? you can use simple if conditions after and before for each group. https://blogs.oracle.com/xmlpublisher/conditional-templates

You can achieve requirement with schedule Trigger concept https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM389 (creating scheduled trigger). This trigger is associated with sql query , if it returns rows then job will be executed else terminate , you can define sql query if new row is inserted…

please clear you requirement , You can leverage bi publisher section break in RTF template , Thanks

post question in OBIEE forum

creation of more than one report is possible using single data model. send me documents.

No not received. else use venkythota54@yahoo.com

Can you try to export to CSV and check rows ? Layout is RTF or EXCEL ?

Can you try to put g_1 and shipper outside the table g_1 with <?for-each-group@section:G_1;./CSO_NUM?> shipper <?end for-each-group?>

Hi , Unfortunately this can't be undone..except the case where you have a backup for catalog or those files.. also, to find who deleted the files you have to have Audit Enabled, otherwise cannot be seen ,BIP doesn't have a "recycle bin" directory. Also, there is no recovery option for deleted reports or data models. If you…

Can you detail your requirement what you are trying to achieve ? what i understood was that you have one data model and on top of that you have to create two separate reports ?

You want to create two separate reports using one data model ? one for shipmnetA and shipmentB. upload you xml and template ,along with output samples

send to venkythota54@gmail.com Its not possible for generating two pdf files from one report when running report Online. You need to use bursting concept to deliever multiple PDF's from single report. https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm

what is timezone of database where data is extracting ? also bi publisher installed time zone ?

If your source is sql then add directly at source level , select sysdate+x from dual , where X will be number of days to add.

share your template and xml , will help you out. Thanks

Is data source is of sql type ? then you can handle all these calculations at source level instead of Template level.

Try this <?for-each:DiscountTaken?> <?xdofx: if round(VALUE,-2)>VALUE then round(VALUE,2)+100 else round(VALUE,2) end if?> <?end for-each?>

Are you creating bip data model from analysis URL or from xmlpserver ? I mean are logging from analysis or xmlpserver? Try to change web browser .

Try this <?xdofx: if round(UNIT_COST,-2)<1 then '123' else '321' end if?> if not share you template and xml.

Can you post how you defined parameter in sql query? Generally To handle multiple values you have to use field_name in(:shipment_id) in sql query.