Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Use parameters to make the file path dynamic
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
Answers
-
You can wrap the import with a conditional statement so you pull the file you want.
Rgds,
Kevin
0 -
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.
0 -
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
0 -
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.
0 -
Depending upon the requirement, can you reuse file names rather than use new names each month?
Rgds,
Kevin
0 -
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.
0