Using SpotlightXL-Model

Overview

The Model task in Excel lets you manage all aspects of your models, such as creating models, setting the model type, adding dimensions, changing aggregation values, creating model formulas, copying models, updating dimensions, and loading data. With Model, you can:

• Select a model and run the views or reports associated with it (all users).
• View and edit the model's structure, such as dimensions and attributes (all users with access to the model and dimensions).
• View and edit calculations, formulas, and scopes are associated with the model (Power and Contributor users with access to the model).
• View and edit how data flows into and out of the model and the associated maps (Power and Contributor users with access to the model).

Available SubTasks

When the Model task is selected, several subtasks become available. You can display multiple tabs for a model subtask. You can have one tab open for each Model Subtask unless you open a second Excel instance. Instructions on how to open another Excel instance are provided here. Model Subtasks include all subtasks available when the Model task is selected, as shown below.

The image below shows 3 Model subtasks each open in a separate tab.

How to Display Multiple Tabs for A Model Subtask?

This example uses the Map Subtask.

1. In SpotlightXL, navigate to Model > Map.
2. Click to add a new sheet.
3. Navigate to Model > Calculation.

Now, you can toggle between the tabs to view each map selected on each.

How to Enable Multiple Tabs for A Model Subtask?

The ability to have multiple tabs for a model subtask is not enabled by default. Follow the steps below to enable this functionality.

1. In SpotlightXL, navigate to Manage > Application Administration > Application Settings.
2. Scroll down to the Model Property section of the screen.
3. For Enable SpotlightXL Multi-Tab, select Yes as the Default Value as shown below.

How to Open a Second Instance of SpotlightXL?

Opening multiple instances of Excel allows users to work on several Excel windows simultaneously. This is convenient for handling different tasks without interfering with each other.

1. Right-click on Microsoft Excel.
2. Select Excel.
   
3. When you click Excel while holding the alt key, a prompt will appear to start a new instance. 
4. Click Yes.The second instance of SpotlightXL will appear.
   

Subtasks Described

Each subtask is described below with detailed information.