2.0 Modeling Release Notes, February

Features and Enhancements

Known Issues

Resolved Issues

Features and Enhancements

Organization of Maps in Folders

Folder Structure Functionality Now Available in Spotlight

Enhanced Dimension Browser

Enhancements to API library

Undo option in Design manager

Additional Enhancements

Organization of Maps in Folders

Similar to views, reports, calculations, and formulas, we’ve added folder structure functionality in SpotlightXL, which allows you to organize your Maps. Additionally, you can add Maps to your Favorites folder by right-clicking on the Map and selecting Add to Favorites. In the example below, the Move Model Map is located in the budget maps folder under the Attribute Example model.

Use the Search functionality at the top of the screen to search for Maps, then use the up and down arrows to scroll through the results.

Favorites and Recent folders are user specific. The Recent folder displays 10 recently accessed Maps by user. The Favorites folder displays 10 Maps. If you add more than 10 items, the most recent 10 are displayed.

You can add folders, delete and rename folders as well as move Maps from folder to folder by dragging and dropping.

Folder Structure Functionality Now Available in Spotlight

The folder structure functionality, currently available in SpotlightXL for Views and Reports, is now available in Spotlight (the web interface).

You can access this functionality by:

• Logging into your Host Analytics Planning application from the web interface and navigating to Modeling.

• Or, via a web browser by entering your Spotlight url.

Select Views or Reports.

Folder Structure for Views

In the image below, Views is selected and the folder structure for all Views (and related models is displayed). Move views to a folder or from one folder to another by dragging and dropping the view.

You can add folders to organize your reports by clicking the Add Folder button or perform a search to find specific reports.

To Rename or Delete a folder, right-click as shown below:

Use Favorites and Recent folders to quickly access your favorite Views or recently accessed Views.

Favorites and Recent folders are user specific. The Recent folder displays 10 recently accessed Views by user across all Models. The Favorites folder displays 10 items. If you add more than 10 items, the most recent 10 are displayed.

Open the folder structure (as shown below) and scroll to the Favorites and Recent folders.

Folder Structure for Reports

If you select Reports, click the Report: Select Report to Run to display the folder structure with reports.

Click Add folder to add a new folder. Drag and drop reports to a folder or from folder to folder.

Rename, Delete, Recent, and Favorites functionality is available for reports as it is for views.

Enhanced Dimension Browser

With this release we have enhanced the dimension browser functionality available in Spotlight (the web interface) to support level based hierarchies for easy navigation within the dimension. In the example below, the Company dimension is displayed. Browse through the level based hierarchy and select a member to display. In the Company hierarchy below, the Everest Holding Group is the root member, Everest Holding Company rolls up to Everest Holding Group, and Canada Research Company is a leaf level member.

Enhancements to API library

With this release we have enhanced the APIs available to load and clear data for external source models.

Clear Data API

The Clear Data API clears existing data from Master and Analytic models based on the scope of the definition. With this release, when clearing data from an external source model, you can opt to clear specific data versus the entire model. To clear specific data, you'll use filters. To clear all model data, you'll use the API without filters. For example, you might opt to clear data for a specific period, a department or a company.

The syntax below provides example syntax to clear data for two fields (each of which have 3 values) from an external source model.

Clear Data - External Source Model

<clear-data-payload>

<model-name>$SourceModelName</model-name>

<filters>

<filter>

<field> </field>

<field-value></field-value>

<field-value></field-value>

<field-value></field-value>

</filter>

<filter>

<field> </field>

<field-value></field-value>

<field-value></field-value>

<field-value></field-value>

</filter>

</filters>

</clear-data-payload>

The sample payload syntax below provides an example to clear data for month 1, 2 and 3 (Periods 1, 2, and 3) for the Sales and Marketing departments.

Sample Payload

<?xml version="1.0" encoding="UTF-8">

<clear-data-payload>

<model-name>My external model</model-name>

<filters>

<filter>

<field>Department</field>

<field-value>Sales</field-value>

<field-value>Marketing</field-value>

</filter>

<filter>

<field>Period</field>

<field-value>Period1</field-value>

<field-value>Period2</field-value>

<field-value>Period3</field-value>

</filter>

</filters>

</clear-data-payload>

Load Data API

With the Load Data API you can now opt to have a success and / or failure notification emailed to you. Sample syntax is provided below.

Notify on Success

<notify-on-success>

<email>email1@domain</email>

<email>email2@domain</email>

</notify-on-success>

Notify on Failure

<notify-on-failure>

<email>email1@domain</email>

<email>email2@domain</email>

</notify-on-failure>

Undo Option in Design Manager

The “Undo” option (shown below) is available in Design Manager when selecting a new member value for a dimension. For example, if you select a new Company instead of Everest Holding Group, and then decide you don’t want to change the value, you can click Undo prior to clicking the Update button, which commits the change.

Additional Enhancements

Calculation Status

The Last Run Status column available in the Calculations section of the Model Setup screen (shown below) will display the last run status only and will not display detailed steps of the Calculation.

Lock / Unlock Model

While hierarchy updates are being processed, the application will not allow a user to unlock a model.

Process Management

On the Manage, Application Administration - Process Management page, Admin users can now see a list of active background calculations that are currently running along with information on the user that submitted the Calculation.

Known Issues

Resolved Issues