Part 3: Using Web Design API to export to CSV

Get inside Visual Composer and its functionality within NetWeaver and for composite applications.

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.


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 last published in December 2006

Dig Deeper on SAP development and programming languages

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close