Part 3: Using Web Design API to export to CSV

Part 3: Using Web Design API to export to CSV

From the "Info" port of your BI Query Data service, drag and drop out a "Data Store" object.

Add the field "REPTNAME" to the Data Store Object.

Map the field "REPTNAME" from the info port to the data store.

Double click on the Output Table and choose "Edit" on the toolbar.

Specify this button as "Export to CSV", System Action=Hyperlink, and then click on Formula.

Specify this formula: 

"pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!
2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?
QUERY=" & STORE@REPTNAME &"&BI_COMMAND_1-BI_COMMAND_
TYPE=EXPORT&BI_COMMAND_1-EXPORT_FORMAT=
CSV&BI_COMMAND_1-ITEM_REF_LISTITEM_REF_1=
ANALYSIS&BI_COMMAND_1-null="


NOTE: This URL is for the Web Analyzer PCD Location if Visual Composer is on the same server as BI-Java. If it is not, see the section on Mapping External BI locations.

Choose OK.


NOTE: This will export the default view of the data service to a CSV. It will not keep filters or navigation states.

Deploy your model.

Run your iView and choose "Export to CSV".

Look at your exported CSV file.

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.


Visual Composer for xApp analysis

  Home: Introduction
  Part 1: Architecture of Visual Composer BI Kit
  Part 2: Using the native Visual Composer export data functionality
  Part 3: Using Web Design API to export to CSV
  Part 4: Using Web Design API to export to Excel
  Part 5: Using Web Design API to export to PDF
  Review: Conclusion and additional resources

This was first published in December 2006