Hyperion

Материал готовится, пожалуйста, возвращайтесь позднее

Metadata Sampling Essbase is a multidimensional database engine that provides support for ad hoc analysis. Such analysis is entirely driven by the intuition of the analyst and can be time-consuming as data volume increases. Large cubes tend to have more dimensions and sometimes more levels, making hierarchical navigation very cumbersome. Metadata sampling enables you to analyze large cubes with a focus on data trends or to approximate information in the initial stages. Because you query on a “sample” of members,retrieval is quick. Metadata sampling enables you to drill down on a portion of the vast amount of members in an Essbase database in a fraction of the time that it usually takes to analyze the whole database. You can view many samples in a small amount of time and make early decisions. Later, you can follow with organized data exploration. With the introduction of Hybrid Analysis, you can store part of an Essbase cube in a relational database. Metadata sampling enables you to drill down on all of the data that you specify, whether it is in Essbase or in an underlying relational database. Typical Users of Essbase Essbase can be used in many different applications. Financial analysts have found the product to be invaluable in budget analysis, currency conversion, and consolidation. Cost accountants apply its powerful capabilities to evaluate allocation and elimination scenarios. Product managers and analysts use it to plan and analyze multiple product lines and distribution channels. You can also use the product as a repository database for spreadsheet data. Anyone who uses a spreadsheet is a potential user of Essbase. Because Essbase is applicable to such a broad variety of environments, individuals using it at an organization may fill one or more roles in implementing and running applications. This guide refers to specific roles by three titles. A role may be performed, however, by one person or by several people working collaboratively. ● System administrator. The Essbase system administrator typically has experience in networking, installing software packages, and administering system functions. In addition to installing the Essbase software, the Essbase system administrator may also set up Essbase user accounts, set up the security system, and maintain the Essbase Server. ● Application designer. The application designer sets up the Essbase database, creates the database outline, and develops calculation and report scripts. The responsibilities of the Essbase system administrator and the application designer may overlap in some areas. The application designer has probably developed spreadsheet or database applications and understands the operational problems and the tools being employed to solve them. ● User. The user interacts with Essbase databases through spreadsheets, using Microsoft Excel for Windows. Users are typically analysts and managers who use spreadsheet programs as their primary tool for viewing and analyzing data.