Posts

Exploring SAP Analytics Cloud: Scripting Features

Image
Exploring SAP Analytics Cloud: Scripting Features to Enhance Dashboards SAP Analytics Cloud (SAC) is a powerful tool that allows users to build interactive dashboards and reports. Beyond the drag-and-drop interface, SAC also offers scripting capabilities through Analytic Application that allow for more dynamic interactions and customization. Let’s explore how you can use scripting in SAC to enhance your dashboard. 1. Adding a Measure to a Widget (Bar Chart) You can programmatically add or change measures in a chart widget, which allows for dynamic customization of the data being displayed. Here's how you can add a measure to a bar chart using a script. In this example: Chart_1 is the ID of your bar chart widget. The getDataSource() method retrieves the chart’s data model. The new measure, "Gross Margin" , is added to the list and applied to the chart. 2. Changing a Dimension Programmatically Similarly, you can modify a dimension in a chart or table through scripting. T...
Post a Comment
Read more

SAP BI: Making a selection by using ABAP, AMDP, CDS View or Python from new finance S4 table "ACDOCA"

Image
Context: Comparative of using different techonologies to make a select from new "acdoca" table which contains all data related to FI posting documents. Also it will be provided a few examples to explore different ways to achieve this goal.  1. ABAP:  using new abap code as it's displayed here, defining a table at very moment when we're using at a local table "result", that happens by using @. 2. ABAP Managed Database Procedures (AMDP) : 2.1 Call AMDP in ABAP 3. CDS View:   abap perspective Eclipse or SAP Hana both work. 4. Python (with SAP HANA DB Connection)           Connection has to be established first.   Btw this article was partially written by AI ChatGPT4.0 If you've finished the page you're brave! :)  Thanks!!
Read more

SAP Business Technology Platform (BTP) offers tools such as...

Image
 SAP Business Technology Platform (BTP) offers a wide range of tools and services that can be classified into several categories: 1. Database & Data Management SAP HANA Cloud : A high-performance in-memory database that allows real-time data processing, analytics, and complex calculations. It's optimized for SAP applications but flexible enough for other use cases. SAP Data Intelligence : A tool to manage, integrate, and orchestrate data pipelines from various sources, supporting hybrid cloud and multi-cloud environments. SAP Master Data Governance : Ensures data consistency across different business units by providing a central framework for managing and distributing master data. 2. Analytics SAP Analytics Cloud (SAC) : A powerful, all-in-one platform for business intelligence (BI), augmented analytics, and financial planning, offering dashboards, reporting, and machine learning integration. SAP Data Warehouse Cloud : A data management and modeling service that provides a sing...
Location: Barcelona, Spain
Read more

SAP BI: Comparative among ABAP, SQL Script, Python or CDS View

Image
When it comes to performing, which is your first thought?  Totally agree depends on the target, it can be exploit by bex query or using python or just having a file to be presented. Anyways, as a simple performance analysis when executing a SELECT from a table in SAP HANA,  can vary depending on the language and technology used. Here's an overview of the options ABAP , SQL Script , Python , or   CDS Views —to help assess which one performs the best in different use cases. 1. SQL Script Performance : SQL Script is the most optimized for performing queries directly on SAP HANA . SQL Script allows you to write procedural SQL that executes on the HANA database server itself, leveraging HANA's in-memory capabilities. It’s specifically designed to take advantage of HANA’s parallel processing and data locality , which can result in significantly faster execution compared to other languages, especially for complex queries and large datasets. When to Use : SQL Script is ...
Location: Barcelona, Spain
Read more