Export Angle to Microsoft Excel

To export an Angle to Microsoft Excel

Click Add new datastore.
Select Export Angle to Microsoft Excel.
Click OK.
The Create datastore window appears.
Enter the Datastore name.
Select the Save To location. This can be a local folder, AWS S3, a network drive, or SharePoint. Depending on your choice, you are presented with different settings:
1. If you select Local Folder or Network Drive Location:
  Output Folder: Your input depends on the output location type.
  Local Folder: Enter the output folder for the export file. Note that the specified location must be a full file path on the Application Server. Make sure to choose a secure location.
  The expected format is <drive letter>:\<output folder>
  UNC Path: Enter the UNC (Universal Naming Convention) path of your network drive.
  The expected format is \\<machine name>\<share name>\<output folder>
  Username: Optionally, enter the account name of the network drive user.
  Password: Optionally, enter the password of the network drive user.
2. If you select AWS S3:
  S3 Region: Enter the S3 region where your S3 bucket is located.
  S3 Bucket: Enter the name of the S3 bucket where the data will be stored.
  Upload Folder: Specify the upload folder name. Your file will be uploaded to this folder. If it does not exist yet, the folder will be created in the specified S3 bucket.
  AWS Access Key: Enter the Access Key ID of the user.
  AWS Secret Key: Enter the Secret Access Key of the user.
3. If you select SharePoint:
  SharePoint Site Url: Enter the home page URL of your SharePoint site.
  The expected format is https://<companyname>.sharepoint.com/sites/<sitename>
  Site Subfolder: Enter the subfolder name. Your file will be uploaded to this subfolder, which is created under the Shared documents folder on SharePoint.
  Username: Enter the username of the SharePoint user. This user should be excluded from multi-factor authentication and should have Add,View, and Edit permissions on the SharePoint site.
  Password: Enter the password of the SharePoint user.
Click Test connection to test if the location is available.
Note
Note that you can choose to leave the following settings empty and instead enter their specifications in Automation tasks when you schedule the execution.
Insert model timestamp - Specify in which column the model timestamp should be inserted. Use '1' to select the first column, '2' to select the second column, and so forth. Select 'None' if no model timestamp column is required.
Header format - Select a format for the column headers:
- No header - When No header is selected, no column header is shown, only raw data.
- Id - When Id is selected, the IDs of the fields will be used as column headers. This option is most useful when the output file is used for further automatic processing, like in databases or CSV.
- Short name - When the Short name is selected, it is shown in the column header.
- Long name - When the Long name is selected, it is shown in the column header.
Set format - Select a format for the set elements:
- Id - When Id is selected, the IDs of the set elements will be exported. This option is most useful when the output is used for further automatic processing, like in databases or CSV.
- Display - When Display is selected, the set elements in the export will be formatted as defined in the Angle Display. This means, 'short', 'short (long)' or 'long' column names will be used. This option is most useful when the output is used for direct interpretation, like in Excel or HTML format.
Max rows to export - When exporting data only the specified number of rows will be exported. If the result contains more rows, remaining rows will be skipped. Use value -1 to export all rows.
File name - Name of the file to write the Angle data to. Macros can be used to include the angle name, display name and/or timestamp.
Template file name - Name of the Excel template file. The specified template file will be used as a basis to export the data to. Templates can include basic formatting and coloring definitions.
Sheet name - Select which Excel template to use for this export. If you select Use default, the template that is set as the default Excel template in this Display will be used. If that default Excel template is set to Use default, the Angles for SAP default template will be used. You can select a different Excel template from the list if you do not want to use the default. The specified template file will be used as a basis for the data export.
You can also select a Process Automation Pack template here. Process Automation Pack templates are indicated by the icon. The included and related SAP processes are displayed under the drop-down list.
Note
If a template has been removed from the system but not from the automation task, it may still be part of the drop-down list. A warning will be displayed if you select it.
Templates can include Process Automation Pack functions, basic formatting, coloring definitions, and macros.
Macros can be used to include the Angle name, Display name, and/or timestamp. See How to work with macros for an overview of the available macros.
Include Tech info - When selecting this option, the tech_info details will be included in the output file.
Add Angle summary - When selecting this option, the Angle summary will be included in the output file.
Add Angle definition - When selecting this option, the Angle definition will be included in the output file.
Click Save.

Angles for SAP IT Management Console

Export Angle to Microsoft Excel

Note

Note

Search results