Blogs tagged automated refresh

Post Copy Automation (PCA) has been part of SAP Landscape Enterprise Edition (LaMa) for many years. SAP Landscape Management Cloud (LaMa Cloud) was launched in 2021 as another product in the family. The two products compliment each other and can be... Read More »

Introduction This blog will cover the scenario of creating a custom provisioning process for database refresh in SAP LaMa. A while back I did a similar blog about custom refresh of SAP ASE database. The approach is similar. It’s a one-time... Read More »

Introduction This blog will cover the scenario of creating a custom database refresh process in SAP LaMa. We will use Automation Studio and the database will be SAP Adaptive Server Enterprise (ASE) or also informally known as Sybase ASE. The steps... Read More »

If you have wanted to auto-update your BW files using a dynamic selection of variables and filters, then this blog may be useful to you. What I’ll cover is how I’ve been able to do this with Excel VBA and Analysis for Office (AO). My previous... Read More »

In my previous blog we used VBscript and VBA macros to update BW workbooks in BEX and Analysis for Office. Its a simple and low cost way to auto-update your BW workbooks. This blog will expand on that idea and include a more elegant way to do all... Read More »

For a little while now I’ve been looking for hands-off ways to auto-update Excel files with data from our BW system, without having to use Broadcasting or any other additional servers. After reading through numerous posts and forums from a... Read More »