Symptom
- It is not possible to configure a direct link that opens an SAC add-in report automatically.
- When clicking on an Excel SAC add-in file stored in an SAC folder, the file downloads to the local download folder instead of opening directly in Excel with the add-in activated.
- The SAC add-in requires manual activation within Excel after opening the file, and this step cannot be bypassed with a direct URL.
- Planned enhancement for direct launching of Excel files from SAC stories is scheduled for 2025Q1, but this refers to launching from the SAC interface, not via direct URLs.
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
- Attempt to configure a direct URL link to open an SAC add-in report automatically.
- Click on an Excel SAC add-in file stored in an SAC folder.
- Observe that the file downloads to the local download folder instead of opening directly in Excel with the add-in activated.
- Open the downloaded file manually in Excel and activate the SAC add-in.
Cause
- Current limitations in the SAC add-in for Excel prevent seamless URL-based opening of add-in reports.
Resolution
- Save the Excel SAC add-in workbook to a shared location, such as a network share or local storage.
- Navigate to the file location manually.
- Open the Excel file manually in the desktop application.
- Sign into SAC through the add-in interface.
- Refresh data as needed.
- Consider alternative approaches:
- Option 1: Create hyperlinks within SAC stories to external URLs or other SAC content. Use the "Show Hyperlinks in Table" option for clickable elements and configure external URL hyperlinks with parameter passing.
- Option 2: Use SAC Analytic Applications with scripting for advanced navigation. Implement `NavigationUtils.openUrl()` or `NavigationUtils.createStoryUrl()` for custom URL handling and build parameter passing between different models or stories.
- Option 3: Configure context-sensitive reports that can be called from other SAP applications. Use parameter mapping to pass relevant context data and implement URL-based navigation with proper parameter structure.
- Ensure authentication requirements are met:
- SAC add-in validates permissions based on SAC user roles and "Add-in Workbook" object permissions.
- Users need appropriate Read and Update permissions for add-in functionality.
- SSO configuration must be properly established between Excel and SAC tenant.
- Submit an enhancement request through SAP's Customer Influence platform if direct URL launching of SAC add-in reports is critical for the use case.
See Also
Refer to: KB0314582 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
Keywords
sac add-in, excel, direct link, sac report, sac folder, sac tenant, sac authentication, sac enhancement, sac analytic applications, sac scripting, sac hyperlinks, sac integration, sac navigation, sac permissions, sac sso, sac workbook, sac limitations, sac roadmap , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public