Understanding SQL Query Execution: A Data Engineer's Guide.
As data engineers, we work with SQL daily, but how many of us truly understand the inner workings of a SQL query? Knowing the order of execution can significantly improve the way you write SQL queries. Let’s dive into the process with a practical example. Example Query1: Step 1: Gather the DataOperation: FROM & JOIN […]
Read More
Optimizing SAP Data Warehouses with DBT: A Comprehensive Guide to Enhanced Analytics
In today’s data-driven world, businesses rely heavily on analytics to make informed decisions, optimize processes, and stay competitive. As the volume and complexity of data increase, ensuring efficient data transformation and management becomes critical. This is where the combination of SAP Data Warehouses and DBT (Data Build Tool) offers an innovative approach to improving analytics […]
Read More
Cloud-Based Supply Chain Dashboards: Key Benefits and Trends for 2025
In an increasingly interconnected and competitive global economy, supply chain management is more critical than ever. Businesses must ensure efficiency, agility, and resilience in their supply chains to remain competitive, and cloud-based supply chain dashboards are becoming essential in achieving these objectives. By providing real-time visibility, fostering collaboration, and enabling data-driven decisions, cloud-based dashboards are […]
Read More
How to Ensure Data Quality and Governance in Your Enterprise Data Lake
In today’s data-driven world, enterprises are continually collecting massive volumes of data from multiple sources to drive decision-making, enhance customer experiences, and stay competitive. An Enterprise Data Lake serves as a central repository for all this raw data, allowing organizations to store data of all types, structured or unstructured, at any scale. However, without Data […]
Read MoreHarnessing Data Management Services to unlock Business Value
In today’s rapidly evolving business landscape, data has emerged as one of the most valuable assets for any organization. Whether it’s for making strategic decisions, optimizing operations, or identifying new business opportunities, the effective management of data is critical. Data Management Services play a crucial role in ensuring that businesses can extract maximum value from […]
Read More
Migrating to SAP BTP - Best Practices for a smooth Transition to the Cloud
The modern business landscape is increasingly driven by digital transformation, and cloud adoption is at the heart of this shift. SAP Business Technology Platform (SAP BTP) offers organizations a robust cloud-based platform that accelerates innovation, improves operational efficiency, and delivers the scalability needed to thrive in today’s competitive environment. As businesses transition from legacy systems […]
Read More
The Role of AI and Machine Learning in Enhancing xP&A Capabilities
In the fast-evolving world of business, data-driven decision-making has become essential for staying competitive and agile. Traditional financial planning processes no longer suffice in an era where organizations must anticipate market trends, optimize resources, and respond to rapidly changing conditions. This is where Extended Planning and Analysis (xP&A) comes into play, providing a more comprehensive, […]
Read More
How AI is Shaping the Future of Financial Planning & Analysis
In the ever-evolving world of finance, Financial Planning and Analysis (FP&A) has long been the cornerstone of business decision-making. With the increasing complexity of markets and the exponential growth of data, traditional methods of financial forecasting, reporting, and analysis are proving insufficient. Enter artificial intelligence (AI), a technology that is fundamentally transforming the way FP&A […]
Read More
Overcoming Key Challenges in SAP BW to Snowflake Migration
In the era of cloud-first strategies, many organizations are looking to modernize their data landscapes by moving from traditional on-premises solutions like SAP BW (Business Warehouse) to cloud-native platforms like Snowflake. SAP BW to Snowflake migration promises numerous advantages, including improved performance, scalability, and advanced features that empower businesses to gain better insights from their […]
Read MoreSelf-Service BI vs. Traditional BI: Which is Right for Your Business?
In today’s rapidly evolving business landscape, data is a powerful asset that drives decision-making and shapes strategies. As businesses aim to become more data-driven, Business Intelligence (BI) tools have become indispensable. Business Intelligence refers to the processes, technologies, and tools used to collect, analyze, and present data to inform business decisions. Two distinct models of […]
Read More
Cloud DevOps Consulting and Implementation Services on Azure
In today’s fast-paced digital landscape, organizations are increasingly turning to Cloud DevOps to streamline their development and operations processes. With the right DevOps Consulting Services, companies can enhance collaboration, improve software delivery times, and ensure the quality of their applications. Among the various cloud platforms available, Microsoft Azure stands out as a leading choice for […]
Read More
Streamlining Data Consumption in Power BI with SAP Datasphere
In today’s data-driven business environment, the ability to efficiently consume and analyze data is paramount for organizations aiming to make informed decisions. SAP DataSphere and Power BI are two powerful tools that, when integrated, can significantly enhance data analytics capabilities. This blog will explore the importance of efficient data consumption in business intelligence, provide an […]
Read More
Latest Innovations in SAP Analytics Cloud: A Deep Dive into SAC Updates
In the world of data analytics, staying ahead of the curve is crucial for organizations aiming to leverage insights for competitive advantage. SAP Analytics Cloud (SAC) has emerged as a leading solution that combines business intelligence, augmented analytics, and enterprise planning in a single cloud-based platform. As technology evolves, so does SAC, with continual innovations […]
Read More
Zero-ETL: An Innovative Approach to Data Integration
The modern business world is demanding fast deployment of data insights. Companies need efficient methods to transition from data collection to analytics, AI, and machine learning. Conventional ETL (extract, transform, load) frameworks often fail to meet the technical demands of big data and real-time analysis. To tackle these challenges, a new data management approach known […]
Read More5 Ways Azure Purview Can Revolutionize Your Data Governance Strategy
Effective data governance is more critical than ever in today’s data-driven world. Organizations are inundated with data from various sources, and managing this data efficiently while ensuring compliance with regulatory standards is a significant challenge. Traditional data governance methods often need to catch up due to their inability to scale and adapt to the ever-evolving […]
Read More
A Five-Step Guide to Develop Your Robust Data Strategy Roadmap
In today’s data-driven world, a well-defined data strategy roadmap is essential for organizations aiming to leverage their data assets for improved decision-making and enhanced ROI. A data strategy roadmap serves as a structured plan that aligns data initiatives with business goals, ensuring that data is effectively managed, analyzed, and utilized. This blog will outline a […]
Read More
Top Data Migration Tools to Use in 2024
Data migration transfers data between storage systems, formats, or computer systems. In the digital landscape, data migration is essential for organizations undergoing cloud adoption, business transformation, or striving to meet data compliance requirements. As businesses increasingly rely on data to drive operations and decision-making, the need for efficient and reliable data migration services has never […]
Read More
All About the Dynamic Duo of Next Generation Analytics - SAP DataSphere and SAP Analytics Cloud
Analytics tools have become indispensable in helping organizations make sense of vast data, providing insights that drive strategic actions. Among the leading solutions in the analytics landscape are SAP DataSphere and SAP Analytics Cloud. When used together, these tools offer a powerful combination for next-generation analytics, enabling businesses to manage, analyze, and visualize data seamlessly. […]
Read More
A Comprehensive Guide to Building an Enterprise Data Lake on AWS Cloud
In today’s data-driven world, enterprises are constantly seeking ways to harness the power of their data to gain insights and drive decision-making. One such approach is building an enterprise data lake. An enterprise data lake is a centralized repository that allows organizations to store all their structured and unstructured data at any scale. Building this […]
Read MoreThe Dominant Power of Advanced Analytics Consulting in Transforming CX Management
Amidst today’s rapid business landscape, the quest for delivering exceptional customer experiences (CX) reigns supreme. CX management, a comprehensive journey that extends beyond mere customer service, is a key focus. Advanced analytics consulting emerges as a significant change, empowering businesses with a potent instrument to elevate CX management. By leveraging data and sophisticated analytical methods, […]
Read More
Mastering Security and Compliance for Synapse Data Warehouse
Synapse Data Warehouse is the cornerstone of modern data management, giving companies unparalleled ability to analyze large amounts of data and gain insights. In today’s data-driven world, the importance of security and compliance cannot be underestimated. Please don’t overdo it. This blog explores security and compliance’s critical role in securely managing data in Synapse Data […]
Read More
The Power of Data Management Services in Digital Transformation
Digital transformation fundamentally changes customer value delivery by integrating digital technology into all aspects of a business. These changes include technological advances and cultural shifts that require organizations to constantly challenge, test, and adapt to the status quo. Effective data governance, a key element of digital transformation, drives insight and decision-making. Data management services are […]
Read More
Fort Knox Your Data Security with SAP Datasphere Technology
Data security has become a top priority for businesses and organizations in today’s digital age. With data’s increasing volume and complexity, protecting sensitive information from unauthorized access and breaches is essential to maintaining trust and integrity. SAP Datasphere Technology emerges as a robust solution designed to strengthen your data security measures and protect your valuable […]
Read More
Seamless Transition and Enhanced Support: TekLink's Success Story
In the dynamic world of technology, businesses constantly seek ways to optimize their operations and enhance efficiency. One critical aspect is the seamless transition of IT responsibilities, ensuring uninterrupted support and continued improvements. In a recent collaboration, the TekLink Team successfully replaced an onsite Architect with an offshore resource for a client, offering robust support […]
Read MoreMastering SAP BW to Snowflake Migration: Best Practices and Key Considerations
The ever-expanding data landscape within modern enterprises demands a resilient data infrastructure that facilitates efficient analysis and informed decision-making. In response to the growing complexity, businesses are increasingly exploring alternatives to traditional data warehouse solutions, with Snowflake, a cloud-based data warehouse, emerging as a compelling migration target. This exploration delves into the crucial aspects of […]
Read More
Empowering FP&A by mastering SAP Analytics Cloud Integration
In the ever-evolving business landscape, the role of Financial Planning & Analysis (FP&A) has become increasingly crucial. This blog aims to delve deeper into the transformative journey of FP&A, examining the pivotal role that technology, specifically SAP Analytics Cloud, plays in reshaping its processes. Integrating advanced analytics and data-driven decision-making becomes paramount as organizations navigate […]
Read More
Tips and Tricks for Effective Data Visualization in Azure Power BI
In today’s data-driven world, extracting actionable insights from vast datasets is no longer a luxury but a necessity. Azure Power BI emerges as a powerful ally in this quest, empowering organizations to unlock the hidden potential within their data. Yet, the true magic lies not just in the analysis but in how effectively that analysis […]
Read More
Unveiling strategic growth with SAP’s RISE Methodology implementation
The foundation of this implementation was the strategic utilization of SAP’s RISE Methodology, a structured approach encompassing Realize, Innovate, Sustain, and Enhance. This methodology, offered as a managed cloud service by SAP, was pivotal in migrating critical ERP data, processes, and capabilities to the cloud. The Realize phase focused on understanding the existing landscape, Innovate […]
Read More
RelativePath/Query Option in Power BI
This blog post will provide a comprehensive guide or content to relative queries in Power BI. We will cover the following topics: What is a RelativePath/query? RelativePath & Query are two powerful options that can be used to construct URLs for web service calls in Power BI. They are both records that can be used […]
Read MoreThriving in Dynamic Markets with the BI Advantage
In today’s fast-paced and ever-evolving business landscape, the ability to make informed decisions is not just advantageous; it is imperative for staying competitive and thriving in today’s dynamic markets. This comprehensive exploration delves deeper into the transformative trajectory of Business Intelligence (BI), tracing its roots from essential reporting tools to its current status as an […]
Read More
SAP’s Strategic Direction for Analytics (BusinessObjects BI 2025)
SAP Introducing BusinessObjects BI 2025 SAP continues to develop BusinessObjects and will continue to invest in the interactivity between Analytical Cloud and BusinessObjects. SAP BusinessObjects BI 2025 will be enhanced to improve core workflows, i.e., report creation, access to information, and integration with ever more complex landscapes. Integrating Bl, planning, and predictive in one native […]
Read More
In the Clouds: Azure's Data Engineering Revolution (August 2023)
In the dynamic world of data engineering, staying up-to-date with the latest updates is essential to maintain efficiency and leverage the most advanced tools available. Microsoft Azure, a leading cloud platform, continuously introduces new features and enhancements directly impacting data engineering workflows. This blog will explore the most significant updates in Azure up to August […]
Read More
Predictive Power Unleashed – SAP Analytics Cloud Revolutionizes Decisions
In the complex world of business analytics, SAP Analytics Cloud stands out as a robust tool, offering organizations valuable insights. This blog explores the significance of predictive forecasting within SAP Analytics Cloud, examining its features, benefits, real-world applications, implementation tips, and future trends. Predictive forecasting, departing from traditional statistics, involves using historical data, machine learning […]
Read More
Data Visualization's Role in Optimizing Supply Chains
Supply Chain KPI Dashboards are crucial in modern supply chain management, offering real-time insights and data-driven decision-making capabilities. In this blog, we’ll explore the significance of data visualization within these dashboards and how it transforms supply chain performance. Supply chains are the backbone of businesses, ensuring the seamless flow of goods and services. Any disruption […]
Read MoreUsing Microsoft Product Charticulator to Create Custom Power BI Visuals
Charticulator is a Microsoft product that allows the user to create custom visualizations to be used in Power BI. Charticulator guide: https://charticulator.com/docs/getting-started.html. In this blog we will walk through a use-case scenario for Charticulator and how to integrate that custom visual into Power BI. The requirements from the client state that they want a bar […]
Read More
Migrating Data Warehouse to a Data Lakehouse
What is Data Lakehouse? A Data Lakehouse combines the flexibility of data lakes with the structured processing and analytics capabilities of data warehouses. It allows you to store, manage, and analyze data efficiently. Why Migrate to a Data Lakehouse? Data is vital for modern businesses, but traditional data warehouses face challenges as data grows. The […]
Read More
Data Masking Policies in Snowflake
Data security has established itself as an unwavering foundation within the technological framework of modern applications. Snowflake came with a new feature – “dynamic data masking” – an essential tool that allows it to address the never-ending issue of sensitive data protection. Dynamic Data Masking will protect/control the column data and make it visible to […]
Read More
Streamlining Azure Purview Asset Classification with Automation
The Team was working on a data governance requirement. It required the Team to classify the assets as a “Dimension Table” or a “Transaction Table” based on the asset name. They were using Azure Purview as the data governance tool. However, it was a hectic task to follow the same steps and extremely monotonous to […]
Read More
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 MoreUnlocking 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 More
Using 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 MoreThe 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 More
Breaking 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 MoreHow 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 More
Resolving 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 MoreHow SAP Data Warehouse Cloud connects Business and IT
SAP Datasphere (Previously 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 More
Resolving 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 MoreUsing 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 More
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
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 MoreMachine 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 More
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
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 MoreFlattening 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 More
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
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 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 More
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:
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 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 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 More
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
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 MoreWe 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
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
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
Sr. Manager, Rust-Oleum Company
Have a Project to Discuss? Get in Touch