SAP Analytics Cloud Snap Pack

Owned by Mohammed Iqbal
Last updated: Mar 24, 2021 by Siddharth Menon (Unlicensed)
3 min read

On this Page

SAP Analytics Cloud Snap Pack enables you to connect to the SAP Analytics Cloud instance and perform CRUD operations in it.

These are the following Snaps in this Snap Pack:


Format of the output data

Currently, all output from the Snaps is in string format regardless of the original data type. 

Working with fact tables

  • 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.
  • Snap Output: The Snaps' output shows only three records for a fact table, to see all the records in a fact table check the SAP Analytics Cloud console.

SAP Analytics Cloud Objects Supported by the Snap Pack

The Snap Pack supports operations on the following objects in the SAP Analytics Cloud:

SAP Analytics Cloud ObjectSupported Operation

Models

Read

Model dimensions

Read

Dimension members

Read, Upsert, and Delete

Public dimensions

Read

Public dimension members

Read, and Upsert

Fact table

Create, Read, Upsert, and Delete

In this Section

In this release only the objects listed in the table above are supported. 

Prerequisites

The following are required in order to be able to use this Snap Pack:

  • SAP Analytics Cloud account with sufficient read and write access.

  • SnapLogic updated to the latest version.

Troubleshooting

Error MessageReasonResolution

Model ID is empty or null

The Model ID field is blank. Any operation on the SAP Analytics Cloud entities, including dimensions and members, requires the model ID since each dimension (and subsequently, each member) is linked with a model.Enter the target model ID. 

Dimension ID is empty or null

You have selected the dimension-related option in the Request type field and not provided the dimension ID. 

 Dimension-related request types in SAP Analytics Cloud Snaps

SAP Analytics Cloud Read

  • Model dimensions 
  • Dimension members 
  • Public dimension
  • Public dimension members 

SAP Analytics Cloud Upsert

  • Dimension members
  • Fact table
  • Public dimension members

SAP Analytics Cloud Delete

  • Dimension members
Enter the target dimension ID. 

An error occurred while executing the REST API call

Triggered by an IOException. It may be caused if the SAP Analytics Cloud Server is unable to process the request. Wait for some time and then execute the Pipeline again or verify that the server has enough memory. 

Error while executing batch

Triggered at the Snap-level in the SAP Analytics Cloud Create, SAP Analytics Cloud Upsert, and SAP Analytics Cloud Delete Snaps. Triggered when the batch size is more than the number of input records. This is also triggered when the Snap/Pipeline is aborted while executing a batch.Verify that the batch size is less than the total number of input records. If you are unsure of the number of input records, then configure the batch size as 1.

Error while retrieving the XCSFR token.

This is a 403 HTTP Forbidden response generated by the SAP Analytics Cloud instance. Triggered when SAP Analytics Cloud account that you are using does not have sufficient access privileges.Verify the account privileges with your SAP Analytics Cloud admin and procure the necessary privileges.

Validation errors occurred

The account information you have provided is incorrect.

Verify if the account details, such as Client ID or SAC Tenant URL, are correct.

Supported Version

This Snap Pack is tested against v2019.2.0.

Accounts

The SAP Analytics Cloud Snap Pack uses the following account types:

  • SAP Analytics Cloud OAuth2 Account

  • SAP Analytics Cloud OAuth2 Dynamic Account

For more information please refer to the Configuring SAP Analytics Cloud Accounts page.

See Also

Snap Pack History

 Click to view/expand

4.23 (main7430)

  • No updates made.

4.22 (main6403)

  • No updates made.

4.21 (snapsmrc542)

  • No updates made.

4.20 (snapsmrc535)

  • No updates made.

4.19 (snapsmrc528)

  • No updates made.

4.18 (snapsmrc523)

  • No updates made.

4.17 Patch ALL7402

  • Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 (snapsmrc515)

  • Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16 (snapsmrc508)

  • No updates made. Automatic rebuild with a platform release.

4.15 (snapsmrc500)

  • No updates made. Automatic rebuild with a platform release.

4.14 (snapsmrc490)

  • No updates made. Automatic rebuild with a platform release.

4.13  (snapsmrc486) 

  • New! Initial release of the Snap Pack. This includes SAP Analytics Cloud Create, SAP Analytics Cloud Read, SAP Analytics Cloud Upsert, and SAP Analytics Cloud Delete Snaps.

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.