The Dimension tables list the factors (Customer, Time, and Product) by which we want to analyze the data.
The fact table lists events that happen in our company (or at least the events that we want to analyze- No of Unit Sold, Margin, and Sales Revenue). And, in a complete example, we would also have a product table and a time table so that we know what she bought and exactly when. Every sale is a fact that happens within the company and the fact table is used to record these facts.įor example, row 3 in the fact table records the fact that customer 1 (Brian) bought one item on day 4. You can watch Ruby Octroi Loses Her Footjob Virginity porn video clip on your favorites from web. Suppose a company sells products to customers. Dimension tables are used to create schemas with fact tables and can be normalized.Įxample of Dimension Table − Customer, Product, etc. They are joined with Dimension tables in HANA Views to meet business logic.Įxample of Measures − Number of unit sold, Total Price, Average Delay time, etc.ĭimension Table contains master data and is joined with one or more fact tables to make some business logic. Fact and Dimension Tableįact Table contains Primary Keys for Dimension table and measures.
Dim tables are defined with master data and Fact table has Primary Key for dimension tables and measures like Number of Unit sold, Average delay time, Total Price, etc. You can create new Package under Content tab in HANA studio using right click on Content and New.Īll Modeling Views created inside one package comes under the same package in HANA studio and categorized according to View Type.Įach View has different structure for Dimension and Fact tables. HANA Modeling is done on the top of tables available in Catalog tab under Schema in HANA studio and all views are saved under Content table under Package.
These views are consumed by JAVA/HTML based applications or SAP Applications like SAP Lumira, Office Analysis or third party software like MS Excel for reporting purpose to meet business logic and to perform analysis and extract information. A Brisbane private schoolboy who kept on his school computer photograghs of his teenage girlfriend raping her nine-year-old sister has been jailed for four months. SAP HANA Modeler option is used to create Information views on the top of schemas → tables in HANA database.