SAP Analytics Cloud Read

Owned by Mohammed Iqbal
Last updated: Feb 11, 2021 by Siddharth Menon (Unlicensed)
4 min read

On this Page

Overview

The SAP Analytics Cloud Read Snap is a Read type Snap used for reading SAP Anaytics Cloud objects such as Model, Model dimensions, Dimension members, Public dimensions, Public dimension members, and Fact table. You can either read a specific model or all models associated with your account based on how the Snap is configured. 

The Snap accepts document input and output so Snaps that have document output/input can be used upstream/downstream. The Snap however does not require an upstream Snap. 

Prerequisites

A valid SAP Analytics Cloud account with appropriate read 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 at most one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.

Support

Known Issues

  • The output fields are in the 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. 


Snap Settings

LabelRequired. 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 to be read, this is a drop-down that lists all the objects that are supported by the SAP Analytics Cloud Snap Pack. The following options are available in the drop-down menu:

  • Models - Select this option to read only model data (model ID, name, and description)
  • Model dimensions - Select this option to read dimensions for a specified model ID
  • Dimension members - Select this option to read dimension members for a specified model ID and dimension ID
  • Fact table - Select this option to read the fact table for a specified model ID
  • Public dimension - Select this option to read public dimensions
  • Public dimension members - Select this option to read public dimension members for a specified public dimension

Default value: Models


Fact table - Output

Only three records will be shown in the Snap's outputs, for viewing all the records in the fact table check the SAP Analytics Cloud instance.

Model ID

Conditional. The model ID for the model in the SAP Analytics Cloud instance. This is a suggestible field and lists all the models present in the account.

Default value: [None]


  • This can be left blank if you wish to view all the models in your account.
  • This can be left blank when reading public dimensions or public dimension members.
  • This property is required when reading a specific model.
  • This property is required when reading model dimensions.
Dimension ID

Conditional. The dimension ID for the dimensions (public and otherwise) in the SAP Analytics Cloud instance. This is a suggestible field and lists out all the dimensions for a specific model.

Default value: [None]


  • This can be left blank if you wish to view all the dimensions in a specified model.
  • This can be left blank if you wish to view only model-level data.
  • This property is required when reading specific dimension, public dimension, and public dimension member(s)

Snap Execution

Select one of the three modes in which the Snap executes. Available options are:
  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.


Examples

SAP Analytics Cloud Read as a standalone Snap

The example pipeline below is a demonstration of how the SAP Analytics Cloud Read Snap can be used as a standalone Snap in the pipeline, this is helpful when you wish to see model-level, dimension-level, and member-level information for your account.

Based on the configuration of Request type, Model ID, and Dimension ID properties the Snap has a different output. Each combination and the corresponding output is demonstrated in the table below:

Request TypeModel IDDimension IDSnap Output
ModelsBlankNot applicable. Regardless of this being blank or configured the output is the same.

Details of all models in the account. Details like:

  • Model ID
  • Model Name
  • Model Description
ModelsModel IDNot applicable. Regardless of this being blank or configured the output is the same.

Details of the model whose model ID is specified. Details like:

  • Model Name
  • Model Description
  • Model Type
  • Created Time
  • Modified Time
  • Owner
Model dimensionsModel ID (Required)Blank

Details of all the dimensions in the model. Details like:

  • Dimension ID
  • Dimension Name
  • Dimension Pubic/Not Public
  • Dimension Description
  • Dimension Type
Model dimensionsModel ID (Required)Dimension ID
Details of the specified dimension in the model. Details like:
  • Dimension Name
  • Dimension ID
  • Dimension Description
  • Dimension Type
  • Default Properties
  • Owner
Dimension membersModel ID (Required)Dimension ID (Required)

Details of all the dimension members for the dimension specified. Details like:

  • Column data (ID, and Description)
  • Row data (ID value, and Description value)
  • Mapping data
Fact tableModel ID (Required)Not applicable

Three records of the fact table are shown in the output preview. This includes details like:

  • Mapping Data
    • Dimensions
    • Measures
  • Column Data
  • Row Data (members)
Public DimensionsNot applicable. Does not affect the output if one is provided.Blank

Details of all public dimensions in the account. Details like:

  • Public Dimension Name
  • Public Dimension ID
  • Public Dimension Description
Public DimensionsNot applicable. Does not affect the output if one is provided.Public Dimension ID

All details of the selected public dimension. Details like:

  • Public Dimension Name
  • Public Dimension ID
  • Public Dimension Description
  • Public Dimension Type
  • Default Properties
  • Owner
Public Dimension MembersNot applicable. Does not affect the output if one is provided.Public Dimension ID (Required)

All details of the members within the selected public dimension are provided

  • Mapping Data
    • Dimensions
    • Measures
  • Column Data
  • Row Data (members)

Exported pipeline is available in the Downloads section below.

Downloads

  File Modified

File SAC Read - Example - All Read Types.slp

May 04, 2018 by Siddharth Menon

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.