Configuring Slice Settings
Slice settings are accessible via the Settings button in the Slice Excel ribbon. Settings are organized into four sections: Connection, Add-In, Pulse for TM1 integration, and Log settings.
Connection Settings
Setting | Description |
|---|---|
Batch Requests | Groups multiple HTTP operations into a single request to reduce latency. Recommended for environments with multiple SUBNM/DIMIX/ELPAR/ELLEV formulas, and for IBM Cloud or PA SaaS. |
Use Async Requests | Enable for IBM Cloud environments to avoid API request timeouts. Not recommended for on-premise. |
Connect Remotely | Tick to connect Slice to a remote Arc server. |
Arc URL | The URL of the remote Arc server. |
Arc Session Time Out | Maximum inactive time before a session is ended automatically. |
Admin Hosts | TM1 Admin hosts used by Slice to discover all running TM1 instances. |
Connections | Manually add name and URL for a TM1 instance. |
Add-In Settings
Setting | Description |
|---|---|
Query Min. Batch Size | Minimum number of DBRWs on a sheet required to trigger batch mode. |
Picklist Max. Size | Maximum number of elements to display in a picklist. |
Calculate on Sandbox Change | Refresh data automatically when the Sandbox selection changes. |
Manual Calculation | Sets Excel calculation mode. |
Multi-Threaded Calculation | Enables multi-threaded calculations in Excel during refresh/rebuild. Reverts to original settings when done. |
Calculate Before Save | Refreshes the workbook before saving to disk. |
Virtual Expression Prefix | Characters used to identify virtual expressions. |
Virtual Consolidation Prefix | Characters used to identify custom rollups. |
Delete AF rows on upload | Removes all rows except the first when uploading an Active Form. |
Confirm view export location | Prompts the user to select an export target when exporting a view. |
Ignore TM1RebuildOption | When enabled, the TM1RebuildOption Excel named range value is ignored. |
Do not Display Version Warning | Suppresses warnings about version mismatches between Arc and Slice. |
DB formulas return *KEY_ERR | Displays |
AI API Key | Unique identifier used to authenticate Slice with an AI service. |
DBS Send Data on Recalc | When enabled, DBS formulas send values to TM1 during sheet/book refresh automatically, hiding the DBS Send button. When disabled, users must press the DBS Send button manually. |
Refresh on Write Back | Recalculates the worksheet or workbook after data is sent or typed into a cell. |
Audit Cell Background Colour | Changes the cell background colour to highlight best practice violations. |
Audit Cell Font Colour | Changes the cell font colour to highlight best practice violations. |
Locale Override | Change local excel setting to pick-up local dott and coma settings. For example, fr-FR can be passed for European dott comma in slice (excel restart is needed after change) |
Pulse for TM1 Integration
These settings enable Slice user activity to be tracked in Pulse for TM1.
Setting | Description |
|---|---|
Pulse Server URL | Host and port where Pulse for TM1 is running. |
Update Stamp | Useful when deploying Slice to end-users to ensure updated settings are applied. |
Sheet Cell Seek Max Row | Maximum number of rows scanned for TM1-related formulas. |
Sheet Cell Seek Max Column | Maximum number of columns scanned for TM1-related formulas. |
Enable Simple TM1 Sheet Check | Checks for the presence of TM1REBUILDOPTION to determine if a worksheet is TM1-based. |
Recalculate First Sheet | Useful when TM1 Server Name or other configuration values are stored on the first worksheet. |
Log Settings
Slice provides structured logs categorized by level: Debug, Info, Warn, and Error. Each level can be enabled or disabled independently. These logs are valuable for maintaining, troubleshooting, and optimizing Excel reports.