Data Modeling in SAP HANA provides great amount of flexibility to the end user. One of the key capabilities in Modeling sector of SAP HANA is computation of user required calculations. One of the variations in calculation which end user can perform in Calculation Views/Analytic Views is 'Counter'.
Let us now understand the operations under the hood when stack of Calculation Views are created in a project.
Consider a simple 'Product Details' table which comprise of the product information along with its sales information as shown below:
Let us now understand the operations under the hood when stack of Calculation Views are created in a project.
Consider a simple 'Product Details' table which comprise of the product information along with its sales information as shown below:
| Product | Store | Customer | Quantity | Revenue | Unit |
| Headset | METRO | ALDI | 2 | 120 | PACKG |
| ipad | METRO | ALDI | 10 | 6000 | PACKG |
| ipad | METRO | IBM | 10 | 6000 | PACKG |
| Budweiser | EDEKA | IBM | 360 | 720 | BOTTL |
| Coke | EDEKA | ALDI | 260 | 390 | BOTTL |
| Coke | EDEKA | IBM | 250 | 375 | BOTTL |
| Coke | EBAY | IBM | 200 | 300 | BOTTL |
| Headset | EBAY | IBM | 10 | 600 | PACKG |
| ipad | EBAY | ALDI | 10 | 600 | PACKG |
