Oracle Essbase Studio 11.1.1: Create and Manage Data Structures

In today′s fast-paced world of business intelligence, Essbase developers must be able to build applications quickly and efficiently, often using a variety of data and metadata sources. Essbase professionals need a tool that consolidates cube construction activities into one single interface, with consistent performance for data loading and outline building. Essbase Studio is that tool, providing unified deployment and management of the cube factory from one interface.This course gives you the information you need to build your Essbase models quickly from many sources, giving you more time to interpret results and modify your models as required. Whether you are sourcing from a data warehouse, flat files, or an Essbase cube you have already built, you can use (and reuse) those sources for the next project--and the next one after that. In addition, we will show you features such as lineage tracking (showing you in an instant where an element change affects other applications) and drill-through (for the extra-cube details you need) to bring your Essbase modeling to the next level.Learn To:Describe the Essbase Studio implementation processDescribe the Essbase Studio architectureCreate logical star schema data marts from E-R dimensional database schemas and flat filesBuild metadata elements, hierarchies, schemas, and cube modelsLoad dimension members and data to Essbase cubesDefine drill-through reports to relational tables* Consider registering for Oracle Essbase Studio 11.1.2: Create and Manage Data Structures, if a convenient 11.1.1 class is not available.

• Data Warehousing and Business Intelligence
• Essbase Studio Deployment Architecture
• Data Source Connections
• Metadata Elements and Alias Sets
• Working with Minischemas
• Hierarchies
• Cube Schemas
• Essbase Models
• Deploying Cubes and Applications
• Drill through Reporting
• Lineage

Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?


Vraag informatie aan

Gedetailleerde onderwerpenlijst

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Essbase Studio 11.1.1: Create and Manage Data Structures behandeld zullen worden:

• Data Warehousing and Business Intelligence
• Business challenges
• Business Information Analysis
• Business Intelligence (BI)
• Enterprise performance management (EPM)
• Data warehousing
• Hyperion EPM and data warehousing
• Essbase Studio and data warehousing
• Essbase Studio Deployment Architecture
• Essbase Studio architecture
• Essbase Studio Client Overview
• Essbase Studio directory structure
• Essbase Studio properties files
• Essbase Studio catalog
• Essbase Studio Help files
• Data Source Connections
• Defining connection parameters
• Creating connections to relational, Dimension Server, and text data sources
• Working with data source connections
• Creating connections with Connection wizard
• Using introspection
• Defining minischemas
• Metadata Elements and Alias Sets
• Creating metadata elements
• Working with metadata elements
• Creating folders to organize your metadata elements
• Creating and working with alias sets
• Working with Minischemas
• Creating minischemas
• Managing minischemas (open/view/save/set properties/refresh)
• Creating logical objects
• Adding and deleting joins between tables
• Viewing sample data from tables or individual columns
• Hierarchies
• Creating standard hierarchies
• Creating measures hierarchies
• Creating specialized hierarchies
• Creating calendar hierarchies
• Defining consolidation levels
• Cube Schemas
• Building cube schemas with Cube Schema Wizard
• Choosing measures and hierarchies for a cube schema
• Setting cube schema options
• Defining data load mappings
• Creating Essbase models from existing cube schemas
• Essbase Models
• Setting model-level properties
• Modeling standard attributes
• Modeling varying attributes
• Setting member properties
• Performing alias mapping
• Adjusting hierarchy build settings
• Modifying transformation settings
• Mapping properties to database columns
• Deploying Cubes and Applications
• Deploying cubes using Cube Deployment Wizard
• Setting load options for deploying cubes
• Creating and saving a rules file
• Performing a ⿿lights out⿿ deployment
• Modifying Essbase model properties
• Managing deployed applications
• Drill through Reporting
• Creating drill-through reports
• Associating reports for drill-through
• Associating drill-through with Essbase models
• Setting query governors
• Testing functionality during report design
• Utilizing drill-through reporting in Smart View
• Lineage
• Opening Lineage Viewer
• Navigating through the lineage
• Viewing the history of an element
• Launching Administration Services Console from Lineage Viewer
• Editing element properties
• Editing Essbase model properties
• Showing deployment history
• Viewing sample data

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.