TBC manufactures, markets, and distributes soft drink products internationally.Analysts at TBC prepare budget forecasts and compare performance to budget forecasts monthly.Tags: Geography Coursework HelpEssay On Truth And LiesNon Essay Scholarships For High School SeniorsCover Sheet EssayProblem Of Evil Essay PlanEd History Level Coursework Mark SchemeDemocracy EssaySolving Worded ProblemsWriting Claims In An EssayImportance Of Critical Thinking And Teams In The Decision-Making Process
In This Section: Process for Designing a Database Case Study: The Beverage Company Analyzing and Planning Drafting Outlines Checking System Requirements Loading Test Data Defining Calculations Defining Reports Verifying the Design To implement a multidimensional database, you install Essbase, and then you design and create an application and databases.
You analyze data sources and define requirements carefully and decide whether a single-server approach or a partitioned, distributed approach better serves your needs.
For criteria that you can review to decide whether to partition an application, see Guidelines for Partitioning a Database.
Using a case study, this chapter provides an overview of the database planning process and discusses working rules that you can follow to design a single-server, multidimensional database solution for your organization. Figure 25, The Database Design Cycle illustrates the cyclical process of designing a database, which includes the following basic steps: (TBC) and uses TBC as an example to demonstrate how to build an Essbase database. Basic application that is included with the Essbase installation.
For example, a perspective of time may include the time periods that you want to analyze, such as quarters, and within quarters, months.
Each quarter and month becomes a member of the dimension that you create for time.
With Essbase, you can use as many dimensions as you need for analysis.
A typical Essbase database contains at least seven standard dimensions (nonattribute dimensions) and many more attribute dimensions.
Next, consider the relationships among the business areas.
The structure of an Essbase database makes it easy for users to analyze information from many perspectives.