Comments on BIPgirl.com: What Are Subtemplates?

I can't see this logo in the output format type fi...

2010-02-02T00:44:07.846-05:00

I can't see this logo in the output format type file(XSL, HTML, RTF), Only in PDF output format file type getting generate this logo from subtemplate, please clarify why it is coming like and how to get in all output formats

Who knows where to download XRumer 5.0 Palladium? ...

2009-11-14T14:27:39.581-05:00

Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!

Hi, In the EBS environment we need to create repo...

2009-08-19T14:15:20.345-04:00

Hi,

In the EBS environment we need to create report header sub template. We create template and sub template the same like you suggested and it work fine. But when we create a dynamics logo that depended on business logics function, the logo did not appear. For that purpose we create a sub template connected to data definition with data template that brings the proper logo file name.

Can you please resolve this?
Thanks
Ad

Hi BIGirl, The Blog posted on the runtime paramete...

2009-03-14T03:46:02.655-04:00

Hi BIGirl,

The Blog posted on the runtime parameters is excellent. I have an issue here in using the param@begin concept for printing the paramter values. This is failing when the runtime parameter value consists of an apostrophe character in the value string (Ex: Teacher's, Girl's etc...). Could you please suggest how to overcome this apostrophe characters in printing the value.

Your help is highly appreciated. Thanks in Advance.

in import for subtemplate, i dont want to hardcode...

2009-01-30T11:57:48.545-05:00

in import for subtemplate, i dont want to hardcode the path. I want to specify relative path. example:
1. my subtemplates are in XMLP/Reports/subtemplates/header1.rtf
2. report rtf's in XMLP/Report/Report1/test.rtf

how to use relative path in the test.rtf to refer header1.rtf

This is in BI pulblisher 10.1.3.4

Hi BIGirl,Can you use the import:file syntax to im...

2008-03-25T18:19:53.826-04:00

Hi BIGirl,

Can you use the import:file syntax to import a file that is specific in one of the value of the report's xml item tag? If so, how can this be accomplish.

I think your syntax of passing parameters is not c...

2008-03-14T09:01:21.511-04:00

I think your syntax of passing parameters is not correct for this example. In the subtemplate you are referencing <?P_DATE?> which is the xml tag in the input file and is resolved automatically. You can test it by removing the with-param from the example2.rtf param from ex2_subtemplate. It will still bring the correct value.
In order to really make it work, you need to define a local param value in template as follows. XMLP syntax in my version generates incorrectly with no ending tag. Therefore you need to use xsl syntax in a word field.
<xsl:param name="P_DATE" />
Change <?P_DATE?> to <?$P_DATE?>
and in example.rtf do this.change <?with-param:P_DATE;$P_DATE?>
to
<?with-param:P_DATE;P_DATE?>
Now you have correctly parameterized the sub template. If your input file does not contain P_DATE tag, then also it will work. You need to change the name in the calling template to appropriate tag.
If you have the same xml tag in all your reports, you really do not need parameter. In your sub template you can reference that tag directly and makes your sub template specific for that input xml file.

Hi again,Yes, I have posted a question in the foru...

2008-02-04T03:46:58.120-05:00

Hi again,

Yes, I have posted a question in the forum, but it hasn't been answered despite many views. I've searched a great deal on the subject, but haven't found an answer, so I guess relative paths aren't supported. So I hardcoded a workaround in java, which changes paths in the xsl runtime. If you find a better solution, please be kind to let me know.

Hi Kim, I haven't tried this out using relative p...

2008-02-02T23:44:58.518-05:00

Hi Kim,
I haven't tried this out using relative paths yet. Have you posted any questions about this to the BIP forum yet?

- BIPgirl

Hi BIPGirl,First off, thanks for a great guide. It...

2008-01-30T08:41:59.650-05:00

Hi BIPGirl,

First off, thanks for a great guide. It was very helpful. I have one question though, is it possible to use relative paths instead of absolute paths when writing your import statement in a template?

Thanks in advance

Kim

Hi again Manju, I am not sure about the differenc...

2007-12-21T23:24:41.801-05:00

