Examples of Report Scripts

The example Essbase Report Writer scripts in this section demonstrate report procedures and formats frequently required in business settings.

The samples use both the Demo Basic and Sample Basic cubes provided in the gallery.

The sample reports demonstrate the following techniques:

• Sample 1: Creating a Different Format for Each Page

• Sample 2: Handling Missing Values

• Sample 3: Nesting Columns

• Sample 4: Grouping Rows

• Sample 5: Reporting on Different Combinations of Data

• Sample 6: Formatting Different Combinations of Data

• Sample 7: Using Aliases

• Sample 8: Creating Custom Headings and % Characters

• Sample 9: Creating Custom Page Headings

• Sample 10: Using Formulas

• Sample 11: Placing Two-Page Layouts on the Same Page

• Sample 12: Formatting for Data Export

• Sample 13: Creating Asymmetric Columns

• Sample 14: Calculating Columns

• Sample 15: Calculating Rows

• Sample 16: Sorting by Top or Bottom Data Values

• Sample 17: Restricting Rows

• Sample 18: Ordering Data Values

• Sample 19: Narrowing Member Selection Criteria

• Sample 20: Using Attributes in Member Selection

• Sample 21: Using the WITHATTR Command in Member Selection