change or build new sql-statement in BI-Publisher
Posted: Thu Jan 15, 2009 6:10 am
Hello, i'm a newbie to BI Publisher in Oracle Apps R12. I've downloaded the BI-Publisher Desktop Version which gets integrated in Word. My question is now, is it possible to change the select statement inside this Desktop-Version? I've tried to use one report in OA with XML-output then use the BI-Publisher Desktop integrator and to load the xml-file to make some layout for a report.
But what is if i want to use a new report from the scratch with new select statements. Do i have to use Oracle Reports for this and make the output as xml or is there a more smoother way to change the select statements without using Oracle Reports and without using the BI-Publisher Enterprise Edition. Thanks a lot - i would be appreciate to get some help. Regards Thomas
But what is if i want to use a new report from the scratch with new select statements. Do i have to use Oracle Reports for this and make the output as xml or is there a more smoother way to change the select statements without using Oracle Reports and without using the BI-Publisher Enterprise Edition. Thanks a lot - i would be appreciate to get some help. Regards Thomas