Sheet Details: Level 2 Header

Refresh: This option allows users to update the displayed data, selection, and layout with the most recent information. By clicking the Refresh button, any changes made to the underlying data source or updates made by other users will be reflected in the current view, ensuring that the data is up to date. The time after the refresh is displayed beside it.

Save: This option will save the entered data to the system. A popup dialog will display the number of records updated upon saving.

Toolbar: The toolbar plays a pivotal role in customizing the sheet. It offers a wide range of options for enhancing both the appearance and functionality of the sheet.

1. Import and Export: The Import option lets users import data from an Excel sheet, while the Export option allows for exporting the current sheet to an Excel file.
2. Style: Existing styles can be applied or new ones can be created using this option, enabling users to achieve the desired visual presentation for their data. More details can be found in the Styles section below.
3. Freeze Panes: This function allows specific rows or columns to remain visible while scrolling through large datasets, ensuring important header information is readily accessible. This option can also be used to unfreeze panes.
4. Panel and Grid Options
   • Grid Lines: Users can adjust the visibility of grid lines to enhance the visual appeal and readability of data presentations.
   • Column Headers and Row Headers: The toolbar provides options to toggle the visibility of column and row headers, allowing users to optimize the snippet layout based on their preferences and focus. These features collectively provide enhanced control and flexibility in tailoring the appearance and functionality of snippets to meet specific data analysis requirements.
   • Formula Bar: Access to the Formula Bar is also facilitated from this section. Users can enter formulas in the formula bar that opens below.
5. Data Filtering: The toolbar empowers users to filter data based on specific conditions. This can be achieved by selecting options from a dropdown menu to refine data or by filtering for specific values, thus enabling focused and tailored data selection.
6. Font: Users can choose from existing fonts in the dropdown menu.
7. Font Size: Users can choose the font size from the dropdown menu; the selected size is displayed.
8. Number Formatting: Apply dollar, percentage format, increase or decrease decimal, and number format.
9. Text Formatting: Extensive formatting capabilities are available, allowing bold, italic, and underline styles.
10. Cell Customization: Users can apply cell background color and choose from options to apply to cell borders.
11. Cell Formatting: Cell formatting options for horizontal alignment, vertical alignment, wrap text, indent, and outdent are available here.

Snippet: Enables access to existing snippets and allows the creation of new snippets.

View / Edit: View lets users view data as a report based on the snippet. Edit opens the Report Details tab to modify snippet details.

Insights: Add insight.

Publish: Gives the option to publish and publish as. Publish implies saving the created snippet to the public/private tab, while Publish As implies renaming it.

Sheet Details: To go to the metric list and the Features tabs.

More: This section enables additional options on the sheet. They include:

• Import: To import data from an external workbook into the sheet.
• Export: To export sheet data as an Excel workbook or PDF.
• Copy Scenario: To copy data from one scenario to another.
• Snapshot: To copy data at the current time.

Show / Hide Header: Displays or hides the header for an improved view.

Styles

Styles are formatting patterns that can be applied to a sheet or snippet. A style can be created once and used throughout the workspace. Using the toolbar option on the level 2 header, users have the option to apply, remove, edit, and add new styles. A new style is generally a combination of multiple formatting patterns applied to different types of elements of the sheet. Style details can be created as follows:

Applies To

Styles can be applied to various components, including:

• Row Axis headings: Titles of the row.
• Row Axis members: Members of the row.
• Column Axis members: Members of the column.
• Row Data: Row-wise data in the snippet.
• Column Data: Column-wise data in the snippet.

Member Type

For each component, users have the flexibility to choose from different style categories, including:

• Default: Applicable to all members of the row/column or header.
• Editable: Designed for input members or leaf members.
• Non Editable: Intended for calculated members or parent members.

Metrics members in the sheet will be classified as Editable or Non-Editable:

• By Member: Allows style customization for specific members based on Functional Area and dimension.
• Invalid Member: Tailored for members that do not exist in the Master data.
• Blank Member: Suitable for Member IDs assigned with blank values.

Format

To configure formatting for a chosen style, users can apply formatting to a cell within their sheet, followed by clicking the Pick from Cell option. From here, users can opt to apply the complete format settings mirrored from the selected cell by checking the Select All option. Alternatively, users can deselect Select All and proceed to individually select specific icons for fine-tuning aspects such as Number Format, Alignment, Font, Border, Fill, as well as options for Bold, Italic, and Underline.

Using multiple combinations of Applies To and Member Type, a complete style is created. The sequence of styles applied to the sheet or snippet will remain in the order they were created. This order can be updated by moving the style up or down.

v25.10:  Toggle Spreadsheet View to Grid View

Toggling Spreadsheet View to Grid View allows users to switch between the traditional spreadsheet view and a newly designed grid view without losing context or requiring navigation to different sections of the application. This seamless transition maintains the user's position in the data while changing the presentation format, ensuring continuity in the workflow. The grid view component provides optimized interface for reporting tasks and data analysis.

While the spreadsheet view remains ideal for data entry, formula creation, and traditional sheet operations, the grid view presents data in a format that facilitates easier analysis, comparison, and reporting.

This dual-view approach ensures that users can select the most appropriate interface based on their current task, whether they enter data, build calculations, or generate reports for stakeholders.

Toggling Spreadsheet View to Grid View

To toggle Spreadsheet View to Grid View:

1. Open to the required Sheet from the Navigation Menu.

2. The Sheet displays the Spreadsheet view by default.

   

3. Select the toolbar at the top of the sheet interface.

4. Select the Grid View option to switch from spreadsheet to grid format.

5. The sheet data immediately displays in the new grid component layout.

   

   Note: The data remains consistent between views - only the presentation changes.