Podcast
Questions and Answers
What is required to consume data exposed as perspectives and views?
What is required to consume data exposed as perspectives and views?
What happens to the data you can consume if data access controls have been applied?
What happens to the data you can consume if data access controls have been applied?
What is the purpose of the standard DW Consumer role template?
What is the purpose of the standard DW Consumer role template?
What is required to consume data exposed by SAP Datasphere in SAP Analytics Cloud?
What is required to consume data exposed by SAP Datasphere in SAP Analytics Cloud?
Signup and view all the answers
What is deprecated in SAP Analytics Cloud and Microsoft Excel via live connection?
What is deprecated in SAP Analytics Cloud and Microsoft Excel via live connection?
Signup and view all the answers
What is the primary requirement for consuming data from an SAP Datasphere view in SAP Analytics Cloud?
What is the primary requirement for consuming data from an SAP Datasphere view in SAP Analytics Cloud?
Signup and view all the answers
What is the purpose of the DW Consumer role template in SAP Datasphere?
What is the purpose of the DW Consumer role template in SAP Datasphere?
Signup and view all the answers
What is the purpose of the SAP Analysis for Microsoft Office add-in?
What is the purpose of the SAP Analysis for Microsoft Office add-in?
Signup and view all the answers
What is required to obtain an OAuth client in SAP Datasphere?
What is required to obtain an OAuth client in SAP Datasphere?
Signup and view all the answers
What is the effect of data access controls on data consumption in SAP Analytics Cloud?
What is the effect of data access controls on data consumption in SAP Analytics Cloud?
Signup and view all the answers
What is the minimum privilege required to access the space or spaces exposing the data?
What is the minimum privilege required to access the space or spaces exposing the data?
Signup and view all the answers
What is the purpose of creating an OData services connection in SAP Analytics Cloud?
What is the purpose of creating an OData services connection in SAP Analytics Cloud?
Signup and view all the answers
What role is required to create a Cloud Data Integration connection in SAP Datasphere?
What role is required to create a Cloud Data Integration connection in SAP Datasphere?
Signup and view all the answers
What is required to configure in your SAP Datasphere tenant before creating a Cloud Data Integration connection?
What is required to configure in your SAP Datasphere tenant before creating a Cloud Data Integration connection?
Signup and view all the answers
How can you load SAP Analytics Cloud planning data to SAP Datasphere?
How can you load SAP Analytics Cloud planning data to SAP Datasphere?
Signup and view all the answers
What is the purpose of the Client ID in the OAuth client defined in your SAP Analytics Cloud tenant?
What is the purpose of the Client ID in the OAuth client defined in your SAP Analytics Cloud tenant?
Signup and view all the answers
What additional information is required for data flows?
What additional information is required for data flows?
Signup and view all the answers
Where can you find more information about using the SAC Data Export API with SAP Datasphere and Data Intelligence?
Where can you find more information about using the SAC Data Export API with SAP Datasphere and Data Intelligence?
Signup and view all the answers
What is required to consume views exposed in SAP Datasphere?
What is required to consume views exposed in SAP Datasphere?
Signup and view all the answers
What is the purpose of the standard DW Consumer role template?
What is the purpose of the standard DW Consumer role template?
Signup and view all the answers
What happens to the data you can consume if data access controls have been applied?
What happens to the data you can consume if data access controls have been applied?
Signup and view all the answers
What is required to obtain an OAuth client in SAP Datasphere?
What is required to obtain an OAuth client in SAP Datasphere?
Signup and view all the answers
What is the purpose of the OAuth2SAMLBearer Principal Propagation Flow?
What is the purpose of the OAuth2SAMLBearer Principal Propagation Flow?
Signup and view all the answers
What do users need to do when using the OAuth2SAMLBearer Principal Propagation Flow?
What do users need to do when using the OAuth2SAMLBearer Principal Propagation Flow?
Signup and view all the answers
Where is the API specification for SAP Datasphere OData API available?
Where is the API specification for SAP Datasphere OData API available?
Signup and view all the answers
What is required to access the SAP Datasphere OData API?
What is required to access the SAP Datasphere OData API?
Signup and view all the answers
What is the purpose of the standard DW Consumer role template?
What is the purpose of the standard DW Consumer role template?
Signup and view all the answers
How are data access controls applied?
How are data access controls applied?
Signup and view all the answers
What is required to obtain an OAuth client?
What is required to obtain an OAuth client?
Signup and view all the answers
What is the purpose of the OAuth client?
What is the purpose of the OAuth client?
Signup and view all the answers
Study Notes
Connecting to SAP Datasphere via OData Service
- Connect to SAP Datasphere via OData service using a custom connector or blank query to consume exposed views.
- Required role: Added to a scoped role granting access to the space or spaces exposing the data, with Space Files (-R------) privilege.
- Standard DW Consumer role template is for users who only consume data and do not need to connect to SAP Datasphere itself.
OAuth Client Parameters
- Obtain parameters for an OAuth client defined in SAP Datasphere tenant:
- Client ID
- Secret
- Authorization URL
- Token URL
- Users must manually authenticate against the IDP in OAuth2SAMLBearer Principal Propagation Flow.
Creating SAP Datasphere Cloud Data Integration Connection
- Create a Cloud Data Integration connection in SAP Datasphere to load data from an SAP Analytics Cloud planning model.
- Required role: SAP Analytics Cloud user with BI Content Creator role or equivalent privileges.
- Obtain OAuth client parameters for an OAuth client defined in SAP Analytics Cloud tenant.
- Ensure Data Provisioning Agent is configured in SAP Datasphere tenant.
Loading SAP Analytics Cloud Planning Data to SAP Datasphere
- Load SAP Analytics Cloud planning data to SAP Datasphere via Cloud Data Integration connection.
- Can be loaded as a remote table or via a data flow.
Consuming Data Exposed by SAP Datasphere
- Create an SAP Analytics Cloud OData services connection to an SAP Datasphere view.
- Required role: Added to a scoped role granting access to the space or spaces exposing the data, with Space Files (-R------) privilege.
- Obtain OAuth client parameters for an OAuth client defined in SAP Datasphere tenant.
- Only parts of OData v4 specification operations described in the document are supported.
- Batch and write operations are not supported.
Accessing SAP Datasphere OData API
- Access the SAP Datasphere OData API to consume data exposed by SAP Datasphere.
- Required role: Added to a scoped role granting access to the space or spaces exposing the data, with Space Files (-R------) privilege.
- Obtain OAuth client parameters for an OAuth client defined in SAP Datasphere tenant.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn how to consume data from SAP Analytics Cloud in Microsoft Excel using the add-in. Discover the requirements and limitations of data consumption, including perspectives, views, and analytic models. Test your knowledge of SAP Analytics Cloud and Microsoft Excel integration.
