1. Using Quick Launch,choose ANALYTIC VIEW and click create. Alternatively right-click in the navigator pane on the desired package and click NEW and then ANALYTIC VIEW.
2. In the dialog box that comes up fill in the necessary information and Click on Finish.
3.Now you see the below screen.There are 3 parts in Analytic View to be look at (a)Semantics (b)Logical Join and (c)Data Foundation.
4.Data Foundation is in which we built the Fact table by using one or more tables from the Schema.Here i am using only 2 table Sales Order Header and item table from EPM data model.These two tables are joined and output columns are determined like below.By this our fact table is ready with key figures Gross Amount,Net Amount and Quantity.
Note: Only tables are used in the Data Foundation
5. Next step will be Logical Join here we are going to join the Fact table created in above step with other Attribute Views(Dimensions) : Customer and Material
Note: Only Attribute Views(dimensions) are used in the Logical Join.
The Logical Join will look like this.
6. Save and activate the Analytic View. Preview data will look like below.
All the activated Attribute and Analytic Views can found in _SYS_BIC schema(run time objects).
We can use this analytic View in any HANA native development applications like SAPUI5 applications.
Please don't forgot to post comments and correct me if i am wrong.