{"id":594,"date":"2021-01-04T08:52:51","date_gmt":"2021-01-04T07:52:51","guid":{"rendered":"https:\/\/ad-astra.com.pl\/?p=594"},"modified":"2021-01-14T10:51:41","modified_gmt":"2021-01-14T09:51:41","slug":"warstwa-biznesowa-w-data-warehouse-cloud-czesc-3","status":"publish","type":"post","link":"https:\/\/ad-astra.com.pl\/en\/2021\/01\/04\/warstwa-biznesowa-w-data-warehouse-cloud-czesc-3\/","title":{"rendered":"Business Layer and Data Warehouse Cloud - part 3"},"content":{"rendered":"

The previous articles can be found HERE<\/a> and HERE<\/a>. We have created the following Business Entitiy structure in them.<\/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. Creating a Consumption Model<\/strong><\/li>
  2. Creating and deploying a Perspective<\/strong><\/li><\/ol>\n\n\n\n

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

    We will start by creating a model based on an already created Entity structure. To do this, go to Business Builder and select New Consumption Model<\/strong>.<\/p>\n\n\n\n

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

    First, we enter the model title (in our case, SALES_MODEL). Next, click the Step 2 button.<\/p>\n\n\n\n

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

    In the next step, select Fact Source (in our case FCT_SALES) and click the Step 3 button.<\/p>\n\n\n\n

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

    Click the Create<\/strong>button to finish creating the model. The model graphical interface should appear.<\/p>\n\n\n\n

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

    How to add a dimension to the model:<\/p>\n\n\n\n

    a) Aby wykorzysta\u0107 wcze\u015bniej zdefiniowane asocjacje klikamy na tabel\u0119 FCT_SALES na \u015brodku interfejsu,  a nast\u0119pnie wybieramy opcj\u0119 Show Source Graph.<\/strong><\/p>\n\n\n\n

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