Sheet Details: Options

The Options section allows you to control data entry and the display of items with no data.

• Allow Input to Parent Members: By default, data entry is confined to leaf/base members. However, when this option is enabled, it permits data to be inputted at a non-base level. When data is entered at a level above leaf members, it is automatically allocated to the leaf members in accordance with their existing proportions. If the leaf members have no pre-existing values, the allocation is distributed equally among them.
• Display items with no data in rows/columns: When checked, rows/columns without data will still be shown. If unchecked, only rows/columns containing data will be displayed.

Drill Through and Drill Down Enhancement

A new capability has been introduced to enhance data exploration and traceability within JustPerform: users can now drill through and drill down across sheets, dimensions, and referenced components. This feature enables users to navigate complex data relationships, uncover dependencies, and gain deeper insights into how different elements interact across pages.

The enhancement introduces a “Related Pages” interface, allowing users to link sheets, snippets, remote tables, and dimensions that are referenced within a given sheet. Once linked, the system automatically identifies and displays common dimensions and metrics, helping users understand shared data structures and lineage. This contextual drill-through experience improves transparency in data modeling and supports more intuitive analysis across reporting layers.

Users can also customize the filter context when navigating between related pages—choosing from FA context, cell context, fixed members, or drill-through options—ensuring that the data passed between views aligns with their analytical needs. Non-common dimensions can be manually added to the drill view, giving users full control over what data is visible and how it’s filtered.

Key Benefits

• Enables users to drill through and drill down across sheets and referenced components.
• Allows linking of related sheets, snippets, remote tables, and dimensions for contextual navigation.
• Automatically identifies and displays common dimensions and metrics between linked pages.
• Supports customizable filter contexts for precise data exploration.
• Provides flexibility to include non-common dimensions in drill views.
• Enhances transparency in data modeling and cross-page analysis.
• Improves user productivity by simplifying navigation across complex reporting structures.

Using Drill Through and Related Pages – Step-by-Step

1. Open the target sheet and access the “Related Pages” section under sheet options.
2. Click the “Add” icon to link a sheet, snippet, remote table, or dimension.
3. View auto-populated common dimensions and metrics shared between pages.
4. Select the desired filter context (e.g., FA context, cell context, fixed members).
5. Optionally include non-common dimensions by selecting and confirming them.
6. Navigate to the related page to explore its structure and shared data elements.

This feature empowers users to explore data relationships with clarity and precision, transforming how they interact with multi-layered reports and accelerating decision-making across the organization.