Hi again Manju,
I am not sure about the difference between the standalone and EBS versions. I would suggest to post your question on the Oracle BI Publisher forum at: http://forums.oracle.com/forums/forum.jspa?forumID=245

Happy Holidays to you as well!

Hey BIPGirl,Actually I am using standalone BI Publ...

2007-12-21T19:31:19.214-05:00

Hey BIPGirl,
Actually I am using standalone BI Publisher (OBIEE 10.1.3.2). I dont see the template manager there. Is there any way to find out what is equivalent of the import command in BIP?
Happy Holidays and a Merry XMas and Happy New Year
Thanks,
Manju

Hi Manju, I have documentation from the Oracle de...

2007-12-21T16:17:20.767-05:00

Hi Manju,
I have documentation from the Oracle developers guide that should help you. In my blog I haven't posted about using BIP in the Apps yet, so I was only showing how to use the subtemplate in Template Builder. That is why I am saying to put the local path to the subtemplate into the primary template.

Using a subtemplate consists of four steps:
1. Create the RTF subtemplate file

2. Register the subtemplate in the Template Manager. To define it as a
subtemplate, select Subtemplate = YES.

3. Enter the import syntax in the calling or "primary" template to import the subtemplate. The import syntax tells the XML Publisher engine where to find the subtemplate RTF in the Template Manager. This syntax may be entered anywhere in the template prior to the call-template syntax:
import:xdo://APPCODE.TEMPLATE_CODE.lang.TERR

- APPCODE is the Application code you assigned to the subtemplate in the Template Manager. (EX. AR)
-TEMPLATE_CODE is the template Code you assigned to the subtemplate
-lang is the two-letter ISO 639 language code9(EX. en)
-TERR is the two-letter ISO 3166 country code (EX. US)

4. Enter the call-template syntax in the primary template in the position that you want the subtemplate contents to render.

I hope this helps you out!

Hey BIPGirl,Thanks for the prompt reply.To answer ...

2007-12-21T11:59:49.430-05:00

Hey BIPGirl,
Thanks for the prompt reply.
To answer your question,yes, the import:file statement is correct - I just copied from your example and changed the path to point to my local template.
The thing is - I am adding this template to an already working and published template for a report. So when I add the import:file and call statements to the published template and update it, Word gives me no error.
But when I try to view the report on the BI server, it errors out without giving me any details.
My questions to you are:
1.How is the published template able to recognize the sub-template when the path is hard coded to my local machine?
2.If the path is not to be pointing to my local machine, then where should I place my sub-template?

If you can let me know how, I can send you my published template(inside which I am calling the sub-template), the sub-template and a picture of how the end report should look like.
Thanks,
Manju

Hi Manju : Are you sure that the "import:file" sta...

2007-12-21T09:33:23.743-05:00

Hi Manju : Are you sure that the "import:file" statement to your subtemplate is correct and in the body of the template, not the header section? Without seeing the template I can't be 100% sure as to what is happening. What error are you getting? - BIPgirl

Hey BIPGirl,I was searching for how to add a Repor...

2007-12-20T16:19:49.606-05:00

Hey BIPGirl,
I was searching for how to add a Report header and came across your blog. Couple of questions - but before that let me explain the scenario to you:
I have a query bringing in the data. I have a template in place. Now I want add a report header(prints on the first page of the report) to the template. I tried what you suggested (created a sub template with the static image and static text - saved it as rtf - called it in my report template) - but when the updated the layout, on next view the BIP errored out.
can you please help me out?
Thanks,
Manju

Hey Bipgirl! Keep the good work... great blog so f...

2007-12-14T12:24:21.232-05:00

Hey Bipgirl! Keep the good work... great blog so far!
GP

Awesome.. a curly wurly! Thanks so much.

2007-12-13T09:49:22.487-05:00

Awesome.. a curly wurly! Thanks so much.

Heya BIPGirlExcellent stuff as usual.You are now a...

2007-12-13T00:24:09.712-05:00

Heya BIPGirl
Excellent stuff as usual.
You are now at the top of the list of BIP Rollers at BIP grand central. You win a curly wurly and a Pork Pie from England. I bet you're pleased :0)