cancel
Showing results for 
Search instead for 
Did you mean: 

Question in WAD

Former Member
0 Kudos

Its regaridng EXPORT command in WAD. I have a template A with all web items. I used a pushbutton

and assigned EXPORT commmand in XLS format. In the EXPORT command properties, we have a property Internal Display -->Web Template to choose the web template so that we can see A data in the selected template format.

Now when I leave this Web Template Parameter as default ( which means EXPORT is using same template A itself as the Excel Export template), and after running A report and click on the Export Pushbutton, I get a popup to Open/Save/Cancel the XLS document and the data is displayed in excel sheet which is fine.

But when I choose a template of my own (say Template B) in the EXPORT command property, then im not getting any

popup for Open/Save/Cancel and the data is opening up in a web page with excel format. I dont understand why its different! I want to open the exported data in a excel sheet not in web page in excel format.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Go throught this note

Note 990626 - NW 2004s BI Web system does not apply export parameters

Santosh

Former Member
0 Kudos

We are already in SP 19. SO this correction is already in place. Any more please.

Former Member
0 Kudos

any valuable inputs !

Former Member
0 Kudos

Hi

You can try modifying the 0ANALYSIS_PATTERN as per ur requirement the export to excel button in this template would work as per the requirement you mentioned.

Rajesh

Former Member
0 Kudos

I save as 0ANALYSIS_PATTERN and did the test. If I leave the Web Template parameter default in the EXPORT

command, then I get a pop up for Save/Open/Cancel and dats is shown up in XLS sheet.

but if I select 0ANALYSIS_PATTERN_EXPORT as the web template in the Web Template parameter of the

EXPORT command, then after I click on EXPORT button, its not showing any pop up

and also displaying the data in a web page in excel format.Web page address is ending with 'sap.ip.bi.web.portal.integration.launcher'.

Former Member
0 Kudos

Hi

Please replace the export to excel code with below piece of code in to the XHTML TAB of your web template

<bi:BUTTON type="COMPOSITE" index="2" >

<bi:CAPTION >

<bi:text program="SAPLRRSV" key="748" />

</bi:CAPTION>

<bi:TOOLTIP >

<bi:text program="SAPLRRSV" key="748" />

</bi:TOOLTIP>

</bi:ACTION type="CHOICE" value="INSTRUCTION" >

<bi:INSTRUCTION >

<bi:EXPORT >

<bi:TEMPLATE value="0ANALYSIS_PATTERN_EXPORT" text="Analysis Pattern Export" /> </bi:EXPORT>

</bi:INSTRUCTION>

</bi:ACTION>

</bi:BUTTON>

Assing Points if helpfull.

Rajesh

Former Member
0 Kudos

Its still not swhowing me the pop up for Open/Save/Cancel!

Former Member
0 Kudos

Hi

We are using BEx Patch 500 and Support package 18 . When i create web template using 0ANALYSIS_PATTERN as the template i am able to get the export to excel property as you are expecting (OPEN/SAVE/ option popuup comes) . If you are using some other patch then u can try upgrading your patch to 500 or 600.

Rajesh

Former Member
0 Kudos

Hi,

Which template did you use for Excel export in your template! Did you leave it default! If we it leave it default, even im getting the open/save/cancel pop-up. But try using 0ANALYSIS_PATTERN_EXPORT as the excel export template in your 0ANALYSIS_PATTERN web reprot and let me know if you get open/save/cancel pop up.

Answers (1)

Answers (1)

former_member241911
Participant
0 Kudos

Hi Rahul,

if you use an export template like 0ANALYSIS_PATTERN_EXPORT or your own one in the dialog you will NOT get the open/save/cancel dialog.

The dialog comes up only when leaving it default.

As a solution you could add yout web items to the web items list in the dialog instead using am export template (as done in 0analysis_pattern).

If you need the list of items often you should but the button with the export parameters in a template on its own and add this template to your other templates.

best regards

ARNE