Are you over 18 and want to see adult content?
More Annotations
A complete backup of cimeaventures.com
Are you over 18 and want to see adult content?
A complete backup of missselfridge.com
Are you over 18 and want to see adult content?
A complete backup of initialoutfitters.com
Are you over 18 and want to see adult content?
A complete backup of districtrealty.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of www.www.blackboyaddictionz.com
Are you over 18 and want to see adult content?
A complete backup of www.extasycams.com
Are you over 18 and want to see adult content?
A complete backup of alakazam1988.tumblr.com
Are you over 18 and want to see adult content?
A complete backup of quartier-rouge.be
Are you over 18 and want to see adult content?
A complete backup of www.krasotkilux.ru
Are you over 18 and want to see adult content?
Text
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
SAP DASHBOARDS / XCELSIUS Visual BI has developed 40+ custom add-on controls for SAP Dashboards, consisting of a variety of components including. Period Selectors. Calendars. Charts. Utilities. Our controls deliver various most-sought-after features not found in Xcelsius such as Export to Excel/PDF/JPG, Multiple-selection, and more. Request a FREE Demo. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be usedSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series: 1 – Overview. In this blog series, we will be reviewing SAP Analytics Cloud’s Application Design use case in-depth and exploring its specific capabilities. SAP Analytics Cloud (SAC) is a unified cloud offering from SAP that delivers Business Intelligence (BI), Planning andPredictive
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
CONDITIONALLY DRILL-THROUGH ACTION IN POWER BI Pre-requisite: Need a valid drill-through page within the report. Step 1: Create the DAX formula for the Button text and Destination as below. Step 2: Map the created DAX in the button text and button action -> Destination. Step 3: Format the button to show the difference between disabled and enabled state. Step 4: Give a meaningful tooltip forAZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadVISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
SAP DASHBOARDS / XCELSIUS Visual BI has developed 40+ custom add-on controls for SAP Dashboards, consisting of a variety of components including. Period Selectors. Calendars. Charts. Utilities. Our controls deliver various most-sought-after features not found in Xcelsius such as Export to Excel/PDF/JPG, Multiple-selection, and more. Request a FREE Demo. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be usedSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series: 1 – Overview. In this blog series, we will be reviewing SAP Analytics Cloud’s Application Design use case in-depth and exploring its specific capabilities. SAP Analytics Cloud (SAC) is a unified cloud offering from SAP that delivers Business Intelligence (BI), Planning andPredictive
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
CONDITIONALLY DRILL-THROUGH ACTION IN POWER BI Pre-requisite: Need a valid drill-through page within the report. Step 1: Create the DAX formula for the Button text and Destination as below. Step 2: Map the created DAX in the button text and button action -> Destination. Step 3: Format the button to show the difference between disabled and enabled state. Step 4: Give a meaningful tooltip forAZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, Load SAP DASHBOARDS / XCELSIUS Visual BI has developed 40+ custom add-on controls for SAP Dashboards, consisting of a variety of components including. Period Selectors. Calendars. Charts. Utilities. Our controls deliver various most-sought-after features not found in Xcelsius such as Export to Excel/PDF/JPG, Multiple-selection, and more. Request a FREE Demo.SAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. TREND ANALYSIS IN POWER BI A simple solution to achieve this in Power BI is to maintain a separate table along with the index values representing the 8 quarters. Let us look into the detailed implementation of the solution. Step 1: The first step is to create a separate table for all the quarters for the data present in the model and it has to be linkedwith the date
EMBEDDING DATA IN WORKBOOKS VS How to create a published data source in Tableau. Once you have the data source ready to publish, go to Server -> Publish Data Source and choose the data source that you want to publish. Or alternatively, you can right-click on the data source from data pane and click on the option Publish to Server. In terms of data source, the role for the HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. TOGGLE BETWEEN A CHART AND A TABLE IN POWER BI Here’s how we can achieve this requirement of toggling between chart and table. Assuming we have a report like the one above, Step 1 – Add the required table and the chart one over the other in the same canvas area. In this post both the chart and the table show ‘Sales Amount by City’. Step 2 – Add two images/icons. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT HISTORICAL DATA PRESERVATION USING POWER BI DATAFLOW Historical Data Preservation using Power BI Dataflow. Power BI Dataflow is a Self-Service revolution providing extensive capabilities on data preparation for the Power BI Online Service. It allows large-scale, complex and reusable data preparation to be done directly on the Power BI Service and store it in ‘Azure Data Lake StorageGen2’.
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
SAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series: 1 – Overview. In this blog series, we will be reviewing SAP Analytics Cloud’s Application Design use case in-depth and exploring its specific capabilities. SAP Analytics Cloud (SAC) is a unified cloud offering from SAP that delivers Business Intelligence (BI), Planning andPredictive
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be usedSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. SAP BW/4HANA VERSION 2.0. LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
SAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series: 1 – Overview. In this blog series, we will be reviewing SAP Analytics Cloud’s Application Design use case in-depth and exploring its specific capabilities. SAP Analytics Cloud (SAC) is a unified cloud offering from SAP that delivers Business Intelligence (BI), Planning andPredictive
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be usedSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. SAP BW/4HANA VERSION 2.0. LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
ADSO FUNCTIONALITIES IN BW/4HANA ADSO Functionalities in BW/4HANA. SAP BW/4HANA. Apr 7, 2020 by Gnana Sudarson Antony. In BW4HANA system, ADSO (Advanced Data Store Object) is the primary persistent object used in data modelling. This blog explains the different tables created when using an ADSO and how a full/delta/initial load updates/fetches data from these differenttables.
EMBEDDING DATA IN WORKBOOKS VS How to create a published data source in Tableau. Once you have the data source ready to publish, go to Server -> Publish Data Source and choose the data source that you want to publish. Or alternatively, you can right-click on the data source from data pane and click on the option Publish to Server. In terms of data source, the role for theAZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
CONNECTING PYTHON WITH TABLEAU Insights. Blogs – Get your inside scoop into our take on the latest developments in BI & Analytics; Case Studies – A growing collection of more than 50+ case studies exhibiting our customers’ success; Videos – Handpicked video resources showcasing you the latest BI trends and technologies; Webinars – Get latest updates on our webinar schedules & register to learn from our experts OVERCOMING LIMITATIONS OF COMPOSITE PROVIDER The performance improvement of composite provider also brings along various limitations. In this blog, we will detail some of the most common limitations and how to break them! 1) When using Binding Type Union, in a composite Provider, it cannot a have Binding Type Join as one of the part providers. Meaning, only unions among datasets ispossible.
FIORI LAUNCHPAD ON SAP BUSINESSOBJECTS BI PLATFORM 4.2 SP4 The much-awaited SAP BusinessObjects BI Platform 4.2 SP4 was out on 12 th May, 2017 and here is a first look on its FIORI Launchpad.. Login. We have the new FIORI launchpad accessible through a separate URL asshown below:
7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
UNDERSTANDING EXCLUDE LEVEL OF DETAIL (LOD) IN TABLEAU Let’s understand Exclude LOD through an example. Build the following view: Image 1. Currently sales are being computed at Region and State level. Now add city to the view: Image 2. In the above image the Sales are being computed at Region, State and City level. Create the Exclude LOD calculation and add it to the view.VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
ADSO FUNCTIONALITIES IN BW/4HANA ADSO Functionalities in BW/4HANA. SAP BW/4HANA. Apr 7, 2020 by Gnana Sudarson Antony. In BW4HANA system, ADSO (Advanced Data Store Object) is the primary persistent object used in data modelling. This blog explains the different tables created when using an ADSO and how a full/delta/initial load updates/fetches data from these differenttables.
HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. OVERCOMING LIMITATIONS OF COMPOSITE PROVIDER The performance improvement of composite provider also brings along various limitations. In this blog, we will detail some of the most common limitations and how to break them! 1) When using Binding Type Union, in a composite Provider, it cannot a have Binding Type Join as one of the part providers. Meaning, only unions among datasets ispossible.
HOW TO EMBED POWER BI REPORTS AND DASHBOARDS IN YOUR Update the Workspace ID and the Report ID fields with the values of the Power BI Report you wish to embed. Step 3: Running the Application. Clicking on the Get Report button embeds the Power BI Report into the web application. Step 4: Customizing the Web Application to add a Region Filter.AZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. EMBEDDING DATA IN WORKBOOKS VS PUBLISHED DATA SOURCES How to create a published data source in Tableau. Once you have the data source ready to publish, go to Server -> Publish Data Source and choose the data source that you want to publish. Or alternatively, you can right-click on the data source from data pane and click on the option Publish to Server. In terms of data source, the role for theSAP ANALYTICS CLOUD
SAP Analytics Cloud has provided a new hack to improve the loading performance for Live BW models using enhanced techniques by reducing round-trips to the backend, and memory by combining backend calls for multiple charts within a story as long as they share the same dimensions, along with a few other prerequisites. FIORI LAUNCHPAD ON SAP BUSINESSOBJECTS BI PLATFORM 4.2 SP4 The much-awaited SAP BusinessObjects BI Platform 4.2 SP4 was out on 12 th May, 2017 and here is a first look on its FIORI Launchpad.. Login. We have the new FIORI launchpad accessible through a separate URL asshown below:
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
ADSO FUNCTIONALITIES IN BW/4HANA ADSO Functionalities in BW/4HANA. SAP BW/4HANA. Apr 7, 2020 by Gnana Sudarson Antony. In BW4HANA system, ADSO (Advanced Data Store Object) is the primary persistent object used in data modelling. This blog explains the different tables created when using an ADSO and how a full/delta/initial load updates/fetches data from these differenttables.
HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. OVERCOMING LIMITATIONS OF COMPOSITE PROVIDER The performance improvement of composite provider also brings along various limitations. In this blog, we will detail some of the most common limitations and how to break them! 1) When using Binding Type Union, in a composite Provider, it cannot a have Binding Type Join as one of the part providers. Meaning, only unions among datasets ispossible.
HOW TO EMBED POWER BI REPORTS AND DASHBOARDS IN YOUR Update the Workspace ID and the Report ID fields with the values of the Power BI Report you wish to embed. Step 3: Running the Application. Clicking on the Get Report button embeds the Power BI Report into the web application. Step 4: Customizing the Web Application to add a Region Filter.AZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. EMBEDDING DATA IN WORKBOOKS VS PUBLISHED DATA SOURCES How to create a published data source in Tableau. Once you have the data source ready to publish, go to Server -> Publish Data Source and choose the data source that you want to publish. Or alternatively, you can right-click on the data source from data pane and click on the option Publish to Server. In terms of data source, the role for theSAP ANALYTICS CLOUD
SAP Analytics Cloud has provided a new hack to improve the loading performance for Live BW models using enhanced techniques by reducing round-trips to the backend, and memory by combining backend calls for multiple charts within a story as long as they share the same dimensions, along with a few other prerequisites. FIORI LAUNCHPAD ON SAP BUSINESSOBJECTS BI PLATFORM 4.2 SP4 The much-awaited SAP BusinessObjects BI Platform 4.2 SP4 was out on 12 th May, 2017 and here is a first look on its FIORI Launchpad.. Login. We have the new FIORI launchpad accessible through a separate URL asshown below:
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. EXPLORING NATIVE TABLEAU CONNECTOR FOR AZURE DATA LAKE Establishing connection. Open Tableau Desktop and select the Azure Data Lake Storage Gen2 connector from the list of installed connectors: Fig 1: Selecting the Azure Data Lake Storage Gen2 connector. 2. All Tableau-Azure connectors support Azure Active Directory authentication in the 2021.1 version. So, Microsoft account credentials can be used WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
WHY DBT FOR SNOWFLAKE? Suppose you are a Snowflake customer looking for a data transformation tool. Then dbt fits very well into the list of transformation tools choices as it can orchestrate data modeling and data transformation work. dbt can perform the transformation on data already loaded in your data warehouse. It can do ‘T’ in ‘ELT’ (Extract, LoadSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
CHANGE DATA CAPTURE (CDC) USING STREAMS AND TASKS IN Snowflake, the data warehouse built for the cloud has been embarking its name stronger day by day in the BI industry. Along with its various cutting-edge features such as Zero Cloning, Time Travel, Dynamic caching mechanism Snowflake now seems to have few more productive utilities: Streams, for Change Data Capture and Tasks, an inbuilt scheduling mechanism to schedule our jobs. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT 7 THINGS TO KNOW ABOUT PAGINATED REPORTS IN POWER BI 7 Things to Know About Paginated Reports in Power BI. Power BI. Jun 17, 2019 by Sathya Narayana Karthikeshwar. Paginated Reports are the SQL Server Reporting services which have come to Power BI. Through Paginated reporting, we can now print and share what we call “ paginated ” because they tend to be well formatted and fit well on apage. 1.
ADSO FUNCTIONALITIES IN BW/4HANA ADSO Functionalities in BW/4HANA. SAP BW/4HANA. Apr 7, 2020 by Gnana Sudarson Antony. In BW4HANA system, ADSO (Advanced Data Store Object) is the primary persistent object used in data modelling. This blog explains the different tables created when using an ADSO and how a full/delta/initial load updates/fetches data from these differenttables.
HOW TO DEBUG AMDP ROUTINES IN BW TRANSFORMATION? Explicit activation of the Debugger. To activate the AMDP Debugger explicitly, position the cursor within the ruler (left bar) of the source editor at the line that contains the AMDP code and choose “Activate AMDP Debugger” from the context menu. 2. Implicit activation of the Debugger by setting Breakpoint: You can set thebreakpoint by
AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. LEVERAGING LOGIC APPS IN AZURE DATA FACTORY (ADF) TO Choose FTP to create file action in the logic app and configure the FTP server with proper authentication detail. Once you configured the FTP create file action it will ask for the root folder, filename and file content for creating the file inside the FTP server. You will get the file name from HTTP action and file content from data lake action. OVERCOMING LIMITATIONS OF COMPOSITE PROVIDER The performance improvement of composite provider also brings along various limitations. In this blog, we will detail some of the most common limitations and how to break them! 1) When using Binding Type Union, in a composite Provider, it cannot a have Binding Type Join as one of the part providers. Meaning, only unions among datasets ispossible.
HOW TO EMBED POWER BI REPORTS AND DASHBOARDS IN YOUR Update the Workspace ID and the Report ID fields with the values of the Power BI Report you wish to embed. Step 3: Running the Application. Clicking on the Get Report button embeds the Power BI Report into the web application. Step 4: Customizing the Web Application to add a Region Filter.AZURE DATA FACTORY
Azure Data Factory (ADF) is a cloud-based data integration solution that offers 90+ built-in connectors to orchestrate the data from different sources like Azure SQL database, SQL Server, Snowflake and API’s, etc. Azure Data Factory has recently added the Snowflake Connector to extract/load data from Snowflake with any of your existing legacy or modern Database/Datawarehouse. EMBEDDING DATA IN WORKBOOKS VS PUBLISHED DATA SOURCES How to create a published data source in Tableau. Once you have the data source ready to publish, go to Server -> Publish Data Source and choose the data source that you want to publish. Or alternatively, you can right-click on the data source from data pane and click on the option Publish to Server. In terms of data source, the role for theSAP ANALYTICS CLOUD
SAP Analytics Cloud has provided a new hack to improve the loading performance for Live BW models using enhanced techniques by reducing round-trips to the backend, and memory by combining backend calls for multiple charts within a story as long as they share the same dimensions, along with a few other prerequisites. FIORI LAUNCHPAD ON SAP BUSINESSOBJECTS BI PLATFORM 4.2 SP4 The much-awaited SAP BusinessObjects BI Platform 4.2 SP4 was out on 12 th May, 2017 and here is a first look on its FIORI Launchpad.. Login. We have the new FIORI launchpad accessible through a separate URL asshown below:
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. CREATING SVG IMAGES IN POWER BI Using an SVG image we can customize and enhance visualization components in Power BI. Power BI allows dynamic creation of SVG images by measures as Image URL. Here, we are going to see the below example for the same. Create a bar chart for top 5 Products by Sales for each Region. The dimensions are Region and Product with the metric sales. PLANNING IN SAP ANALYTICS CLOUD SERIES 1: OVERVIEWSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
SAP ANALYTICS CLOUD
In the previous blog in this series, we learnt about Passing Filter Parameter to Story.In this blog, let us take a closer look at how to instantly analyze Live data without creating a data model. *** In SAP Analytics Cloud when you need to examine data from live data sources, you have to create a data model based on the live query and consume it in the story. But starting with update 2019.14 CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT CUSTOM DIMENSIONS AND MEASURES USING FORMULAS IN SAP Custom dimensions and measures can be created in several ways in SAP Lumira Discovery –. You can head to the below highlighted icon available in Data View or Design View to Create Calculations. You can also right-click on the dimension name in the panel that lists all the dimensions and measures available in the data set and then select GROUPING AND LINKING DIMENSIONS IN ANALYSIS FOR OFFICE In this blog about Grouping and Linking Dimensions in Analysis for Office we explore a cool new feature that is offered by Analysis for Office versions 2.4- the ‘Combine’ functionality.When several data sources are used in a workbook, any action performed on a dimension affects the exact same dimension in other data sources in the sameway.
VISUAL BI SOLUTIONS
Visual BI Solutions - Look Forward. Think Ahead. Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Cost-effective and scalable solution implemented with robust data governance standards to address the needs of adiverse user
EXPLORING AZURE BLOB AND TABLEAU Step 1 : Connecting Azure Blob via ADF to Azure SQL database. Using Azure Data Factory (ADF) – a cloud-based ETL and data integration service, the file is copied from Azure Blob to Azure SQL database by creating a linked service and a pipeline involving copy activity. Detailed steps can be found in this Microsoft documentation. CREATING SVG IMAGES IN POWER BI Scalable Vector Graphics (SVG) images are two-dimensional vector graphics defined in an XML format.It is a W3C recommendation and each element in it can be animated without any loss in quality even after resizing. Using an SVG image we can customize and PLANNING IN SAP ANALYTICS CLOUD SERIES 1: OVERVIEWSAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series 17 Navigation Utility Options. In the previous blog in this series, we learned how to use Slider and Range Slider widgets. In this blog, let us look at various options available under the Navigation Utility function. Navigation Utility is a function in scripting exclusive to AnalyticsDesigner
ACHIEVING GLOBAL FILTERS ACROSS THE REPORT IN POWER BI Solution: Now, let’s look at making Year and Month as global filters. Step 1: Create a date table in a calendar format i.e. unique running dates as below. Step 2: Now create relationships as below between the tables using the date column. Step 3: Now drag and drop the Year and Month fields from the respective dummy tables into theReport
SAP ANALYTICS CLOUD
In the previous blog in this series, we learnt about Passing Filter Parameter to Story.In this blog, let us take a closer look at how to instantly analyze Live data without creating a data model. *** In SAP Analytics Cloud when you need to examine data from live data sources, you have to create a data model based on the live query and consume it in the story. But starting with update 2019.14 CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT CUSTOM DIMENSIONS AND MEASURES USING FORMULAS IN SAP Custom dimensions and measures can be created in several ways in SAP Lumira Discovery –. You can head to the below highlighted icon available in Data View or Design View to Create Calculations. You can also right-click on the dimension name in the panel that lists all the dimensions and measures available in the data set and then select GROUPING AND LINKING DIMENSIONS IN ANALYSIS FOR OFFICE In this blog about Grouping and Linking Dimensions in Analysis for Office we explore a cool new feature that is offered by Analysis for Office versions 2.4- the ‘Combine’ functionality.When several data sources are used in a workbook, any action performed on a dimension affects the exact same dimension in other data sources in the sameway.
SAP DASHBOARDS / XCELSIUS Visual BI has developed 40+ custom add-on controls for SAP Dashboards, consisting of a variety of components including. Period Selectors. Calendars. Charts. Utilities. Our controls deliver various most-sought-after features not found in Xcelsius such as Export to Excel/PDF/JPG, Multiple-selection, and more. Request a FREE Demo.SAP ANALYTICS CLOUD
SAP Analytics Cloud – Application Design Series: 5 – Introduction to Scripting. In the previous blogs in this series, we created a simple analytic application and added features such as popups and dynamic visibility. We also leveraged scripting, albeit on a verylimited basis.
WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 In the Snowflake as a Data Lake blog, we saw the importance of the data lake and its technical challenges and how Snowflake can act as a data lake solution. We also touched on a few points on how a data lake can be implemented in Snowflake. In this part of the blog, we will see how Snowflake outplays other competitors in the market, like Amazon S3and Delta Lake.
CUSTOM HIERARCHIES WITHIN ANALYSIS FOR OFFICE Consume the corresponding data source onto Analysis for Office. 2. Select one or more members of a dimension in the crosstab, as shown below. 3. Click on Hierarchy -> Group members. The Group Header dialog appears. 4. Enter a name for the new node in Group Header field. The name will be the header for the grouped members. CONVERTING ABAP CODE INTO AMDP SCRIPTS IN SAP BW In this blog, we will focus on tips and tricks used in converting ABAP code to AMDP scripts and concentrate on the most frequently used ABAP keywords. 1. Delete: In ABAP, the DELETE statement is used to remove certain records from an internal table based on certain conditions. In the AMDP script, the DELETE statement is replaced by SELECT USAGE OF KEY INFLUENCER VISUAL IN POWER BI 1. To enable this feature, we will need to go to Options -> Global -> Preview Feature and select the highlighted -> Key Influencers Visual. Enabling Key Influencer Visual in Power BI. 2. The user may have to close and start Power BI Desktop again for this visual option to be shown on the Visualization panel. TREND ANALYSIS IN POWER BI A simple solution to achieve this in Power BI is to maintain a separate table along with the index values representing the 8 quarters. Let us look into the detailed implementation of the solution. Step 1: The first step is to create a separate table for all the quarters for the data present in the model and it has to be linkedwith the date
AN EFFECTIVE 8-STEP PROCESS FOR CREATING ADVANCED Step 4: Mockups and Design Layout. This is where the dashboard truly begins to come to life. In this step you’ll decide the layout of your dashboard, and create a visual mockup. Tools commonly used during this phase include whiteboards, Powerpoint, MS Paint, Balsamiq, Adobe Photoshop, Illustrator – even old-school pencil and paper. 6 BEST PRACTICES FOR EFFICIENT TABLEAU SERVER PERFORMANCE a) Refresh Less Often – Data from source is cached. Subsequently every time the report is accessed data from cache is displayed. This is done to reduce the load on Tableau Server by not sending query to database every time the report is accessed thereby improving performance. This option is best when used for data that changes lessoften.
HOW TO EXECUTE AZURE FUNCTIONS FROM AZURE DATA FACTORY The http URL of the function is obtained which when sent request will trigger the function. 2. The function logic processes the data and sends it back with the necessary response. 3. In Azure Data Factory, the Azure function is added as the Web Linked Service or a HTTP Data Source and the URL of the function is provided to it. 4. This website stores cookie on your computer, to know more visit our PRIVACY POLICY . If you decline, your information won’t be tracked when you visit this website. A single cookie will be used in your browser to remember your preferencenot to be tracked.
Accept Decline
__Menu
* Services__
* Data Architecture & Engineering – Build a modern data foundation that supports your business * Strategy & Architecture – Drive successful outcomes with the right data strategy and architecture * Modern BI & Analytics – Experience the power of data with modern visualization techniques * Data Science & ML – Unlock endless possibilities with an optimum mix of Data Science and Machine learning* Products__
* Inforiver – A Low code/No code Enterprise AnalyticsSuite
* xViz – Advanced Enterprise Visuals for Microsoft® Power BI * ValQ – Visualize, Simulate, Plan, Analyze Your BusinessLike Never Before
* BI Hub – Discover & Consume all your Enterprise Analyticscontent with BI Hub
* VBX – Advanced Enterprise Visuals for SAP® Lumira*
VISUAL BI ANNOUNCES LAUNCH OF INFORIVER, A LOW CODE/NO CODE ANALYTICS SUITE FOR ENTERPRISESKnow more...
* Insights__
* Blogs – Get your inside scoop into our take on the latest developments in BI & Analytics * Case Studies – A growing collection of more than 50+ case studies exhibiting our customers’ success * Videos – Handpicked video resources showcasing you the latest BI trends and technologies… * Webinars – Get latest updates on our webinar schedules & register to learn from our experts* About Us__
* About Visual BI – We make the best in BI possible through our passion and commitment to innovation * Our Team – Meet our strong management team with hands-on experience in BI & Analytics * Careers – Explore intellectually rewarding careers in the field of Business Intelligence & Analytics * Innovation Lab – The Innovation Lab is built with an aim to create market-ready BI & Analytic solutions__
LET'S TALK
EXCELLENCE IN MODERN BI STACK FOR ENTERPRISES Driving analytics excellence for a stronger future\n \nSERVICES\n DATA ARCHITECTURE & ENGINEERINGSTRATEGY & ARCHITECTUREMODERN BI & ANALYTICSDATA SCIENCE & MACHINE LEARNING\n ","tablet":" DRIVING ANALYTICS EXCELLENCE FOR A STRONGER FUTURE","PHONE":"DRIVING ANALYTICS EXCELLENCE FOR A STRONGER FUTURE"}},"SLUG":"ET_PB_SLIDE"}" DATA-ET-MULTI-VIEW-LOAD-TABLET-HIDDEN="TRUE" DATA-ET-MULTI-VIEW-LOAD-PHONE-HIDDEN="TRUE">DRIVING ANALYTICS EXCELLENCE FOR A STRONGER FUTURESERVICES
DATA ARCHITECTURE & ENGINEERING STRATEGY & ARCHITECTURE MODERN BI & ANALYTICS DATA SCIENCE & MACHINE LEARNING A MAJOR AMERICAN AIRLINE MIGRATES FROM LEGACY TO MODERN DATA WAREHOUSE Jetblue leveraged Snowflake on Azure Cloud to provide a robust, performance optimized and scalable solution and increased data availability and query performance by 90%. Snowflake dbt Fivetran AzureVIEW CASE STUDY
PUBLIC REAL ESTATE INVESTMENT TRUST BENEFITS FROM DATA ENGINEERING IN SNOWFLAKE AND REPORTING IN POWER BI PLATFORM Cost-effective and scalable solution implemented with robust data governance standards to address the needs of a diverse user group/personas comprising of data analysts, business analysts, power users, line managers and executives. Snowflake dbt Power BIAzure
VIEW CASE STUDY
123
Our Technology PartnersUPCOMING EVENT
WEBINAR: Modernize your Enterprise BI using SAP Analytics CloudJune 15, 2021
10 AM CST / 11 AM ESTRegister Now
TRUSTED BY 100+ LEADING BRANDS WORLDWIDEOUR OFFERINGS
We help enterprises to create their own path to digital fluency by building capabilities required for a smarter digital evolution. We tailor solutions to fit your business needs by blending our engineering, analytics and strategical expertise. DATA ARCHITECTURE & ENGINEERINGData Warehouse
Data Lake
Data Engineering
Data Governance
$
STRATEGY & ARCHITECTURE Data Strategy & ArchitectureCloud BI
Cloud Migration
Implementation Strategy$
MODERN BI & ANALYTICSData Discovery
Data Visualization
Dashboards
Reporting
$
DATA SCIENCE & MACHINE LEARNING Data Science Innovation LabDS Vantage
AI & ML
Advanced Analytics
$
FEATURED WEBINARS
SNOWFLAKE: THE MOST COST-EFFECTIVE, AGILE AND SCALABLE DATA WAREHOUSEEVER!
In this webinar the presenter will take you through the most revolutionary data warehouse, Snowflake with a live demo and technical and functional discussions with a customer.Watch Replay
CREATING AGILE DATA WAREHOUSE AND ANALYTICS IN THE CLOUD– CUSTOMER (KMG CHEMICALS) CASE STUDY Our Customer, Frikkie Koen, SAP Solution Lead- KMG Chemicals, joins Visual BI in explaining how to establish a cloud-based data warehouse that can handle the volume, velocity, and variety of types of data associated with Big Data.Watch Replay
CONNECTING VALQ TO YOUR ENTERPRISE DATA WAREHOUSE (EDW) ValQ allows business users across industries to visualize and optimize profitability & growth across various modules. This webinar showcases how you can connect ValQ to your Enterprise Data Warehouses like SSAS Cubes, Azure SQL DW, SAP BW Queries & SAP HANA Views.Watch Replay
FEATURED CASE STUDIES CHAMBERLAIN GROUP LEVERAGES CUSTOM POWER BI VISUALS FROM VISUAL BI TO BUILD AN IDEAL USER-CENTRIC DASHBOARD Visual BI gets featured by Microsoft For engaging with Chamberlain- the leading residential and commercial access solutions providerView Case Study
AGILE DATA WAREHOUSE USING SAP CLOUD PLATFORM (SCP) Installed and configured Smart Data Integration (SDI), BOE, and SAPCloud Connectors
View Case Study
FEATURED BLOGS
MACHINE LEARNING & DATA ANALYTICS USING TABPY- EXPLAINED WITH A USECASE
Machine learning and data science concepts have...read more
WHAT’S YOUR PREFERRED DATA LAKE ? (SNOWFLAKE VS. AMAZON S3 VS. DELTALAKE)
In the Snowflake as a Data Lake blog, we saw the...read more
WHY DBT FOR SNOWFLAKE? First, we will discuss why Snowflake is getting...read more
TRUSTED BY LEADING BRANDS WORLDWIDEPrev
Prev
100+
Consulting Customers1000+
Product Customers
100+
Consulting Customers1000+
Product Customers
TESTIMONIALS
Here’s what some of our customers have to say Really awesome work on this. Can’t tell you how excited I am to seethis come to life.
It’ll provide a great foundation on which to build more capabilitiesfor your team,
and for us as a group to expand into other areas like customer service, quality, social, CRM…all on the same platformIT DIRECTOR
Leading Consumer Goods Company The migration to SAP HANA allowed us to keep our data warehouse and analytics environment untouched while gaining a tremendous performanceadvantage
CIO
Upstream Oil & Gas Company The new database is very quick and while I know there were obstacles to getting where we are today, it was a team effort to get this completed. We are taking the right steps on the path of improving our business intelligence and being able connect our data in new ways and ask new questions. We will be able to more effectively target customerand business needs.
VICE PRESIDENT, QUALITY A large US power supplies and solutions provider In addition to scalability, reliability, value, and an intuitive user interface, we wanted a solution that we could easily support going forward. After examining all the options, we selected Microsoft PowerBI Embedded.
DIRECTOR OF IT INFORMATION SERVICES,Chamberlain Group
We were looking for a partner that could not only help us develop an app, but also develop a great app. We needed help in user experience design, BOBJ implementation, BI experience and Design Studio skills. We found all of it in Visual BI. IT INFORMATION SERVICES DIRECTOR Midwestern Manufacturing ClientSERVICES
Data Architecture & Engineering Strategy & Architecture Modern BI & AnalyticsData Science & ML
PLATFORMS
Snowflake
SAP
Microsoft
Tableau
Spotfire
dbt_
Fivetran
INSIGHTS
Blogs
Webinars
Videos
Case Studies
Events
ABOUT US
About Visual BI
Our Team
Careers
Innovation Lab
News
TECHNOLOGY PARTNERS
CONTACT US
+1 888-227-2794
+1 972-232-2233
5920 Windhaven Pkwy
Plano TX 75093
Follow us
* __
* __
* __
* __
Get the latest news from Visual BI delivered straight to your inboxSubscribe
Copyright © Visual BI Solutions Inc.* Privacy Policy
* Sitemap
* Training
* Contact Us
* Privacy Policy
* Sitemap
* Training
* Contact Us
SUBSCRIBE TO OUR NEWSLETTER Join our mailing list to receive the latest news and updates from ourteam.
SUBSCRIBE!
YOU HAVE SUCCESSFULLY SUBSCRIBED!__
__
* __Services__
* Data Architecture & Engineering * Strategy & Architecture * Modern BI & Analytics* Data Science & ML
* __ Back
* __Products__
* Inforiver
* xViz
* ValQ
* BI Hub
* VBX
* __ Back
* __Insights__
* Blogs
* Case Studies
* Videos
* Webinars
* __ Back
* __About Us__
* About Visual BI
* Our Team
* Careers
* Innovation Lab
* __ Back
-------------------------Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093__ +1 888-227-2794
__ +1 972-232-2233
__ +1 888-227-7192
__ solutions@visualbi.com ------------------------- Copyright © Visual BI Solutions Inc.Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0