Custom COPY function using AMDP
In this blog, I will explain how to implement a custom COPY planning function using AMDP. Background Business requirement was to develop an AMDP script to copy data from source to target cube and also implement the additional features as below: While copying data from source to target, invert few key figures e.g. source KF1 […]
Read MoreRestrict Query View creation authorization from user roles
How to restrict Query View creation authorization from user roles? In this blog, I will explain how to deactivate the Query View creation authorization from user roles. To achieve this, along with the modifications in the user roles, we need to maintain a parameter manually to enable the restriction. Step 1: Identify the roles which […]
Read MoreDrill Through from BPC to BW by using Hierarchy members
In this blog, I will explain the issue caused during Drill-Through from BPC to BEx when we pass Hierarchy Node variable values. Background We had a requirement to configure Drill Through from the EPM report to a BEx query. To fulfill this requirement we followed the SAP document ‘How to.. Configure Drill Through Functionality’ and […]
Read MoreLoading JPY Currency Amount in SAP BW
Implementing Currency Amounts Via DB Connect Data Source in SAP BW We were facing an issue in the BW report where JPY currency amounts were displaying 100 times more than its actual value in the source. The source of data was the SQL database via DB connect. We mapped the amounts to an info object […]
Read MoreTracking Inventory Aging with TekLink Solution powered by S/4 HANA
Understanding the concept of Inventory Aging The foremost need is to understand what is inventory aging and how it affects our business? In simple terms: Inventory Aging indicates how long a product has been hoarded in a warehouse. Inventory Aging is of utmost significance in the food industry along with others, where consumable goods which […]
Read MoreThe Power of a Holistic Supply Chain for CPG
Are you having issues with your S&OP process? TekLink’s Anaplan solution can simplify the process and enable connected planning. S&OP is a process that is fundamental to the success of an organization, and yet many organizations struggle to have a successful, robust solution. Some common high-level difficulties frequently demonstrated in S&OP processes are Data overload, […]
Read MoreAutomating Power BI Mobile, Text and Email Notification through Microsoft Flow
Learn how Microsoft Flow helps in automating Power BI notifications enabling the following benefits for the Business User: Real-time alerts across multiple platforms Quick response time for addressing operation problems and issues Alert details allow users to efficiently grasp the whole picture Integration with other applications (Slack, Microsoft Team, Approval system, etc)
Read MoreImprove Forecast Accuracy with SAP Analytics Cloud Predictive Forecasting
In this session to will learn how to leverage SAP Analytics cloud predictive capabilities to improve your forecasting accuracy and simplify your planning process, the video blog will cover the following: Get an overview of SAP Analytics cloud Learn about SAP Analytics cloud predictive capabilities Hear how a SAP Analytics cloud scenario using public information […]
Read MoreMaterial Management Application Walkthrough
TekLink has developed an in-house application to support project-based material management. This includes project proposals, project item proposals, and once approved, how the BOM is calculated and how warehouse volumes are affected. With this application, distribution centers and warehouses supplying project-based solutions can expect the following features: Role Interconnectivity Ability to approve/ reject projects and […]
Read MoreAdvanced Anaplan Integration: Anaplan Connect and Tableau
Find out about a popular integration option and how to automate Anaplan actions from outside the platform. Discover how to create an Anaplan Connect java script windows batch file and review an application of this functionality. Additionally, see how users can leverage Anaplan’s calculation engine to aggregate data in real-time and how easy the Tableau […]
Read MorePower of Condition Characteristic in the Distribution By Reference Data Planning Function
How ‘condition’ characteristic can be useful in the “Distribution By Reference Data” planning function? I had been working on a requirement to distribute the revenue recognized in a month to all the months in which the cost incurred in order to generate the respective revenue. For example; if I have received the payment on an […]
Read MoreImproving Performance of your Planning Application...
How Planning Application Kit (PAK) can be useful in improving the performance of your planning application. I had been working on a planning application built using BW Integrated Planning for one of the clients. That application had extensive usage of “Distribution by Reference Data” standard planning function. It also used the FOX functions for distribution […]
Read MoreHow to set up a Live Data Connection to SAP BW from SAP Analytics Cloud
The focus of this blog is to explain the process involved in setting up a live connection to an on-premise SAP BW from SAP Analytics Cloud. The main feature of Live Data Connection is that the changes made to data in the on-premise data source are immediately reflected in the Stories and Models based on […]
Read More