Refer to Oracle Reports parameter in Excel template — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Refer to Oracle Reports parameter in Excel template

Received Response
322
Views
4
Comments
User_U66J8
User_U66J8 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

Refer to Oracle Reports parameter in Excel template

Content

Hi All,

I have a concurrent program in R12 with XML type. My template is an Excel Template and i want to display the values of some of the parameters in that concurrent program. But, these parameters are not produced in the XML generated( i.e. there is no formula or SQL query for them into the Oracle Report and it is an Oracle Standard Report ( can't customize it)).

Is it possible to refer somehow to these parameters in Excel template?

I tried to put in XDO_METADATA a reference column like below:

XDO_?P_STAT_DATE_FROM?<?param@begin:P_STAT_DATE_FROM?>

... and then I just specified XDO_?P_STAT_DATE_FROM? in the column i want to see it but this displays nothing.

Any ideas if this is achievable without modifying the Oracle Report?

Regards,

Alex

Answers

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    I don't think it's doable without customizing the report.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    WHat is the oracle seeded report name?

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    Alex,

    per my knowledge all the standard reports will have something called a data definition, go to XML Publisher Administrator and verify the data template .. I have checked few standard report which has the parameters ...

    Other option is if your report does not include the parameters in the Data Template .. you can just modify the data template to include the parameters .. Hope this helps .

    YG

  • User_U66J8
    User_U66J8 Rank 4 - Community Specialist

    Hi All,

    The Standard Report is 'Bank Statement Detail Report'. Its output is 'TEXT'(that's why it doesn't have data template ) so we created a custom one with type XML so we can create a custom template(Excel).

    But we don't want to modify the RDF file for this report and we want to use the current executable.

    Issue is solved with a workaround. Currently it generates those parameters in the XML as where clauses e.g. <PARAM>AND date between 01-FEB-2017 and 02-FEB-2017<PARAM>/.

    The workaround is to extract the value from the parameter with Excel functions ( FIND, SUBSTITUTE, MID, etc). It's not easy to support going forward but it displays the desired output.

    Regards,

    Alex