Connect Analysis for Office to SAP SAC Data model and Analyze

Connecting Analysis for Office to an SAP Analytics Cloud (SAC) data model is a straightforward process. Here's a step-by-step guide:

Prerequisites:

• Compatible Analysis for Office Version: Ensure you have a version of Analysis for Office that supports SAC connections (e.g., 2.8 or later).
• SAC Tenant URL: You'll need the URL for your SAC tenant (e.g., https://<LANDSCAPEID>.sapbusinessobjects.cloud).
• SAC Credentials: Have your SAC username and password ready.

Steps:

1. Open Analysis for Office and Start a New Workbook:
   • Launch Analysis for Office.
   • Click "New" to create a new workbook.
2. Choose SAC as Your Data Source:
   • In the Data Source window, select "SAP Analytics Cloud" as the platform.
3. Enter Your SAC Tenant URL:
   • Provide the "friendly" URL for your SAC tenant in the format mentioned earlier.
   • Add a description if you like.
   • Click "OK."
4. Log in to SAC:
   • You'll be prompted to log in to your SAC account using your credentials.
5. Select Your Data Model:
   • After logging in, a dialog box will display the available SAC data models.
   • You can search for your model or browse through the list.
   • Select the model you want to connect to and click "OK."
6. Start Analyzing Your Data:
   • The selected data model will be loaded into Analysis for Office.
   • You can now use the familiar Analysis for Office features to explore, analyze, and visualize your data.

Important Notes:

• "Friendly" URL: Make sure you use the correct format for your SAC tenant URL to avoid connection issues.
• Customize Analysis Options: If you don't see the option to select an SAC connection, you might need to enable it in the Analysis Options. Go to "File" -> "Analysis" -> "Customize Analysis" -> "Options." Under the "Platform" tab, select SAC as your preferred platform.
• Supported Data Models: Analysis for Office supports various SAC data models, including acquired data models and live data connections.

By following these steps, you can seamlessly connect Analysis for Office to your SAP SAC data models and leverage its powerful analytical capabilities.