Working With Data Sources - SAP Dashboards

How to import data from data sources?

You need to import data from different data sources to create data models. You can use the following functions −
  • Data connections
  • Embedded spreadsheets
  • BEX and Universe queries

Embedded Spreadsheets

To link your components to cells in the spreadsheet in the data model. It allows different features that are supported by Excel files. Some functions like Macros, Conditional Formatting and Function Formulas, etc. doesn’t supported by excel files.
Here are some ways to insert data in the spreadsheets.
  • You can copy paste the data from other excel spreadsheets to the embedded spreadsheets.
  • You can import a spreadsheet from excel.
  • You can manually enter the data in a spreadsheet.
  • You can link query objects from a BEX or a Universe query to cells in an embedded spreadsheet.
First create a performance optimized structure to create a data model using embedded spreadsheets. Analyse with different points to ensure that the structure is good. Some of these points are −
  • Use Excel functions with small data sets.
  • Use only supported Excel functions.
  • You can use color, labels and borders to find out cells or range in spreadsheet.
  • In case you have a large volume of data in the spreadsheet, you can create multiple tabs.

How to Set Preference for Embedded Spreadsheets?

To set preference for Embedded Spreadsheets, go to File → Preferences as shown in the following screenshot.
set_embedded_spreadsheet
On the left side, go to Excel Options and you can select the following options −
  • Live Office Compatibility – To work with Live Office enabled spreadsheet within dashboards.
  • Maximum Number of Rows – To select the maximum number of rows in a spreadsheet that can be bound to components.
  • Optimize Spreadsheet – To optimize the spreadsheet at run time. This allows to calculate the formulas and save them in SWF, hence the model performs better at run time.
  • Ignore Excel Formula Errors – To ignore the errors in the spreadsheet.
excel_options

How to Import an Excel Spreadsheet?

If you want to import an excel spreadsheet to a new spreadsheet , you can use an existing spreadsheet that will be used as a source for a new data model.
To import excel spreadsheet to go to Data → Import as shown in the following screenshot.
data_import
Click Yes as shown in the following screenshot to appear in the dialog box.
dialogue_box
Select the spreadsheet you want to import and click Open.

To Generate SWF Using an External Spreadsheet

You can generate SWF using external spreadsheet structure that can be exported using an external spreadsheet.
For this go to File → Export Settings as shown in the following screenshot.
export_settings
Select another Excel File → Go to folder and select the spreadsheet to use. Click OK.
use_excel_file
Now go to File → Export → Flash (SWF).
This opens a Save As Dialog Box. Enter the path and name of SWF File → OK.
path_and_name_of_swf_file

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP Dashboards Topics