Explore the Gallery Templates

Gallery templates are application workbooks that you can use to build fully functional Essbase cubes. Think of these templates as starter kits you can use not only to build cubes, but to learn about Essbase features, and to model a variety of analytical problems across business domains.

The gallery templates include README worksheets, describing the purpose and usage of the workbook and cube.

Gallery templates are packaged in the form of an application workbook, and may also have additional supporting files. You use an application workbook to create an application and cube using either of these methods: the Import button in the Essbase web interface, or the Build Cube button on the Cube Designer ribbon in Excel. To access the gallery from the Essbase web interface, click Files and navigate to the gallery section. To access the gallery from Cube Designer, use the Essbase button on the Cube Designer ribbon.

The gallery templates are grouped into the following categories:

Applications Templates

Gallery templates in the Applications folder demonstrate various business use cases for Essbase across several organizational domains.

The following cubes, located in the gallery > Applications > Sales and Operations Planning folder, connect together to perform their respective aspects of sales and operational planning tasks:

Forecast Consensus—develop and maintain an agreed-upon forecast shared across departments
Demand Consolidation—forecast customer demand
Production Schedule—compute a weekly master production schedule for all products and locations
Capacity Utilization—ensure that existing plant capacity can handle the production schedule

Compensation Analytics illustrates how Human Resources analysts can perform headcount and compensation analysis, analyze attrition, and allocate compensation increases.

Organization Restatements demonstrates how operational expenses can be restated, after organizational changes, for internal management reporting.

Opportunity Pipe demonstrates how to manage a sales pipeline.

Spend Planning shows how procurement analysts can manage operational spending using top-down and bottom-up forecasting methods.

Project Analytics demonstrates project planning risk analysis, accounting for factors such as workforce skills and costs, revenue, margin, inventory, and schedule.

RFM Analysis demonstrates how to identify the most profitable customers based on metrics.

Consolidation Eliminations is a financial analysis application demonstrating how to identify and eliminate balances between two companies.

Organization Restatements is a financial analysis application demonstrating how to restate expenses after an organizational change.

In addition to these business applications, the Applications grouping of templates also includes:

Demo Samples— simple examples of block storage and aggregate storage cubes commonly referenced in Essbase documentation.
Utilities—cubes that may be utilized by other sample cubes. For example, the Currency Rates template takes currency symbols and returns the exchange rate to USD. The Currency Triangulation template uses a calculation script to triangulate currencies.

Technical Templates

The Technical templates demonstrate the use of specific Essbase features.

Calc: Allocation Tracing—perform allocations and debug calculation scripts
Calc: Sample Basic RTSV—pass member names into a calculation script using runtime substitution variables
Calc: Zigzag Calculation—learn how Essbase performs complex calculations across a time dimension
Calc: CalcTuple Tuple—optimize asymmetric grid calculations across dimensions
Drill Through: Drillthrough Basic—drill through to external sources to analyze data outside of the cube
Filters: Efficient Filters—design and use variable data-access filters
MDX: AllocationMDX Insert—allocate and insert missing values
Partitions: Realtime CSV Updates— access real-time data
Solve Order: UnitPrice SolveOrder—use and understand solve order in a hybrid mode cube
Solve Order: Solve Order Performance—compare query performance using dynamic calculations versus using stored members and a calculation script
Table Format— build Essbase cubes from tabular data
UDA: Flip Sign— learn how to flip signs of data values during a data load to meet reporting requirements

System Performance Templates

System performance templates monitor system status for optimization purposes.

The Health and Performance Analyzer helps you monitor usage and performance statistics of your Essbase applications.

The Analyzer enables you to scan Essbase logs. After parsing the data, it compiles a csv Excel worksheet, optionally on the time interval that you set in Settings. Then, you can use the csv files to build charts and other displays.