[sebi123]

When you put together a business intelligence architecture, one of the main requirements you will want to address is being able to provide fast and flexible data analysis. Your relational data warehouse will hold your detail-level transactions, and your users will typically want to summarize this data, add their own calculations, and analyze it with an ad hoc query tool.
You probably know that Oracle Business Intelligence Suite Enterprise Edition provides connectivity to many different relational database platforms and leverages the scalability of relational databases such as Oracle Database 11g to provide fast, integrated access to your detail-level data warehouse. For users with more-complex analytical requirements, though, Oracle Business Intelligence Suite Enterprise Edition can also connect to multi-dimensional data sources such as Oracle’s Hyperion Essbase - System 9, in order to provide access to advanced calculations, forecasts, allocations, cross-dimensional queries, and aggregated data. Like Oracle Business Intelligence Suite Enterprise Edition, Oracle Hyperion Essbase is standards-based, hot-pluggable, and part of the Oracle Fusion Middleware family of products.
This article provides an introduction to Hyperion Essbase, describing its architecture and explaining how it fits in with Oracle’s middleware and business intelligence technology stacks. Later on, you will see how easy it is to build a Hyperion Essbase multidimensional database and then connect it to Oracle Business Intelligence Suite Enterprise Edition, taking data from the Sales History sample schema that comes with most recent versions of Oracle Database.
A Brief Introduction to Hyperion Essbase

Hyperion Essbase is a multidimensional database server. and can be thought of as an “analytic server” that complements Oracle Business Intelligence Suite Enterprise Edition and powers several Hyperion planning and performance management tools.
Named by Information Age magazine—alongside the BlackBerry, Google, Netscape, and Linux—as one of the 10 most influential technology innovations of the past 10 years, Hyperion Essbase is an Online Analytical Processing (OLAP) server that takes data extracts from a range of datasources; calculates and then aggregates this data; and then provides fast access to the results, using a dimensional model.
Hyperion Essbase supports extraction from a wide range of datasources, including Oracle Database 11g and other relational databases, files, and spreadsheets, and provides query access through several APIs and languages, including XML/A and MDX. Like Oracle OLAP, Hyperion Essbase stores its data in a specially optimized multidimensional data store, but unlike Oracle OLAP, stores it outside of a relational database engine, usually on its own dedicated server. With the latest release of Oracle OLAP, organizations typically use it for adding analytics and advanced calculation capabilities to their Oracle data warehouse, whereas Hyperion Essbase is typically used in heterogeneous environments that need to support a range of database, business intelligence, and planning and forecasting tools.
Hyperion Essbase Architecture

Hyperion Essbase is a three-tier application that complements Oracle Business Intelligence Suite Enterprise Edition.
Hyperion Essbase stores its data in special multidimensional databases that are optimized for fast access to aggregated data. Depending on the type of data being stored, Hyperion Essbase can create either “block storage” or “aggregate storage” databases, the former designed for smaller, denser data sets requiring read/write access and the latter designed for sparse, sales-analysis-style applications with lots of dimensions and read-only access. Data can be loaded into Hyperion Essbase databases by use of file imports or direct SQL extracts or through utilities that are provided alongside the Hyperion Essbase database server.
The most important single bit of information in an Hyperion Essbase database is the “outline,” which describes the dimensional and hierarchical structure of the database and details the dimensions, dimension members, hierarchies, measures, derived measures, and key performance indicators it contains.
You can either create a new database and its outline using the command line, or you can use tools such as Hyperion Essbase Administration Services and Hyperion Essbase Integration Services to create your database graphically and define its structure. Using these tools, you can either set up the database outline manually or derive this metadata from the data in a relational star schema.
Once your Hyperion Essbase database is defined and loaded, users of Oracle Business Intelligence Suite Enterprise Edition can import the metadata for their Hyperion Essbase database into their semantic model and report on it, along with their relational data, using Oracle Business Intelligence Answers, Oracle Business Intelligence Interactive Dashboards, and Oracle Business Intelligence Publisher. Oracle Business Intelligence Suite Enterprise Edition uses another Hyperion Essbase utility, Hyperion Essbase Provider Services, to provide native connectivity to Hyperion Essbase through the XML/A API and automatically converts the multidimensional data structures in your Hyperion Essbase database into the relational, dimensional data model that Oracle Business Intelligence Suite Enterprise Edition expects.
So now that you understand the capabilities and architecture of Hyperion Essbase, how do you go about creating an Hyperion Essbase database and plug it in to Oracle Business Intelligence Suite Enterprise Edition? This article shows you how, using data taken from the Sales Analysis sample schema included in Oracle 9i, Oracle Database 10g, and Oracle Database 11g.






__________________________
smart lipo cost
Acai Berry and Dr. Oz Warning Signs Reversing Borderline Sugar Diabetes Impotence Diabetic Diet Soda