{"id":738,"date":"2021-02-01T09:59:30","date_gmt":"2021-02-01T08:59:30","guid":{"rendered":"https:\/\/ad-astra.com.pl\/?p=738"},"modified":"2021-03-03T09:02:16","modified_gmt":"2021-03-03T08:02:16","slug":"sap-analytics-cloud-analytics-designer","status":"publish","type":"post","link":"https:\/\/ad-astra.com.pl\/en\/2021\/02\/01\/sap-analytics-cloud-analytics-designer\/","title":{"rendered":"SAP Analytics Cloud \u2013 Analytics Designer. Part 1 Planning interface"},"content":{"rendered":"<h2><strong>Part 1. Planning interface with ability to trigger data  action<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-video aligncenter\"><video controls loop src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/NEW-Part-1-SAP-Analytics-Designer-Plan-Headcount-for-2021.webm\"><\/video><\/figure>\n\n\n\n<p>With each new release SAP Analytics Cloud provide a lot of interesting features which combine Business Intelligence, planning and prediction areas. One of the most interesting is utilize hidden possibilities included in SAP Analytics Designer, which significantly improve developing visualization and advanced applications<\/p>\n\n\n\n<p>The text consist of three parts, which describe  how to extend planning application with features such as:<\/p>\n\n\n\n<ul><li>Data Action Trigger, eg.  Transfer data from source to target model (or modify it)<\/li><li>Blocking planning options after displaying the planning form<\/li><li>Calling popup window with additional<br>data planning parameters .<\/li><\/ul>\n\n\n\n<p>In simple terms, the case concerns two process steps, i.e .:<\/p>\n\n\n\n<ul><li>Copying source data,<\/li><li>Preparation of planning data (initial plan).<\/li><\/ul>\n\n\n\n<p>At the beginning we should define individual parts of planning interface. In below screen I higlited three parts of the interface.  First part include widgets, which user can use for a data preparation. Second part it\u2019s used for data filtering and unlock ability to planning. Last one part calling popup window where user can actualize data<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface.png\" alt=\"\" class=\"wp-image-747\" width=\"762\" height=\"363\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface.png 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface-300x146.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface-535x260.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface-16x8.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Planning-Interface-412x200.png 412w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/figure><\/div>\n\n\n\n<p>If we already know what each part of the interface does, we can proceed to configuration.<\/p>\n\n\n\n<p>The first part is related to the preparation of data for planning. Let's imagine a case where the initial data for 2021 is prepared on the basis of data from the previous year (2020). Technically, you need to copy the data from the source model to the target \/ planning model. In the second step of data preparation, we will modify it so that it\u2019s ready for planning.\nBelow screen describe how widget like \u201eData Action Trigger\u201d works, which triggers defined  \u201eData Action\u201d. Data Action it\u2019s nothing else as the possibility to define activities on data like data copying,  complex calculation based on scrypt.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow.png\" alt=\"\" class=\"wp-image-750\" width=\"662\" height=\"268\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow.png 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow-300x120.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow-535x215.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow-16x6.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Flow-499x200.png 499w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/figure><\/div>\n\n\n\n<p>You can choose Data Acation from main menu:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action.png\" alt=\"\" class=\"wp-image-752\" width=\"382\" height=\"194\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action.png 587w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action-300x152.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action-535x272.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action-16x8.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Menu-ata-Action-394x200.png 394w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/figure><\/div>\n\n\n\n<p>Copying data between models is hidden under the name \"Add Cross Model Copy Step\". Firstly, you need to define the source model and the target model, and perform model structure mapping. Additionally, you can use filters to restrict data.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping.png\" alt=\"\" class=\"wp-image-753\" width=\"641\" height=\"285\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping.png 605w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping-300x133.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping-535x238.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping-16x7.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Data-Action-Mapping-450x200.png 450w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/figure><\/div>\n\n\n\n<p>After saving the Data Action, in order to perform data transfter  you need to use the Data Action Trigger in planning interface.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"276\" height=\"288\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Widget-Data-Action-Trigger.png.jpg\" alt=\"\" class=\"wp-image-755\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Widget-Data-Action-Trigger.png.jpg 276w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Widget-Data-Action-Trigger.png-12x12.jpg 12w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Widget-Data-Action-Trigger.png-192x200.jpg 192w\" sizes=\"(max-width: 276px) 100vw, 276px\" \/><\/figure><\/div>\n\n\n\n<p>So, First button is ready to use: 1. Transfer Headcount to Plan<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"697\" height=\"102\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Save-Data-Action-.jpg\" alt=\"\" class=\"wp-image-756\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Save-Data-Action-.jpg 697w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Save-Data-Action--300x44.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Save-Data-Action--535x78.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Save-Data-Action--16x2.jpg 16w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/figure><\/div>\n\n\n\n<p>Result:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action.jpg\" alt=\"\" class=\"wp-image-760\" width=\"784\" height=\"440\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action.jpg 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action-300x168.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action-535x300.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action-16x9.jpg 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Wynik-Initial-Data-Action-356x200.jpg 356w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/figure><\/div>\n\n\n\n<p>Using the graphical interface (Data Action) you can define formula, which modify data according to assumptions:<\/p>\n\n\n\n<ul><li>change  date - from 2020 to 2021<\/li><li>10 % headcount  increase<\/li><\/ul>\n\n\n\n<p>Using the graphic interface (Data Action), a formula has been defined that will transform the data after it is run:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action.png\" alt=\"\" class=\"wp-image-761\" width=\"724\" height=\"338\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action.png 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action-300x140.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action-535x250.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action-16x7.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Graphical-Data-Action-428x200.png 428w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/figure><\/div>\n\n\n\n<p>Second Data Action Trigger is ready to use:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"1024\" height=\"94\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-1024x94.jpg\" alt=\"\" class=\"wp-image-763\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-1024x94.jpg 1024w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-300x28.jpg 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-768x70.jpg 768w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-535x49.jpg 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-16x1.jpg 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1-941x86.jpg 941w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/Dwa-przyciski-Data-Action-1.jpg 1112w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>This way, the initial data is now ready for planning.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication.png\" alt=\"\" class=\"wp-image-764\" width=\"722\" height=\"364\" srcset=\"https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication.png 698w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication-300x150.png 300w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication-535x268.png 535w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication-16x8.png 16w, https:\/\/ad-astra.com.pl\/wp-content\/uploads\/2021\/01\/EN-Reasult-Data-Modyfication-400x200.png 400w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>The next article will describe the use case of filter components and additional popups which help in updating selected planning items.<\/p>\n\n\n\n<p>Link do drugiej cz\u0119\u015b\u0107 artyku\u0142u:<br><a rel=\"noreferrer noopener\" href=\"https:\/\/ad-astra.com.pl\/en\/2021\/02\/01\/sap-analytics-cloud-analytics-designer\/\" target=\"_blank\">https:\/\/ad-astra.com.pl\/en\/2021\/02\/01\/sap-analytics-cloud-analytics-designer\/<\/a><\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Cz\u0119\u015b\u0107 1. Formatka planistyczna z mo\u017cliwo\u015bci\u0105 obs\u0142ugi czynno\u015bci na danych. SAP Analytics Cloud z ka\u017cd\u0105 aktualizacj\u0105 dostarcza bardzo wiele ciekawych funkcjonalno\u015bci, kt\u00f3re \u0142\u0105cz\u0105 ze sob\u0105 \u015bwiat Business Intelligence, planowania i predykcji w jednym \u015brodowisku. Jednym z ciekawszych temat\u00f3w jest wykorzystanie modu\u0142u SAP Analytics Designer, kt\u00f3ry w znacznym stopniu rozszerza mo\u017cliwo\u015bci &hellip;<\/p>","protected":false},"author":3,"featured_media":760,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[10,46,21,58,48],"_links":{"self":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/738"}],"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=738"}],"version-history":[{"count":23,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"predecessor-version":[{"id":863,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/738\/revisions\/863"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media\/760"}],"wp:attachment":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}