SAC Scripting – Part 2: Shadow Tables 1.    General In this detailed exploration, we contrast the efficiency of accessing dimension values through Input Control and a shadow table in scripting environments. We previously introduced array manipulation and now extend our focus to performance aspects of data retrieval. The shadow table, designed as a dedicated storage for…

Continue Reading

„Replace Model“ Feature in SAP Analytics Cloud with SAP BW Live Model In the rapidly evolving world of data analytics, the agility to update and modify data sources directly within ongoing projects is crucial. SAP Analytics Cloud (SAC) offers a powerful feature known as „Replace Model,“ which allows users to swap out the underlying data…

Continue Reading

How to authorize for BPC Planning in SAC 1. General  When you want to plan with BPC Planning in SAC to BW, the authorization is set-up in three parts:  1. BPC Roles and authorizations  2. BPC Web Client (Data Access Profiles)  3. SAC set-up for planning and update access In the following document, the best…

Continue Reading

SAC Scripting – Part 1: Array Handling 1     General In the ever-evolving landscape of business intelligence, SAP Analytics Cloud (SAC) stands out as a robust tool empowering organizations to make informed decisions through intuitive analytics and compelling visualizations. While SAC offers a user-friendly interface for building dashboards, there are instances where scripting become crucial to…

Continue Reading

Data Flows – The Python Script Operator and why you should avoid it  When using SAP Datasphere to transform data for persistence, the Data Flow provides the necessary functionality. We recently compared various basic transformation tasks using different modeling approaches. Therefore, we tried four different approaches to implement a certain logic:  1. Modelling with the…

Continue Reading

ZPARTNER @ DSAG TT 2024  Wir waren auch dieses Jahr wieder bei den DSAG-Technologietagen vertreten. Besonders hat uns natürlich die SAP Analytics Agenda interessiert. Aber auch Hamburg hat, abgesehen vom Wetter 😉 , viel zu bieten. Was nehmen wir also mit?  Künstliche Intelligenz  Beeindruckend waren die praktischen Anwendungsfälle zur Künstlichen Intelligenz. In den Vorträgen wurde…

Continue Reading

Planning Architecture with and without SAP Business Warehouse (BW) Introduction Several customers are currently reconsidering their planning architectures. If you are one of those, this blog might be interesting for you. Let’s start with some building blocks you will find in almost every planning application: In case a Business Warehouse is already established for reporting…

Continue Reading

CDC data extraction Lessons Learned, Tips & Tricks – Part 3 Introduction  This blog series is about warnings and error messages that you may encounter with using CDC delta even though pretty good documentation, and how to work around them. We share these experiences with you to save your valuable time. In Part 1 of this…

Continue Reading

CDC data extraction Lessons Learned, Tips & Tricks – Part 2  Introduction  This blog series is about warnings and error messages that you may encounter with using CDC delta even though pretty good documentation, and how to work around them.   In part 1 of the series we looked at a warning you might run into…

Continue Reading

CDC data extraction Lessons Learned, Tips & Tricks – Part 1 Introduction Change Data Capture (CDC) delta extraction is actually quite simple, and there are already some good blogs out there explaining it pretty good. However, in practical project work with our customers, we have come across one or the other warning or error message…

Continue Reading