Custom Analytical Queries in SAP S/4HANA: A Comprehensive Guide
For Analytics Specialists
Introduction
Custom Analytical Queries (App ID: F1572) is a transactional SAP Fiori app designed to empower analytics specialists with the ability to create, modify, and manage analytical queries directly in the SAP S/4HANA system. Built exclusively for the HANA database, this app provides seamless integration into the SAP Fiori Launchpad, enabling efficient query design and data analysis across devices such as desktops and tablets.
Product Features
- Ease of Query Design:
- Create and manage custom queries effortlessly through an intuitive SAP Fiori user interface.
- Advanced Analytics:
- Leverage HANA’s in-memory computing capabilities for high-speed data aggregation and real-time insights.
- Cross-Device Compatibility:
- Optimized for desktops and tablets, ensuring flexibility in usage.
- Role-Based Access:
- Ensures data security and governance through predefined roles like SAP_BR_ANALYTICS_SPECIALIST.
- Extensibility:
- Adapt and extend the app using SAPUI5 Adaptation Projects or SAPUI5 Extension Projects.
Implementation Information
Required Back-End Product
- SAP S/4HANA 2023, Support Package Stack 01 (Release: 02/2024)
Application Type
- Transactional
- Delivered as part of the SAP Fiori (SAPUI5) framework.
Prerequisite Components
Front-End Components
- SAP Fiori for SAP S/4HANA 2023
- Software Component: UIBAS001 758 SP 0000
Back-End Components
- SAP S/4HANA 2023
- Software Components: S4CORE 108 SP 0001, SAP_BASIS 758 SP 0001
Configuration
To enable the Custom Analytical Queries app, both front-end and back-end configurations must be performed. The following steps summarize the setup process:
SAPUI5 Application Activation
Activate the ICF nodes for the required SAPUI5 components:
| SAPUI5 Application | Technical Name | ICF Node Path |
|---|---|---|
| ANA_QDESIGN_MAN | Query Designer Manage | /sap/bc/ui5_ui5/sap/ana_qdesign_man |
| NW_APS_ATO_LIB | Reuse Library | /sap/bc/ui5_ui5/sap/nw_aps_ato_lib |
| NW_APS_EXTINV | External Invocation | /sap/bc/ui5_ui5/sap/nw_aps_extinv |
OData Services Activation
Activate the following OData services:
| OData Service | Version | Software Component Version | Authorization Role |
|---|---|---|---|
| ANA_QUERY_DESIGNER | 0001 | SAP_BASIS 758 | - |
| DATEFUNCTION | 0001 | S4CORE 108 | - |
SAP Fiori Launchpad Configuration
Ensure the following configurations are made to enable the app in the SAP Fiori Launchpad:
App Launcher Titles
- Title: Custom Analytical Queries
Target Mappings
| Semantic Object | Semantic Action | Parameters |
|---|---|---|
| AnalyticQuery | create | (DataView=)&(sap-fiori-id=F1572)&(SourceQuery=) |
| AnalyticQuery | manage | (ReadOnly=)&(sap-fiori-id=F1572)&(Name=) |
Catalogs and Roles
| Type | Technical Name | Description |
|---|---|---|
| Technical Catalog | SAP_BASIS_TCR_T | SAP Application Services: Fiori Apps |
| Business Catalog | SAP_BW_BC_AQD | Analytics - Query Design |
| Business Role | SAP_BR_ANALYTICS_SPECIALIST | Analytics Specialist |
Extensibility
SAPUI5 Adaptation Projects
Adapt the app UI without modifying the source code using SAPUI5 Adaptation Projects.
SAPUI5 Extension Projects
Extend functionality by creating SAPUI5 Extension Projects, such as adding new fields or customizing existing ones. Use SAP Guided Answers for step-by-step guidance.
Related Apps
- Query Browser (Fiori App): Browse available analytical queries.
- View Browser: Access and manage available views.
Important SAP Notes
| System | Note Number | Description |
|---|---|---|
| Front-End Server | 3336823 | Release Information: SAP Fiori for SAP S/4HANA 2023 |
| Back-End Server | 3421172 | Release Information: SAP S/4HANA 2023 |
For additional information, refer to the SAP Support Portal.
Conclusion
The Custom Analytical Queries app is an indispensable tool for analytics specialists, enabling them to design, analyze, and manage data efficiently within SAP S/4HANA. With its robust capabilities and integration with the SAP Fiori framework, it simplifies complex analytical processes, delivering actionable insights across the enterprise.
Start leveraging this app today to transform your organization's analytics capabilities!
No comments:
Post a Comment