Oracle Analytics Publisher

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

Use parameters to make the file path dynamic

Received Response
31
Views
6
Comments
Rank 2 - Community Beginner
edited Jan 24, 2025 8:06PM in Oracle Analytics Publisher

we have requirement in BI Publisher template to call template from External file in the folder mounted in BIP Server.

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

<?call-template: QFR_PR_TITLE?>

I have two parameter which would be passed to the Main BIP template

<?param@begin:FUND_ID;'000022'?>

<?param@begin:END_DATE;'202412'?>

the above parameters data should replace the appropriate data in the link /commentary_qfr_000022_202412.rtf

and based on this parameters , the link should dynamically call the file in the folder.

so if the i pass the parameter as

<?param@begin:FUND_ID;'000060'?> ,

<?param@begin:END_DATE;'202409'?>

the link should call -

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000060_202409.rtf?> at runtime

Any help on this is appreciated. Thank you

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    You can wrap the import with a conditional statement so you pull the file you want.

    Rgds,

    Kevin

  • Rank 2 - Community Beginner

    Thanks kevin. I am bit lost here. appreciate if you can give an example. commentary_test is my main template and it calls the <?call-template: QFR_PR_TITLE?> from commentary_qfr_000022_202412.rtf which is in the file system using

    <?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

    The file path needs to be dynamic based on the parameters pass to the main template.

  • Rank 6 - Analytics Lead

    You can use:

    <?if:whatever?>

    <?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

    <?end if?>

    Do this for each subtemplate.

    Rgds,

    Kevin

  • Rank 2 - Community Beginner
    edited Jan 27, 2025 3:26PM

    got it but there is problem. The files will be loaded every month and we want to automate that link in the template and I wouldn't know the name of the file it its uploaded to the shared folder. but I have parameters which user will supply on which file needs to called based on

    <?param@begin:FUND_ID;'000060'?> ,

    <?param@begin:END_DATE;'202409'?>

    so based on the Parameters, the import file name will change.

  • Rank 6 - Analytics Lead

    Depending upon the requirement, can you reuse file names rather than use new names each month?

    Rgds,

    Kevin

  • Rank 2 - Community Beginner

    We are currently reusing the file by replacing the info in the file. But the requirement got changed where they want to maintain the file and so they will get us new file every month with fund and date combination.

Welcome!

It looks like you're new here. Sign in or register to get started.