Select dimensions by CheckBox and Button

We need a CheckBox, it can be added from the toolbar Let’s change the background color of the CheckboxGroup. To do this, please click on the brush icon, bucket icon and then on more Change color to hex 1f303f Next change the font color Set new color to white, hex ffffff Remove the values from the Checkbox Rename checkbox to CheckboxGroup_Dimensions, bu click on the keys icon Add additional code to the Application - onInitialization // Get all dimensions var dimensions = Table_Games_Sales....

December 13, 2021 · 1 min

SAC APP Design & clean the filter button

Button To clean the filter we need a button. Let’s get one from the plus in the toolbar Put the button near the Year dropdown and rename it Go to the Button_Clean_Filters - onClick Put the following code // Remove all filters from the model Table_Games_Sales.getDataSource().removeDimensionFilter("Name"); Table_Games_Sales.getDataSource().removeDimensionFilter("Publisher"); Table_Games_Sales.getDataSource().removeDimensionFilter("Year"); //Set all dropdowns selection to empty Dropdown_Name.setSelectedKey(''); Dropdown_Publisher.setSelectedKey(''); Dropdown_Year.setSelectedKey(''); Button should now work properly Design Please download image dataset from here...

December 13, 2021 · 1 min

Cascade filtering in SAC

In this part of the tutorial, we are focusing on creating a cascade filter on the dropdown in SAC APP. Cascade means that filters on the dashboard will depend on each other. In the example, if you pick up the publisher name Nintendo then in the games list (Name) you should see only games that belong to Nintendo and no more others. To achieve this, we have to redesign our app a bit....

December 12, 2021 · 4 min

Create and fill a dropdown in SAC APP

Firstly we have to move our table a few lines down. This can be done by moving the mouse between the table and toolbar and drag and dropping when the cursor changes the icon: Click on the plus icon on the toolbar Select Dropdown form the list Lets rename the Table by click on tree dots -> Rename, and set new name to Table_Games_Sales Same with Dropdown, and put new name Dropdown_Name...

December 12, 2021 · 3 min

Simple APP on SAC

We have a model so now it is time to build a SAC APP. Go to applications, click on Create Application Click on the table from at the toolbar Select a existing model Click on model that we created in the previous post Delete columns Add Measure/Dimension to rows Select Name and Publisher Quit panel Save application Click on Run Result should be similar to the image bellow

December 12, 2021 · 1 min

Create new model on SAC

Let’s build a very simple SAC model using kaggle data on video game sales. To create a model on SAC, firstly you have to login into your account (please search for trail if necessary). Next click on files, plus icon, and select model. Now, please click on From a CSV or Excel File Select Source File Download source file from Kaggle. Find vgsales....

December 11, 2021 · 1 min

How to install iOS apps on MacOs M1 (Monterey)

Is it still possible to install/sideload iOS apps into M1 Mac? The answer is yes - it is possible to even on the newest version of MacOS (Monterey 12.0.1).Nevertheless you have to know that not all applications are working well. For example, Instagram is crashing every time at startup, and you have to clear ~/Library/Containers/Instagram every time before launch. How to install the iOS app? Download and install sideloadly from https://sideloadly....

December 7, 2021 · 1 min

How to contribute ABAP projects on Github

Last time, when I published my bw_toolbox project on Github, there were a lot of questions from regular developers not so much familiar with git, how they can contribute. Because of that, I decided to write this quick-start tutorial. What do I need? – system requirements Connection with GitHub – your instance should be able to establish a connection with, SSL Entires – you have to configure your SAP System by adding necessary certificates into STRUST transaction (details), Profile configuration – also changes on the profile level are required, so you have to manual edit entries or use transactions (details)....

December 1, 2021 · 2 min

Call SAP HANA function with table

How to run the HANA SQL function where an output table is required? Example function (from this tutorial): CREATE TYPE "TT_RESTAURANTS" AS TABLE ("node_id" INTEGER, "distance" INTEGER, "hops" BIGINT); CREATE OR REPLACE PROCEDURE "NEAREST_RESTAURANT"(IN startV INT, OUT res "TT_RESTAURANTS") LANGUAGE GRAPH READS SQL DATA AS BEGIN GRAPH g = Graph("SKIING"); VERTEX v_s = Vertex(:g, :startV); MULTISET<Vertex> rests = v IN Vertices(:g) WHERE :v."restaurant" == N'TRUE'; ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (INT "distance" = 0); ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (BIGINT "hops" = 0L); FOREACH rest in :rests { VERTEX v_rest = Vertex(:g, :rest....

November 11, 2021 · 1 min

How to install ABAP 1909 on mac M1

How to run ABAP 1909 on MacOs with M1? For me, the best idea was to use UTM. I also tried before with docker without success - in the end, there was always an error. Install UTM Download Ubuntu Server x64 bit version Create virtual machine on UTM (220 GB storage, 6-7 CPU’s, additional flags) Install Ubuntu server on UTM Install docker sudo apt-get update sudo apt-get install \ ca-certificates \ curl \ gnupg \ lsb-release curl -fsSL https://download....

November 10, 2021 · 1 min