
Date Range for Paginated Report Parameter using Calendar Format
We have Power BI Report Builder to create paginated reports from Power BI Datasets and other popular data sources. We also have the Power BI Service, where we can publish paginated reports to Premium-backed workspaces and export them to PDF and Microsoft Excel formats. Now, let’s look at the date filtering problem we faced. Date […]
Read More

Unlocking Growth with the Complete BI Strategy Blueprint
In today’s fast-paced and data-centric business world, the significance of Business Intelligence (BI) cannot be overstated. BI is the driving force behind informed decisions, actionable insights, and maintaining a competitive edge. This blog explores the pivotal role of BI and how a well-crafted BI strategy can be your compass to navigate the complexities of modern […]
Read More

Enhance Analytics with SQL Window Framing - A Guide
Window Framing Window framing is a concept of accessing a range of data while executing window functions. Window frame comes into the picture whenever you do calculations using window functions. It enables you to decide the range of data to perform the window function calculation in a particular partition. Window Frame A set of rows […]
Read More

Tooling Up for Data Science Implementation Excellence
In the contemporary landscape, data science is revolutionizing industries by converting insights into actionable strategies. Appropriately choosing tools and technologies is paramount to achieving a fruitful data science implementation –translating insights into real-world solutions. This article delves into the fundamental considerations for making these selections, ensuring a seamless journey from gathering data to deploying models. […]
Read MoreUsing Direct Query for Power BI Datasets
What is DirectQuery for Power BI datasets? With DirectQuery for Power BI datasets and Analysis Services, you can use DirectQuery to connect to Power BI datasets. Report authors who want to combine the data from their enterprise semantic model with other data they own, such as an Excel spreadsheet, or want to personalize or enrich […]
Read More

Automating Asset Grouping in Azure Purview
The Team was working on a data governance requirement. It required the Team to group the same type of assets into a logical collection. They were using Azure Purview as the data governance tool. However, it was a tedious task to achieve this manually. Therefore, there was a need to automate it. This blog deals […]
Read More

The Power of Data Analytics in AMS Support: Leveraging Insights for Success
Today’s businesses rely heavily on applications to streamline processes, enhance productivity, and gain a competitive edge. As applications become more complex, ensuring seamless performance and availability is vital for sustained success. This is where Application Management Services (AMS) come into play. AMS providers offer comprehensive support to monitor, maintain, and optimize critical business applications. In […]
Read More

TekLink Enables Seamless Upgrade and Migration for a Multinational Food Products Company
Companies must continuously adapt their technology systems to stay competitive in the dynamic business world. This blog showcases a successful project undertaken by TekLink, for a multinational food products company renowned as the world’s one of the largest cereal companies. This project addressed critical business challenges while ensuring a smooth upgrade and migration process. The […]
Read More

A Comprehensive Approach to SAP Cloud Security
A Comprehensive Approach to SAP Cloud Security
Read MoreBreaking Down the Benefits of DevOps Consulting Services in CI/CD Implementation
DevOps is a methodology and cultural approach to software development that emphasizes collaboration, integration, and communication between development and operations teams. By promoting shared responsibility and cooperation throughout the software development lifecycle, DevOps aims to bridge the gap between these two domains. This approach adopts automation, streamlined processes, and tools to enable efficient software application […]
Read More

Advanced Techniques for Automating Data Integration with Anaplan Connect
Understanding Data Integration and Automation Data Integration is gathering data from different sources into a centralized source for better data analysis and decision-making. Data Automation is the use of technology to automate data-related tasks and workflows to improve the efficiency and productivity of an organization. These are important activities that an organization must consider implementing […]
Read More

How to Monitor Power BI Refresh Dataset Performance and Ensure Data Accuracy
An Introduction to PowerBI In today’s data-driven world, making informed decisions based on data has become a crucial element of success for businesses and individuals alike. Power BI is a powerful analytics tool that helps users analyze and transform data into actionable insights. In the following passage, we will explore how Power BI can help […]
Read More

How Data Analytics Support Can Help Your Business Stay Ahead of the Curve
How Data Analytics Support Can Help Your Business Stay Ahead of the Curve
Read More

Improving your planning and reporting process with BI services
Before discussing the nuances of Business Intelligence, we focus on why companies need help to have a good reporting process. These are just some reasons to introduce you to the issues that companies might face. Understanding Business Intelligence: Business Intelligence (BI) refers to organizations’ tools, systems, and practices to analyze and present data to make […]
Read MoreResolving John Snow Labs(JSL) Library Error in Databricks to seamlessly make insightful decisions driving the business objectives.
Why is it essential to resolve a JSL Library Error? Resolving errors in the John Snow Labs (JSL) Library in Databricks is critical for seamless and efficient data analysis and processing. It helps achieve business objectives, such as making data-driven decisions, identifying trends and patterns, and ultimately making informed business decisions. To resolve errors in […]
Read More

Understanding SAP BPC and the steps to its implementation
Understanding SAP BPC and the steps to its implementation
Read More

How SAP Data Warehouse Cloud connects Business and IT
SAP Data Warehouse Cloud (SAP DWC) is a cloud-based data warehousing solution that connects business and IT by providing a unified data integration, modeling, and analytics platform. It allows business users to access and analyze data in real-time while providing IT with the tools to manage and govern data. One of the key features of […]
Read More

Dynamic Conditional Formatting based on given targets in Power BI Matrix
** Conditional formatting of measures values in matrix based on given targets for given values (these values are rows in matrix) The business users used Weighted Forecast Accuracy – WFA (A Percentage Measure) metric for various business divisions. They wanted to understand each division’s targets better to achieve 100% of the forecast. We worked on […]
Read More

Resolving the error in Azure Function with Extension Bundle
In one of our Azure projects, during the development phase, while writing the files into Azure blob storage in Visual Studio Code, we faced the below error: The root cause of the error: “Error fetching version information for extension bundle Microsoft.Azure.Functions.ExtensionBundle Unable to find or download”. Solution: “Extension Bundles” can add a pre-defined compatible set […]
Read MoreResolving the ECONNREFUSED Error with VS Code while running an Azure Function
We were working on a project requiring us to extract data from an API and land it over a data lake storage account container. So, we created an Azure Function App using Visual Studio (VS) code. We set up an environment for the variable using the SETX command locally. While debugging the code, we got […]
Read More

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
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
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)
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 MoreTriggering 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
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
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
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
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 MoreConfiguring 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
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
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
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
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: e.g. source KF1 =100 -> target KF1 = -100 e.g. Master data -> Emp […]
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 More

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
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
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
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:
Read More

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:
Read More

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:
Read More

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
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 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
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