Correcting the column name definitions in Theobald Bex Query
5th July 2022

Correcting the column name definitions in Theobald Bex Query

Spaces and other special characters in the column names in Theobald Bex Query Extract cause errors in Azure Synapse Analytics during loading into a data warehouse. We worked on a requirement where Theobald job extracted Bex Query Result into a Parquet* file and placed it in the Azure Data Lake Gen2 Container. From Azure Data […]

Read More
Using Calculation Groups in AAS and PowerBI
22nd June 2022

Using Calculation Groups in AAS and PowerBI

Calculation groups can significantly reduce the number of redundant measures by grouping common measure expressions as calculation items. Calculation groups are supported in tabular models at the 1500 and higher compatibility levels. These are most commonly used in time intelligence measures and to reduce the redundant complex codes. It can significantly reduce the number of […]

Read More
Collecting failed records from Azure Data Factory Pipeline and storing in Azure Datalake Storage
9th June, 2022

Collecting failed records from Azure Data Factory Pipeline and storing in Azure Datalake Storage

We had approximately 130 customer accounts to extract data through the ADF pipeline to be loaded into the Datawarehouse. We ran into an issue of failed or successful loading of customer accounts into the storage account in ADLS. We used the “forEach” activity for all the customer accounts when the activity fails/succeeds. We required the […]

Read More
Customize the ARM Template of Azure Data Factory (ADF) that has Integration Run Time (IRE)
6th June 2022

Customize the ARM Template of Azure Data Factory (ADF) that has Integration Run Time (IRE)

We worked on a Sales Analytics application built to pull the data from SAP and land it over to SQL Server. While working on it, we migrated to Azure Data Factory from one subscription model to another for a POC. We used ARM templates for this purpose. During deployment, there were issues because the same […]

Read More
30th May 2022

Triggering Power BI Dataset Refresh from Azure Data Factory (ADF)

This blog explains how to trigger Power BI dataset refreshes using an Azure Data Factory Web Activity. Background: The business requirement was to develop a solution to trigger Power BI dataset refresh from ADF after completing the ETL pipeline. We were implementing the incremental data load process for which the ETL pipeline was designed to […]

Read More
Getting the correct totals in PowerBI for calculated measures grouped by a set of fields
24th May, 2022

Getting the correct totals in PowerBI for calculated measures grouped by a set of fields

Totals in Power BI are calculated horizontally instead of vertical sum for the calculated measure grouped by a specific set of fields We worked on a requirement to get the Vendor Responsibility for the warranty claimed by customers. The data set was as follows: Vendor Material Customer Sales Warranty Vendor Responsibility % Vendor Responsibility (Warranty*Vendor […]

Read More
Machine Learning with Industrial Production – Data Modeling
February 07, 2022

Machine Learning with Industrial Production: Data Modeling

In the second of two posts covering a recent Machine Learning project at an industrial company. The first post covers the dataset, preprocessing, and features used to analyze the data. With these data assumptions, we can now hope to better understand the algorithms attempted in the project’s next phases.   We won’t cover any specific findings or outcomes […]

Read More
Machine Learning with Industrial Production – Data Preprocessing
February 01, 2022

Machine Learning with Industrial Production - Data Preprocessing

As the hardware required to collect, synthesize, and analyze data becomes cheaper, the opportunity to apply Machine Learning solutions to complex environments grows. The area that is ripe for disruption in the industrial production processes, by leveraging constant streams of data that record measurements from different sections of the production process. However, the promise of […]

Read More
Configuring the Dropdown feature in Analytic Designer: SAP Analytics Cloud
June 08, 2021

Configuring the Dropdown feature in Analytic Designer: SAP Analytics Cloud

With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is becoming one of the most sort after tools in the SAP BI space. SAC is more of a self-service solution on the cloud, hence, there was a constant business need for a professionally authored dash-boarding tool on the cloud. SAP now has a solution […]

Read More
June 01, 2021

Configuring the CheckBox feature in Analytic Designer: SAP Analytics Cloud

With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is becoming one of the most sort after tools in the SAP BI Space. SAC is more of a self-service solution on the cloud, hence, there was a constant business need for a professionally authored dash-boarding tool on the cloud. SAP now has a solution […]

Read More
Automatically Generate Measures in SSAS Tabular Model using Tabular Editor
May 21, 2021

Automatically Generate Measures in SSAS Tabular Model using Tabular Editor

Creating hundreds of measures, one by one in the SSAS Tabular Model is extremely time-consuming. It does not make a difference, if we have measures which follow a similar naming convention and formula or have similar base columns. If we create the measures manually, then each time we will have to write it, or copy-paste-modify […]

Read More
Flattening SAP Dimension Hierarchy using a Table Function
April 27, 2021

Flattening SAP Dimension Hierarchy using a Table Function

In this blog, we will understand the approach of utilizing SAP Hierarchies in Visualization tools like Power BI, Tableau, and others.

Read More
Customer Lifecycle Value Prediction
April 15, 2020

Customer Lifecycle Value Prediction

Customer-Centric organizations are 60% more profitable than the ones that are not customer-focused Overview Today, the market is saturated and every business has many strong competitors. It is very important for the companies to keep their customers’ satisfaction at a priority so that the customers will remain loyal to the company, as they form the […]

Read More
Custom COPY function using AMDP
September 17, 2019

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 More
August 21, 2019

Restrict 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 More
Drill Through from BPC to BW by using Hierarchy members
July 19, 2019

Drill 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 More
Loading JPY Currency Amount in SAP BW
July 19, 2019

Loading 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 More
Tracking Inventory Aging with TekLink Solution powered by S/4 HANA
July 15, 2019

Tracking 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 More
The Power of a Holistic Supply Chain for CPG
June 17, 2019

The 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 More
June 7, 2019

Automating 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 More
Improve Forecast Accuracy with SAP Analytics Cloud Predictive Forecasting
May 28, 2019

Improve 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 More
Material Management Application Walkthrough
April 18, 2019

Material 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 More
Advanced Anaplan Integration: Anaplan Connect and Tableau
February 1, 2019

Advanced 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 More
Power of Condition Characteristic in the Distribution By Reference Data Planning Function
November 4, 2019

Power 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 More
02 Feb 2021

Improving 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 the “Distribution by Reference Data” standard planning function. It also used the FOX functions for […]

Read More
How to set up a Live Data Connection to SAP BW from SAP Analytics Cloud
January 27, 2021

How 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
We partnered with TekLink based upon a previous positive experience where they did a great job for us as well as hearing positive feedback about their excellent level of service. We’ve also interviewed many of their experts and consistently found their candidates to be the most technically sound with excellent BW and HANA knowledge above and beyond that of their competitors. Teklink has certainly helped us to stabilize and improve the reliability of our BI operations
Patrick Bachman
Patrick Bachman

IT Architect

“TekLink’s team exceeded Kellogg Latin America’s expectations with the implementation of Anaplan. Not only their diligence and technical mastery were evident, but also provided critical and out-of-the-box solutions to meet the project’s criteria and expand its scope.”
Francisco Ibarra
Francisco Ibarra

Sr. Manager, Kellogg Company

“TekLink provided worry free BEx to AO Migration by analyzing and converting our 500+ BEx workbooks to Analysis for Office while also increasing adoption by running power user workshops.”
Lakshmi Thota
Lakshmi Thota

Sr. Manager, Rust-Oleum Company

Have a Project to Discuss? Get in Touch