Access Azure SQL Database from Visual Studio Code using Python
Ever tried accessing data on Azure SQL Database from a Python IDE? This article will walk you through the steps required to reach the data in Azure SQL Database tables. Before beginning, let us set up the pre-requisites needed for the process. Below are the software...
SAP BW/4HANA Version 1.0.- Hybrid EDW Modelling – Transporting HANA objects via SAP TMS
This blog is part of the SAP BW/4HANA Development blog series In line with SAP’s roadmap for a hybrid data warehouse on HANA, it has become common for customers to develop models integrating HANA models and BW info providers into composite providers. In doing...
ABAP CDS Table Function with AMDP Function Implementation
This blog is about the workarounds for String functions in ABAP CDS Views and talks about the implementation using CDS Table and AMDP Functions. ABAP CDS table function is defined in the type CDS DDL. In general, the CDS table is implemented using the AMDP method...
Extended View based on HANA Views
This blog is about the workarounds for String functions in ABAP CDS Views and talks about the implementation using CDS Table and AMDP Functions. This process involves creation of the calculation view, expose the HANA view as Dictionary table and use the same in CDS...
10 New Enhancements in VBX Advanced Table for SAP Lumira Designer
In our earlier blog on Advanced Table, we looked at some of the new features made available as part of VBX version 2.0. With the latest VBX release – VBX 2.32, we have added some new features to our Advanced Table. Following is the list of latest enhancements: Theme...
String Functions in ABAP CDS Views – Known Limitations and Workarounds
String functions in general used to perform manipulation of string data. In ABAP CDS there are a variety of string functions to perform operation in the strings. These functions have certain limitations on how the operations can be done. The details are explained in...
Email Data Mining for Incidence Management Using SAP Data Services
Most enterprises have a dedicated customer support group / central email for creating / routing incidents. These emails are designed to go out from a single email account configured in the incident management system. Managing these emails or backtracking them for an...
Connecting to VIEWS in SAP HANA from Azure Cloud
Dealing with a customer who is hesitant to provide access to their HANA tables? Well, request the necessary data in the HANA system as Views, because the data within a View would be a subset of the larger table and it would be straight up easier for any referencing...
Layout Friendly VBX Charts for Lumira Designer
When using Lumira Designer, one of the major problems that the dashboard designers face is optimum usage of the dashboard canvas. When lots of data points are to be displayed in a limited amount of space, the chart is cluttered with points making it hard to...
Calculate Daily Stock Return (multiple companies) using Dense Ranking in Power BI
Let’s say for instance that you have the following dataset with Amazon closing stock price. It is very simple to calculate daily return if you can sort the rows by dates. But what if you have multiple company’s stock price? And more importantly, how can you...
Designing KPI Tile Navigation in Power BI with Buttons and Bookmarks
While Power BI does not have out-of-the-box components to support an interface with flexible navigation, you can still utilize Bookmark and Buttons to make your Power BI report become more interactive. This blog will show you how to use Button Component and Bookmark...
Visual BI Attains Microsoft Gold Partner Status in Data Analytics
PLANO, Texas, July 16, 2018 /PRNewswire/ -- Visual BI Solutions, a niche SAP partner specialized in business intelligence (BI) and analytics, today announced that they are now a Microsoft GOLD partner for Data Analytics. This partnership follows several successful...
Want to keep up with our latest blogs?
Subscribe to our newsletter today.
