Overview on Calculation View types in SAP HANA | Different types of calculation views in SAP HANA HD

In this tutorial we have showed what are the different types of calculation view in SAP HANA. The calculation view can be categorized into two types 1. Standard 2. Time-based Standard calculation views are shown below - 1. Dimension 2. Cube 3. Cube with star join 4. Sql Script based Time calculation views are shown below - 1. Gregorian 2. Fiscal Now we will go through each one of those calculation view - A. Dimension 1. Default view is projection. 2. It Is used to expose master data. 3. We can not create measures using the dimension views. 4. If you add any numeric column in the dimension view , it will be considered an attribute. B. CUBE 1. Default view is Aggregation. 2. It Is used to expose attribute and Measures. C. CUBE with STAR Join 1. Default node is star join. 2. It is an extension to cube dimension cube. 3. It follows star join concept like one fact table and multiple dimension table. D. SQL-Script Based 1. We go with SQL script type calculation view when the graphical view does not accomplish your requirement. 2. It can be used for dimension and measures. 3. It can be used internally in the modeling in other calculation view. 4. It can not be used in the external BI clients.(Can not be used end users) TIME calculation view - E. Gregorian – It has granularity like Calyear , Calmonth , Calday and even further to Hrs and Minutes and Seconds. F. Fiscal --- It has granularity as fiscal year and fiscal variant. Both are related to time-based calculation view where data is related to time. It is used to define measure based on different calendar days. ---------------Thank you----------------------------------------- Visit Website – https://www.saplearningacademy.com/ Email / Contact me - saplearningacademy99@gmail.com YouTube channel link - https://www.youtube.com/channel/UCpNJ0Xm35MC5vGbnn8pfryQ To Subscribe – https://www.youtube.com/channel/UCpNJ0Xm35MC5vGbnn8pfryQ?sub_confirmation=1 Watch Tutorial - SAP BW4 HANA – https://www.youtube.com/watch?v=Ow73fb-7IJo&list=PL75hxJGCU0K0E7LGkmZlrTs_Q5HaY_cki Full course tutorial on SQL Script (Procedure) – https://www.youtube.com/watch?v=hWkPoC9rml0&list=PL75hxJGCU0K3oTnhnk09RB73CrobFslbI SQL Basics: Tutorial on SQL - https://www.youtube.com/watch?v=7tCYVgEPxWg&list=PL75hxJGCU0K3YCfDYJ86CT5U1w9KSbKDu SAP BW/BI Tutorial for Developers - https://www.youtube.com/watch?v=6vL0Ys5U_dk&list=PL75hxJGCU0K0Nle5zhdXOxpco1aLLjDeO SAP ABAP Tutorial – https://www.youtube.com/watch?v=50j6MWzPx0A&list=PL75hxJGCU0K3aQ7swD2Fanil5iZspKvN7 SAP BW Integrated planning Tutorial (SAP BW IP) – https://www.youtube.com/playlist?list=PL75hxJGCU0K0qiGwK2V0uGYpyMjvrPSNl SAP HANA and SAP BW on HANA Tutorials for Beginners - https://www.youtube.com/watch?v=znQK6n3ZReE&list=PL75hxJGCU0K0js_XpiuNaWS4ZbK4oz2fu Tutorial on Excel VBA &