on 11-04-2009 9:46 PM
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.
Hi
Go throught this note
Note 990626 - NW 2004s BI Web system does not apply export parameters
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'.
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
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.