SAP Analytics Cloud Create
On this Page
Overview
The SAP Analytics Cloud Create Snap is a Write type Snap that is useful in appending records into a fact table for the specified model in the SAP Analytics Cloud instance using incoming documents from upstream Snaps. You can select if the incoming records are appended to the fact table or the fact table's records are deleted and the new records added. The Snap supports batching with a minimum of 1 document per batch.
The output fields will be in string format so any processing on the output data must be done keeping this in mind, alternatively you may convert the output string into the appropriate data-type for your processing needs.
The Snap accepts document input and generates a document output so upstream and downstream Snaps can be those that generate/accept document output/input.
If an error is encountered, the failed records are shown in the error view, and successful records in the output view.
Fact table - Append Vs Upsert
Two Snaps in this Snap Pack are currently used for adding data into a fact table: SAP Analytics Cloud Create and SAP Analytics Cloud Upsert. The SAP Analytics Cloud Create enables you to append records into an existing fact table (append/clean and append) whereas the SAP Analytics Cloud Upsert Snap enables you to update records in an existing table or insert a new record.
Prerequisites
A valid SAP Analytics Cloud account with appropriate read and write access.
Configuring Accounts
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring SAP Analytics Cloud Accounts for information on setting up this type of account.
Configuring Views
Input | This Snap has exactly one document input view. |
|---|---|
| Output | This Snap has exactly one document output view. |
| Error | This Snap has at most one document error view and produces zero or more documents in the view. |
Limitations and Known Issues
Currently, the Snap only supports operations on fact tables.
Modes
- Ultra Pipelines: Works in Ultra Pipelines.
Snap Settings
| Label | Required. The name for the Snap. Modify this to be more specific, especially if there are more than one of the same Snap in the pipeline. |
|---|---|
| Request type | The SAP Analytics Cloud object on which to perform the operation. Currently, the Snap offers only one option: Fact table. Default value: Fact table |
| Model ID | Required. The ID of the target model corresponding to the fact table. This is a suggestible field and the Snap suggests IDs of all the models based on the account settings.. Default value: [None] |
| Batch size | Number of documents to be processed per batch. The smallest value that can be specified here is 1. The output is segregated per batch. Leave it blank to process without batching. Default value: [None] |
| Operation | The type of operation to be performed on the fact table. Select one of the following options as required:
Default value: APPEND |
Snap execution | Select one of the three modes in which the Snap executes. Available options are:
|
Examples
Appending Records in Fact Table
The pipeline below shows how some incoming documents can be inserted into the fact table for a selected model:
Input data is provided as a JSON document from the JSON Generator Snap, the screenshot below shows the input records:
The Mapper Snap is used to map the objects in the input records with the dimensions and measures in the target model. The SAP Analytics Cloud Create Snap is configured as shown below:
Batch size is 2 and the Operation is APPEND so the input records are appended to the fact table likewise - in three batches where the first two batches have two records each and the last batch has one record. A preview of the output from the Snap is as shown in the screenshot below:
In this example if the Operation is CLEAN_AND_APPEND instead of APPEND, then the output preview will show the number of records that were deleted along with the number of records inserted. The exported pipeline is available in the Downloads section below.
Downloads
See Also
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.