{"id":566,"date":"2020-12-24T10:42:00","date_gmt":"2020-12-24T09:42:00","guid":{"rendered":"https:\/\/ad-astra.com.pl\/?p=566"},"modified":"2021-01-22T10:57:18","modified_gmt":"2021-01-22T09:57:18","slug":"warstwa-biznesowa-w-data-warehouse-cloud-czesc-2","status":"publish","type":"post","link":"https:\/\/ad-astra.com.pl\/en\/2020\/12\/24\/warstwa-biznesowa-w-data-warehouse-cloud-czesc-2\/","title":{"rendered":"Business Layer and Data Warehouse Cloud \u2013 part 2"},"content":{"rendered":"

Part 1 <\/a><\/p>\n\n\n\n

Part 3<\/a><\/p>\n\n\n\n

In the previous article, we created Dimension Type Business Entities based on text tables for Dealer and Location.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In this article, we will focus on two topics:<\/p>\n\n\n\n

  1. Create Business Entities based on master data for the dealer<\/li>
  2. Create Business Entities based on transactional data (Analytical Dataset)<\/li><\/ol>\n\n\n\n

    Part 1<\/strong><\/p>\n\n\n\n

    We will start by creating Business Entity based on the Dealer_Master table. This table contains the location allocation for the dealers.<\/p>\n\n\n\n

    (Data structure preview for Dealer_Master):<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    For this Entity, we need to :<\/p>\n\n\n\n

    1. Create two keys<\/strong> - one for the Dealer and second one for the Location. We will use them to link the Entity to objects containing Dimension descriptions from previous article<\/li><\/ol>\n\n\n\n

      To do this, go back to Business Builder and click on New Dimension. We choose the Dealer_Master table as the source.<\/p>\n\n\n\n

      Set the public acess data for Entity, change the name (in our case - MD_DEALER) and save. Then select the Attributes tab.<\/p>\n\n\n\n

      Using the button located next to the Plus Button, we can quickly add all the fields contained in our source. Next, go to the Key Definitions tab.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Using the plus button we can create a new key definition. As KeyField<\/strong> select the Dealer field, in KeyField Title<\/strong> and KeyField<\/strong> enter \u201cDealerID\u201d. Verify and save. Next, we create another key, this time based on the Location field. Name it LocationID. The result should look like the image below.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Next, go to the Associations<\/strong>. Entities that are linked via associations are available as attributes when creating a Consumption Model.<\/strong> As we want to have access to previously created dimension descriptions in the model, click the plus button to add a new association.<\/p>\n\n\n\n

      For the Target Business Entity<\/strong> field select TXT_DEALER Entity and click Apply.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      For the Foreign Key Field<\/strong> we select the Entity field that will be used for key mapping. In this case, we select the Dealer object.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Next we create another association and perform the same steps for the TXT_LOCATION object:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Part 2<\/strong><\/p>\n\n\n\n

      Now we will try to create Analytical Dataset Entity using transactional data. To do this, go to Business Builder and select New Analytical Dataset, and then select the SALES_TABLE table.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      (Data structure preview for SALES_TABLE):<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Switch on the Public Data Access option and change the name of the Entity (in our case \u201cFCT_SALES\u201d). Then, to define the measures, go to the Measures<\/strong>tab. By using the button next to the Plus button, we can quickly add all the measures to the model.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Then we can edit each of the added measures to define the appropriate unit or currency field.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Teraz po\u0142\u0105czymy si\u0119 utworzon\u0105 przed chwil\u0105 jednostk\u0105 zawieraj\u0105ca dane podstawowe dla Dealera. W tym celu przechodzimy do zak\u0142adki Associations<\/strong> tab and add a new association using the plus button. Select MD_DEALER from the available Entities.<\/p>\n\n\n\n

      For the Foreign Key Field<\/strong> select the Dealer object and then save.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      By adding this association, the Dealer and Location fields will now be available in the model. Below is an overview of the structure we have created so far<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      In the next article, we will use the previously created Business Entities to create a model and then consume it in SAP Analytics Cloud. <\/p>","protected":false},"excerpt":{"rendered":"

      Cz\u0119\u015b\u0107 1 Cz\u0119\u015b\u0107 3 W poprzednim artykule utworzyli\u015bmy jednostki biznesowe na podstawie tabel z opisami dla wymiar\u00f3w. W tym artykule skupimy si\u0119 na dw\u00f3ch zagadnieniach : Tworzenie jednostek biznesowych dla danych podstawowych dla Dealera Tworzenie jednostek biznesowych dla danych transakcyjnych (Analytical Dataset) Cz\u0119\u015b\u0107 1 Zaczniemy od utworzenia jednostki biznesowej na …<\/p>","protected":false},"author":2,"featured_media":589,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17,13],"tags":[34,38,10,43],"_links":{"self":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/566"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/comments?post=566"}],"version-history":[{"count":8,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/566\/revisions"}],"predecessor-version":[{"id":736,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/566\/revisions\/736"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media\/589"}],"wp:attachment":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media?parent=566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/categories?post=566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/tags?post=566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}