Elixir Repertoire User Manual

Release 3.0.0

Elixir Technology Pte Ltd

All rights reserved.

Java is a trademark or registered trademark of Oracle Corporation in the United States and other countries. Microsoft and Windows are trademarks of Microsoft Corporation.

2014


Table of Contents

1. About Elixir Repertoire
Overview
Launching Repertoire Designer
Launching Repertoire Designer with a Specific Report, DataSource or Dashboard
Repertoire Designer Features
2. The Elixir Interface
Overview
Action Bar
Elixir Repository
Types of Files
FileSystems
Working with FileSystems
Working with Files
Recent Files
The Workspace
3. Elixir Repertoire Universe
Overview
Create a Universe
Tables
JDBC Universe Tables
Repository Universe Tables
Settings
Rows
Inspector
Summary
SQL
4. Elixir Safe
Introduction
Using a Safe
5. Elixir JavaScript Editor
Introduction
Function Availability
Referencing JavaScript
6. Function Reference
Overview
General Functions
Average
Comma Separated List
Comma Separated Set
Count
First
Last
Max
Median
Min
Percent
Percent100
PercentCount
PercentCount100
Standard Deviation
Sum
Variance
Year To Date
Month To Date
Additional Cube Functions
Nested Percent Variants

List of Figures

1.1. Repertoire Login Screen
2.1. Elixir Repertoire Main Frame
2.2. Adding New Files and Filesystems
2.3. Import Wizard
3.1. Adding a Universe
3.2. Naming a Universe
3.3. Configuring the Connection Pool
4.1. Add Safe Wizard
4.2. Safe Password Prompt
5.1. JavaScript Editor