Contact Us
Index
Version 25.2
Version 20.3 Version 20.4 Version 21.1
Contact Us
Combine Text
Last Refreshed By
Split Text
Last Refreshed Time
Snapshot
Common Options
Shared Templates Drive
Edit a File
File Server
Oracle Cloud Connector Database
Navigator
Open a File
Create a File
Drive Types
Dropbox
Delete a File
System Administrator Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator User Options
System Administrator Server Information
Discover Period Names
Discover Segment Properties
Expand and Explode
Explode Segment Values
Explode Segment Value Hierarchy
Expand Segment Value Hierarchy
Expand Segment Values
Discover Segment Values
Discover Level
List of Values – Create
Period Name
Ledger Name
Segment Description
Ledger Set
Segment End Date
Next Segment Value
Account Type
Segment Tree
Parent Flag
Enabled Flag
Segment Start Date
Get Balance
Multiple Ledgers
Get Balance Options
Financial Category
Period Offset
Functional Currency
Previous Segment Value
Period End Date
Period Start Date
Period Name by Date
Drill Using a Saved Template
Analyze Balances
Drill to Journal or Subledger
Drill Criteria Sheets
Drill Criteria – Journal Extract
Drill Criteria – Balance
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand User Options
Other Tools
Hide Zeros
Advanced Options
Email
Drilldowns
Parameters
Source Report
Named Ranges
Execution
Load and Validation
Running the Scheduler
Create Schedule
SMTP Email Settings

Expand and Explode

Expand

Expanding a selection will insert rows below the selection and display the lowest level child values, the segment hierarchy (full hierarchy or just one level) or account combinations depending on which expand option you select. The available options are:

Explode

Exploding a selection will duplicate the current Excel sheet for the lowest level child values, the segment hierarchy (full hierarchy or just one level) or account combinations depending on which explode option you select. The available options are: