Copy BW Web Templates

[Former Member]

Hi BW experts,

After processing an upgrade to BW 7.0 on our TST system, we wish to copy all the exist web templates in the system.

The copy operation purpose is to save a copy of all reports, in case the migration process (running for the reports which will be open in the new BEx tools) will fail.

Does someone can provide me the functionality which should be taken for the web templates copy operation?

Thanks in advance,

Shani Bashkin

P.S. - The required copy functionality should work for all the web templates in the system at once (I know the "save as..." option in the WAD, but it's a sisyphean work)

[Former Member · Accepted solution]

While you do the Web template migration to 2004s there will not be any changes to the existing templates, there will be new templates created in the system as part of the migration process.

Also you can do the migration for template several times, this is different from the query migration process.

Thanks.

[Former Member · Accepted solution]

Hi Deepu,

I just want to make sure that I understood you:

I know that while the migration to 2004s the web templates won't change, but as far a I know these web templates will be migrated (each one separatedly) in the first time I'll open them in the WAD.

According to you there will be "new template created in the system as part of the migration process"

Are these new templates copy of the "old" (templates before the migration) ones?

What are the name of the new templates? (How can I find them?)

Also, I forgot to ask about the queries and the views:

Should I copy the queries and views to?

Do you happen to know a functionality for doing this?

What is the query migration process ?

What is the difference between the web template migration and the query migration?

I'm sorry for all those questions, but I really need some help in this issue...!

Thanks in Advance,

Shani Bashkin.

[Karol-K · Accepted solution]

Hello,

Deepu is right. Old Web Templates will be not affected by the migration.

In general, there are different migrations:

1. Queries.

-> once you open & save a query in new Query Designer, the query will be migrated (including all reusable elements!)

2. Workbooks -> like queries

3. Web Templates.

This is complete different. Due to the source change (old templates were HTML, new are XHTML) the migration path can be executed more times, because we have separate tables for new templats. There are two programs in backend for template editing (RS_TEMPLATE_MAINTAIN & RS_TEMPLATE_MAINTAN_70).

You can migrate the template in Web Application Designer, but old template will be only used in "read only" mode. even if you save the template under the same dam, it will be created in new table and DO NOT overwrite the old one.

Hope this explains you the migration of templates.

Best regards, Karol

SAP NetWeaver BI, Development

[Karol-K · Accepted solution]

short addition.

template migration is separate task in WAD -> Tools -> Migration Tool.

You cannot open old templates directly in new WAD.

[Former Member · Accepted solution]

Migration of web templates -

832713 - Migration of Web templates from BW 3.x to Netweaver

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Thank you Deepu and Karol,

This is exactly the answer I looked for.

[Former Member]

You can mass copy the template with

Program - RS_TEMPLATE_MASS_ALTER_70 nw2004s

Prgoram - RS_TEMPLATE_MASS_ALTER 3.x

<b>Step 1: Backup</b>

a) To do this, execute the RS_TEMPLATE_MASS_ALTER_70 report.

b) First, select the quantity of the templates to be edited in the "Input" area.

c) Leave the "Filter" area empty.

d) In the "Operation" area, select the "no operation, just up/download)" radio button.

e) In addition, select the "Save to Filesystem" area as the "Output Destination", specify a path under which you want the sources to be saved. Note that the path must end with a path separator (on Windows: this is '\')!

f) Execute the report, confirm the selection and the subsequent list with "Execute operation on selection" in each case.

g) The sources of the selected templates or Reusable Web items are written to the file system. This can be your backup.

<b>Step 2: Manipulation and download</b>

a) Then, execute the report again.

b) In the input template, select the same objects as for the download.

c) The filter area remains empty.

d) In the "Operation" area, select the "XSLT transformation" radio button, specify the name of the XSLT transformation in the first field, and enter any possible parameters (usually none).

e) In the "Output Destination" area, enter "Save to Filesystem" and a path name (that also must end with '\'). The path name must be different from the one specified before, otherwise your backup will be overwritten.

f) Execute the report and confirm the warnings in each case.

<b>Step 3: Check the result</b>

a) Now check the sources of the downloaded and manipulated templates and reusable Web items in the file system.

b) Compare with the backup-sources in the other directory

You may wish to check the OSS below -

Note 710112 - BW Web template mass maintenance

Program RS_TEMPLATE_MAINTAIN can be used for single template copy.

As a part of sanity check you might want to try it out in SBOX or Dev for ramifications if any ..

Hope it Helps

Chetan

@CP..

[Former Member]

Hi Chetan,

Thank you for you answer, but still I don't understand something:

What's the difference between the Backup operation and the Download operation?

Why do I need to execute both operations?

Also the backup operation copies the web templates into a different area in the file system, and in my case I would like to copy the web templates to the same area for the source web templates, and rename these backup web templates while the backup operation. Is there a way to perform this "backup" which I described here?

Thanks in advance,

Shani Bashkin

[Former Member]

Well there is a database copy scenario ;however will let SAP to throw some light on the same.

<b>Some more insights -</b>

http://help.sap.com/saphelp_nw04s/helpdata/en/b3/7d2a41b108f523e10000000a155106/content.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0901c9bb-0601-0010-49ab-c1770c52...

Hope it Helps

Chetan

@CP..