Slice Assistant Tools Overview

The Slice Assistant exposes 40 tools that live in the Excel add-in under desktop/addin/AI/Tools/, split across three executors (Excel, Slice, Arc) behind a common ToolRegistry. Instead of a chat/change split, Slice uses a RequiresConfirmation flag: every tool that mutates an Active Form asks the user to confirm before executing (marked CONFIRM below), while routine actions run without confirmation.

Excel tools (13)

Generic workbook manipulation.

Tool	Purpose

Tool	Purpose
`get_selection`	Returns the current selection (addresses, values, formulas)
`read_range`	Reads any range on any sheet (capped at 400 cells)
`workbook_overview`	Lists all worksheets with their used ranges
`find_in_workbook`	Searches values or formula text across the workbook
`select_range`	Activates a sheet, selects a range and scrolls it into view
`set_cell`	Writes a value or formula to a single cell
`write_block`	Writes a 2D block of values/formulas in one shot
`clear_range`	Clears contents and/or formats of a range
`format_range`	Applies formatting (hex colors, US number formats)
`apply_conditional_format`	Adds native Excel conditional-formatting rules
`audit_active_worksheet`	Audits the active sheet for TM1 formula issues, producing a stats workbook
`audit_active_workbook`	Same audit across the whole workbook
`highlight_bad_cells`	Interactive step-by-step reviewer of TM1 best-practice violations

Slice / TM1 tools (26)

Tool	Purpose

Tool	Purpose
`tm1_cube_list` / `tm1_view_list` / `tm1_process_list` / `tm1_dimension_list`	Catalog browsing on a connected TM1 instance
`tm1_element_list`	Lists dimension elements; the filter matches both Name and all attribute values (handles localized models)
`resolve_element`	Resolves fuzzy element names (e.g. "avril", "fiscal Q2") via date-format strategies
`insert_dbr`	Inserts a `=DBR(...)` formula into a cell
`insert_active_form`	Inserts an Active Form for a (cube, view) at the active cell
`slice_af_structure`	Describes the selected Active Form's structure (axes, titles, data range), called before any AF change
`slice_af_add_column` / `slice_af_add_row`CONFIRM	Adds elements to an AF axis
`slice_af_remove_column` / `slice_af_remove_row`CONFIRM	Removes elements from an AF axis
`slice_af_add_descendants`CONFIRM	Expands a consolidated row into its descendants
`slice_af_set_title`CONFIRM	Changes a title dimension's selected element
`slice_af_set_subset`CONFIRM	Changes the subset driving an AF axis
`slice_af_pivot`CONFIRM	Pivots the Active Form (swaps axes)
`slice_conditional_format`CONFIRM	Slice-specific conditional formatting
`slice_crossdrill_list` / `slice_crossdrill_run`	Lists then promotes a title dimension to the rows axis (cross-drill)
`slice_drillthrough_list` / `slice_drillthrough_run`	Lists then opens drill-through scripts for the selected cube cell
`slice_refresh_sheet` / `slice_rebuild_sheet` / `slice_refresh_book` / `slice_rebuild_book`	The four ribbon recalc/rebuild actions, marshaled onto Excel's macro thread

Tools marked CONFIRM mutate an Active Form and prompt the user to confirm before executing.