Connecting to CSV files with the CSV Connector
In Chapter 8, Dashboard Data Connectivity, we discussed a number of data connectivity options for dashboards in SAP BusinessObjects Dashboards. In addition to these standard data connections, Centigon Solutions has developed an add-on that allows us to use Comma Separated Value (CSV) files to grab data from. This recipe will give you a quick walkthrough of the features of this add-on.
Getting ready
Go to the Centigon Solutions website (http://www.centigonsolutions.com/) and browse for CSV Connector. Download the free trial and install it with the Add-On Manager. You also need a sample CSV file to use in this recipe.
How to do it...
- Open a new SAP BusinessObjects Dashboards file and go to the spreadsheet area. Enter the location of the CSV file in cell C1.
- Open the Data Manager and click on the Add button. Under Add-On connection, you will see the CSV Connector. Select it.
- Give this connection a name. Bind the CSV Data URL field to cell C1.
- Also, check...
