{"id":810,"date":"2021-02-21T20:36:20","date_gmt":"2021-02-21T19:36:20","guid":{"rendered":"https:\/\/ad-astra.com.pl\/?p=810"},"modified":"2021-03-05T11:35:54","modified_gmt":"2021-03-05T10:35:54","slug":"sap-analytics-cloud-analytics-designer-czesc-2-formatka-planistyczna","status":"publish","type":"post","link":"https:\/\/ad-astra.com.pl\/en\/2021\/02\/21\/sap-analytics-cloud-analytics-designer-czesc-2-formatka-planistyczna\/","title":{"rendered":"SAP Analytics Cloud \u2013 Analytics Designer. Part 2. Planning interface"},"content":{"rendered":"<h2><strong>Part 2. Planning interface with ability to data filtering by Radio Button Group widget and data lock.<\/strong><\/h2>\n\n\n\n<p class=\" translation-block\">Continuing the topic from the first part of article https:\/\/ad-astra.com.pl\/en\/2021\/02\/01\/sap-analytics-cloud-analytics-designer\/ below I will describe  the case of how to use the Radio Button Group widget to filter data. Additionaly, the case also shows  the possibility to block planning in the table.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/NEW-Part-2-SAP-Analytics-Designer-Plan-Headcount-for-2021.mp4\"><\/video><\/figure>\n\n\n\n<p>The first assumption concerns the dynamic update of the filter panel data. This avoids problems with manually updating the data when new values, such as when a  New Region appear in the data source.<br><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"840\" height=\"63\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1.jpg\" alt=\"\" class=\"wp-image-827\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1.jpg 840w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1-300x23.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1-768x58.jpg 768w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1-535x40.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Radio-button-Group-Interface-1-16x1.jpg 16w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure><\/div>\n\n\n\n<p><br>The event which updates the values starts during application initialization (onInitialization). In addition, the initial value of the Radio Button has been set to \"All Regions\". In this case, the \"If\" condition has been used to exclude the null value. <br>Script:<br><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"698\" height=\"244\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1.jpg\" alt=\"\" class=\"wp-image-823\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1.jpg 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1-300x105.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1-535x187.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1-16x6.jpg 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/dodaanie-wartosci-do-listy-dynmiczne-1-572x200.jpg 572w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/figure><\/div>\n\n\n\n<p>The second assumption concerns  the accidental input of values to the planning table. We can achieve this goal by turning off the planning function. In this case, planning is set as unavailable during nnInitialization event.<br><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"698\" height=\"102\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Blokowanie-tabeli.gif\" alt=\"\" class=\"wp-image-821\"\/><\/figure><\/div>\n\n\n\n<p>The next step include configuration the onSelect event for the Radio Butto Group panel (Regions). The goal is to filter data in the planning table -  when the user selects a value, the data will be limited to the selected value.<br>Script:<br><br><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"766\" height=\"172\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Filtrowanie-danych-onSelect-1.jpg\" alt=\"\" class=\"wp-image-816\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Filtrowanie-danych-onSelect-1.jpg 766w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Filtrowanie-danych-onSelect-1-300x67.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Filtrowanie-danych-onSelect-1-535x120.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Filtrowanie-danych-onSelect-1-16x4.jpg 16w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/figure><\/div>\n\n\n\n<p class=\" translation-block\">The last part related to the design of the planning form is triggering the window with information for the user. In order to add such functionality for the onSelect event of the Plan Hires buton , first we check what value has been selected in the filtering component. We will use the IF function to define the behavior of the application. The fulfillment of the first condition, i.e. when the filtering component is set to the value of All Regions, will result in displaying a message that will inform the user to select the region in which he wants to update the planning data again. The message itself was made up of popup window objects and a text object.\nExample:<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"388\" height=\"133\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Text.jpg\" alt=\"\" class=\"wp-image-818\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Text.jpg 388w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Text-300x103.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Text-16x5.jpg 16w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/figure><\/div>\n\n\n\n<p>The fulfillment of the second condition, i.e. when the filtering component is set on the selected region, will open a window with parameters and transfer the text of the selected region to this window so that the user knows what data range he is working with.<br>Script:<br><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"698\" height=\"352\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie.jpg\" alt=\"\" class=\"wp-image-819\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie.jpg 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie-300x151.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie-535x270.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie-16x8.jpg 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/02\/Obsluga-warunku-blokujacego-planowanie-397x200.jpg 397w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/figure><\/div>\n\n\n\n<p>The next article will describe a use case for updating data in a planning table using additional parameters in the popup window.<\/p>","protected":false},"excerpt":{"rendered":"<p>Cz\u0119\u015b\u0107 2. Formatka planistyczna z mo\u017cliwo\u015bci\u0105 filtrowania danych oraz blokowania aktualizacji danych planistycznych. Kontynuuj\u0105c w\u0105tek z pierwszej cz\u0119\u015bci artyku\u0142u https:\/\/ad-astra.com.pl\/2021\/02\/01\/sap-analytics-cloud-analytics-designer\/ w tym artykule przedstawiony zostanie komponent &#8222;Radio Button Group&#8221;, kt\u00f3ry s\u0142u\u017cy do filtrowania danych. Przypadek przedstawia r\u00f3wnie\u017c mo\u017cliwo\u015b\u0107 blokowania funkcji planistycznych. Pierwsze za\u0142o\u017cenie dotycz\u0105ce komponentu filtruj\u0105cego to dynamiczne uzupe\u0142nianie warto\u015bci. &hellip;<\/p>","protected":false},"author":3,"featured_media":834,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17,7],"tags":[58,64,63,65],"_links":{"self":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/810"}],"collection":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/comments?post=810"}],"version-history":[{"count":17,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/810\/revisions"}],"predecessor-version":[{"id":864,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/810\/revisions\/864"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media\/834"}],"wp:attachment":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media?parent=810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/categories?post=810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/tags?post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}