Table of Contents
- Title and Copyright Information
- Preface
- 1 Get Started with Oracle Analytics Cloud – Essbase
-
2
Top Tasks for Essbase
- Top Tasks Prerequisites
- Create Users in LDAP Identity Management Mode
- Import and Export Bulk Users in LDAP Identity Management Mode
- Understand Application Workbooks
- Explore the Gallery Templates
- Create an Application in the Essbase Web Interface and Provision a User to Access and Query the Cube
- Analyze an Application in Smart View
- Modify an Essbase Outline
- Manage Jobs
- Analyze Forecast Data in Smart View
- Create an Application and Cube in Cube Designer
- Analyze Data and Perform an Incremental Update in Cube Designer
- Transform Tabular Data into a Cube
- Export and Modify Metadata and Data
- 3 Manage Essbase Files and Artifacts
- 4 Understand Your Access Permissions in Essbase
- 5 Manage Users and Roles
- 6 Design and Create Cubes Using Application Workbooks
- 7 Design and Create Cubes from Tabular Data
-
8
Create and Manage Cube Outlines Using the Web Interface
- About Cube Outlines
- View and Edit Outline Properties for a Newly Created Cube
- Create a Sample Cube to Explore Outline Properties
- Add Dimensions and Members to Outlines
- Work with Attributes
- About Duplicate Member Names
- Set Dimension and Member Properties
- Name Generations and Levels
- Set Advanced Cube Properties
- Unlock Objects
- Remove Data Locks
- 9 Use Connections and Datasources
- 10 Build Dimensions and Load Data
- 11 Calculate Cubes
-
12
Model Data in Private Scenarios
- Understand Scenarios
- Scenario Workflow
- Enable Scenario Modeling
- Work with Scenarios
-
13
Work with Cubes in Cube Designer
- About Cube Designer
- About the Cube Designer Ribbon
- About the Designer Panel
- Manage Files in Cube Designer
- Download Sample Application Workbooks from the Cloud
- Build a Private Inventory of Application Workbooks
-
Work with Application Workbooks in Cube Designer
- Limitations of Application Workbooks
- Work with the Essbase.Cube Worksheet in Cube Designer
- Work with the Cube.Settings Worksheet: Alias Tables in Cube Designer
- Work with the Cube.Settings Worksheet: Properties in Cube Designer
- Work with the Cube.Settings Worksheet: Dynamic Time Series in Cube Designer
- Work with the Cube.Settings Worksheet: Attribute Settings in Cube Designer
- Work with the Cube.Settings Worksheet: Substitution Variables in Cube Designer
- Work with Dimension Worksheets in Cube Designer
- Work with Data Worksheets in Cube Designer
- Work with Calculation Worksheets in Cube Designer
- Create a Cube from a Local Application Workbook in Cube Designer
- Work with Text Lists Worksheets in Cube Designer
- Create a Cube from Tabular Data in Cube Designer
- Update Cubes Incrementally in Cube Designer
- Create and Validate Member Formulas in Cube Designer
- Load Data in Cube Designer
- Calculate Data in Cube Designer
- Work with Jobs in Cube Designer
- View Dimension Hierarchies in Cube Designer
- Export Cubes to Application Workbooks in Cube Designer
- Delete Applications and Cubes in Cube Designer
- View Logs in Cube Designer
- 14 Export Cubes to Application Workbooks
- 15 Track Changes to Data
- 16 Link Cubes Using Partitions and XREF/XWRITE
- 17 Migrate Applications
- 18 Configure Cloud Service Resource Limits and Application Configuration Properties
-
19
Essbase Command-Line Interface (CLI)
- Download and Use the Command-Line Interface
-
CLI Command Reference
- Login/Logout: CLI Authentication
- Calc: Run a Calculation Script
- Clear: Remove Data from a Cube
- Createlocalconnection: Save a JDBC Connection
- Dataload: Load Data to a Cube
- Deletefile: Remove Cube Files
- Deploy: Create a Cube from a Workbook
- Dimbuild: Load Dimensions to a Cube
- Download: Get Cube Files
- Help: Display Command Syntax
- LcmExport: Back Up Cube Files
- LcmImport: Restore Cube Files
- Listapp: Display Applications
- Listdb: Display Cubes
- Listfiles: Display Files
- Listfilters: View Security Filters
- Listlocks: View Locks
- Listvariables: Display Substitution Variables
- Setpassword: Store CLI Credentials
- Start: Start an Application or Cube
- Stop: Stop an Application or Cube
- Unsetpassword: Remove Stored CLI Credentials
- Upload: Add Cube Files
- Version: Display API Version
- 20 Manage Essbase Using the MaxL Client
- 21 Analyze Data in the Web Interface
- 22 Work with Logs
- 23 Analyze Cube Data with Drill Through Reports
- A Application Workbooks Reference
- B Set up Cube Designer
- C Essbase Calculation and Query Processor