For creating the application, we need database to store data.We may require single server or multi-server(Distributed approach) or partitioned database. Hyperion Essbase - Designing Database Contents : Steps to design a database Analyzing and Planning Identifying User Requirements Planning for Security in a Multiple User Environment Creating Database Models Identifying Analysis Objectives Determining Dimensions and Members Analyzing Database Design Repetition in Outlines Inter-dimensional Irrelevance Reasons to Split Databases Checklist to Analyze the Database Design Dimension and Member Properties Designing an Outline to Optimize Performance Loading Test Data Defining Calculations Accounts Dimension Calculations Formulas and Functions Two-Pass Calculations Defining Reports Verifying the Design Following are steps to design a database. Analyzing and Planning: Given the size and performance volatility of multidimensional databases, devel