March 2025 (v25.3)

2.1.2 Modeling Release Notes, July

23 Minutes to read

Print
Dark
Light
PDF

2.1.2 Modeling Release Notes, July

23 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Substitution Variables and Expressions

Substitution variables are used in reports in place of dimension member names. In this release, reports can be defined using substitution variables that can be dynamically modified at runtime by end users, and administrators and designers now have the option to set up reports using substitution variables with expressions.

The substitution variables can be dynamically modified at runtime. Previously, if a report was set up to use a substitution variable, the report would always run with the predefined value of the substitution variable. To change the value, an admin or designer had to change it manually using the Model > Model Administration > Substitution Variables page.
- Any level of user can now change the value of substitution variables while running a report. The new value is used during that session, but the report reverts back to the original substitution variable value the next time the report is run. For example, a designer may set up a report with a substitution variable defined as CurMth = January 2017. The end user can change the value to July 2017 when running the report. The next time the report is run, January 2017 is used by default but again can be changed easily at runtime.
- Selecting a different dimension member name is available in SpotlightXL and Spotlight.
Administrators and designers can set up substitution variables with expressions. Expressions are added to a substitution to derive another member name from the same dimension.
Substitution variables are most commonly used in the Time and Scenario dimensions.

Note:

Changing the value of a substitution variable is similar to the concept of selecting a dimension member from a POV on the page axis. When you change the POV or the value of the substitution variable, the data is refreshed. The difference is that a substitution variable can be placed anywhere in the report, such as a row or column axis.

Here is the overall process:

Admin or designer creates one or more substitution variables in the model.
Admin or designer creates one or more reports that use the substitution variables.
Any user with access to the report can run it and change the value of the substitution variable, provided they have security access to the dimension.

Select from the following topics for more details:

Creating Substitution Variables for Reports

Using Substitution Variables in Reports

Selecting a Different Value for a Substitution Variable at Runtime

Expressions

Expression Chains

Converting Existing Reports with Substitution Variables to Use Expressions

Using Substitution Variables with Excel-based Reporting

Best Practices

Limitations

Future Options

Creating Substitution Variables for Reports

To set up formatted reports with substitution variables for use at run-time, an administrator or designer must first create the substitution variables. This functionality was introduced in Release 1.2. As a reminder, here's how:

Select Model > Model Administration > Substitution Variables.
Select the model and dimension name from the list boxes.

Tip!

You can see a list of all substitution variables created for all models by selecting All Models and All Dimensions from the list boxes.

Enter the variable name with plain text. Avoid using the symbol @ in the variable name. For example, CurMth or Current Month. Variable names are case sensitive.
Specify the starting value for this variable. This value must be the same as a dimension member name in your model. For example, Jan-17.
Optionally, specify the model that the variable will be used on.
Optionally, specify the dimension that the variable relates to. For example, Time.
Click Save.

Note:

Substitution variables used in reports are different than variables created for calculations or maps. Always use Model > Model Administration > Substitution Variables to create substitution variables for reports.

If you make a mistake, simply delete the row containing the substitution variable that you created, then click Save to delete it.

Using Substitution Variables in Reports

To set up a report to use one or more substitution variables:

Lay out the report with standard items, such as headings, rows, and columns.
While in Report Design mode, select the cells containing the dimension member to be replaced with a substitution variable.
Click Design Manager. Notice that the current value is a regular dimension member, Jan-2017.
Click the Member Selection icon, then Select Member.

Click Select Member. At the top of the member selection box, notice that Substitution Variables are listed first.
Select @CurMth@ and click Select.

Now the Design Manager reflects the change from the original value (Jan-17) to the Substitution Variable @CurMth@. Also shown in light gray is the predefined value of CurMth.

Click Update. The report now displays @CurMth@ in place of the 4 cells you originally selected.

Now you need to update the data cells to also use the substitution variable.

Select all the data cells. In this example, columns B and C are data cells, while columns D and E contain Excel formulas.
Click Design Manager. Scroll to the Time dimension. Notice that the current value is a regular dimension member, Jan-2017.
Click the Member Selection icon, then Select Member.

Click Select Member. At the top of the member selection box, notice that Substitution Variables are listed first.
Select @CurMth@ and click Select.

Now the Design Manager reflects the change from the original value (Jan-17) to the Substitution Variable @CurMth@. Also shown in light gray is the predefined value of CurMth.

Click Update. The report now displays UPDATED in place of the data cells you originally selected.
Click Save to save your report.

Selecting a Different Value for a Substitution Variable at Runtime

When the end user runs a report, if it contains a substitution variable, a new icon automatically appears on the menu ribbon.

With the cursor anywhere in the report, click Substitution Variables. The Substitution Variables box appears. It shows the name of the variable and the current value.
Click the Member Select icon.

From the member selection box, select the month that you want to see in the report.

Click Select.
Click Refresh to refresh the report.

The report now displays data for Jul-17. Using this method, the user can easily move back and forth between months, quarters, or years, without updating the definition of the report and without the need for the designer or administrator to update the substitution variable value permanently.

Using Substitution Variables with Expressions

Modeling now supports the ability to enhance substitution variables by providing expressions. Expressions point to different members in the dimension in relation to the predefined value of the substitution variable.

Here is a basic annual revenue report. Expressions will make this report easier to maintain in coming years.

Define the following substitution variable:

FirstMth = Jan-16

Now go to Report Design to use this variable.

Select all the cells in the worksheet.
Click Design Manager.

Each member in the Time dimension will be replaced with a substitution variable or expression.

Select Jan-16.
Click the Member Selection icon, then Select Member.
Select @FirstMth@ and click Select. Now the Design Manager reflects the change from the original value (Jan-16) to the Substitution Variable @FirstMth@. Also shown in light gray is the predefined value of FirstMth.

Repeat steps 3-5 for Feb-16.
While still on Feb-16, click the Member Selection icon again, then Expression.

The Expression box appears and FirstMth is already selected.

Click Add Function.
Click Lead.

The Expression box now shows the Offset option. By default, the offset is 1. Offset refers to the number of members above or below the current member in the dimension hierarchy. Offset works within the current level and it skips over rollup members.

Lead refers to members below the current member in the hierarchy. For example, Jan-16, Lead(1) points to Feb-16. Lead is equivalent to fetching the next member in the hierarchy within the current level.

Lag refers to members above the current member in the hierarchy. For example, Jan-16, Lag(1) points to Dec-15. Lag is equivalent to fetching the previous member in the hierarchy within the current level.

Click Update to accept Lead(1).
Repeat steps 3-5 and 7-10 for the rest of the months to express all of the months in relation to FirstMth.

For the year 2016, a different expression is needed.

Repeat steps 3-5 for 2016.
While still on 2016, click the Member Selection icon again, then Expression.
The Expression box appears and FirstMth is already selected.
Click Add Function.
Click Parent. The parent of Jan-16 is Q1-16, so we want the parent of the parent to go up 2 levels to 2016. This is done by chaining two expressions together. For more information on chaining expressions, see Expression Chains.
Click Add Function again.
Click Parent. Now you see @FirstMth@.Parent.Parent, and 2016 is displayed to show you what value is returned with this expression.

Click Update.

The Time dimension now reflects all members in relation to the substitution variable FirstMth.

Click Update to save your changes and exit the Design Manager.

The report now displays UPDATED in place of the data cells, and @FirstMth@ and the expressions in place of the monthly headings.

Save the report design by clicking Save or Save As. Consider changing the name to preserve the original report until you are confident that the new report is accurate.

Now when you run the report, you can use the Substitution Variables box to change the starting value to the first month of any year in your hierarchy.

After selecting Jan-17, click Refresh.

Notice that the same report now works for other fiscal years. Users just need to select the first month of the fiscal year and entire report is derived from that substitution variable dynamically. Because of the introduction of expressions, administrators or designers can design reports that are more dynamic in nature. And it will reduce the report maintenance going forward.

Expressions

Consider the following dimension hierarchy for a fiscal year that begins in July each year. Assume that the model contains only these three years.

Time Dimension
FY2017	FY2018	FY2019
Q1 2017	Q1 2018	Q1 2019
Jul 2016	Jul 2017	Jul 2018
Aug 2016	Aug 2017	Aug 2018
Sep 2016	Sep 2017	Sep 2018
Q2 2017	Q2 2018	Q2 2019
Oct 2016	Oct 2017	Oct 2018
Nov 2016	Nov 2017	Nov 2018
Dec 2016	Dec 2017	Dec 2018
Q3 2017	Q3 2018	Q3 2019
Jan 2017	Jan 2018	Jan 2019
Feb 2017	Feb 2018	Feb 2019
Mar 2017	Mar 2018	Mar 2019
Q4 2017	Q4 2018	Q4 2019
Apr 2017	Apr 2018	Apr 2019
May 2017	May 2018	May 2019
Jun 2017	Jun 2018	Jun 2019

Expression Syntax

The following expressions are available for use with substitution variables. Assume that @CurYear@ is FY2018 and @CurMth@ is Jul 2017.

Expression	Offset # Required?	Description	Example Syntax	Resulting Value
FirstChild	No	Returns the first child in the hierarchy.	@CurYear@.FirstChild	Q1 2018. CurYear is FY2018 and its First Child is Q1 2018.
LastChild	No	Returns the last child in the hierarchy.	@CurYear@.LastChild	Q4 2018. CurYear is FY2018 and its Last Child is Q4 2018.
FirstSibling	No	Returns the first sibling in the hierarchy, at the same level	@CurYear@.FirstSibling	FY2017. CurYear is FY2018 and its First Sibling is FY2017.
LastSibling	No	Returns the last sibling in the hierarchy, at the same level	@CurYear@.LastSibling	FY2019. CurYear is FY2018 and its Last Sibling is FY2019.

Lead	Yes	Returns the next member in the hierarchy, at the same level; skips over parent or child members	@CurYear@.Lead(1)	FY2019. CurYear is FY2018 and the next member at the same level is FY2019.
			@CurYear@.Lead(2)	Member Not Found (There is no FY2020 in the model.) CurYear is FY2018 and skipping ahead 2 years would result in the member that follows FY2019 except there is no such year in the model.
			@CurMth@.Lead(4)	Nov 2017. CurMth is Jul 2017 and skipping ahead 4 months is Nov 2017.
Lag	Yes	Returns the previous member in the hierarchy, at the same level; skips over parent or child members	@CurYear@.Lag(1)	FY2017. CurYear is FY2018 and going back one year is FY2017.
			@CurYear@.Lag(2)	Member Not Found (There is no FY2016 in the model.) CurYear is FY2018 and going back two years would result in the member that preceds FY2017 except there is no such year in the model.
			@CurMth@.Lag(4)	Mar 2017. CurMth is Jul 2017 and 4 months before July is Mar 2017.

Parent	No	Returns the parent member in the hierarchy.	@CurYear@.Parent	Time. CurYear is FY2018 and its Parent is the Time dimension.
			@CurMth@.Parent.Parent	FY2018. CurMth is Jul 2017 and its Parent is Q1 2018, and Q1's Parent is FY2018.

Expression Chains

You can chain expressions together. Each entry in the expression builds on the results of the previous entry, reading from left to right.

@CurMth@.Parent.FirstChild = Jul 2017. CurMth’s Parent is Q1 2018 and the First Child of Q1 2018 is Jul 2017.

@CurMth@.Lag(3).Parent = Q4 2017. CurMth’s 3-month Lag is Apr 2017 and the Parent of Apr 2017 is Q4 2017

@CurMth@.Parent.Lead(2) = Q3 2018. CurMth’s Parent is Q1 2018 and 2 quarters ahead is Q3 2018.

Note:

In this first release of expressions, we recommend to chain only two expressions together.

When adding functions to a substitution variable, you may find the need to change the order or to remove one of the expressions. Click the menu button next to the expression to make the changes.

If you want to cancel out from adding expressions, click inside the Design Manager or press Esc.

Converting Existing Reports with Substitution Variables to Use Expressions

Many existing reports are set up with multiple substitution variables. These reports can be converted to use one substitution variable and many expressions for easier maintenance.

Consider the following model and its current list of substitution variables.

These substitution variables are used in all of the company reports that show data by month, quarter, or year. Below is a report of Salaries by Department. You can see the use of 17 substitution variables in the report.

To convert this report and any other reports to use a single substitution variable, first decide which member should be the starting point that you can create expressions from. For example, if you start with the first month of your fiscal year, then you can use Sibling, Lead, or Lag to offset at the same level to other months. Or go back one level with Parent and use Lead or Lag to offset to quarters, or go back two levels with Parent.Parent and use Lead or Lag to offset to years. Or you can start with the year and use Child expressions to get to the quarters and months.

For this example, we will base all the time entries in the report on the first month of the year. A Designer or Admin user must create the substitution variable.

Define the following substitution variable for the model Sample Salaries and the dimension Time:

FirstMth = Jan 2015

Note:

All the previous substitution variables defined for this model still exist (those rows are hidden in the screenshot below); you are adding a new one at the bottom. After you convert all your reports over to using just one substitution variable, you can delete all the extraneous substitution variables.

Open the report and go into Design mode.
Select all the cells in the worksheet, then click Design Manager. Scroll down to the Time dimension.
Select the @Month1@ variable, which is currently set to Jan 2015.
Click the Member Select button and click Select Member.

Scroll to find the new variable that you created, FirstMth. Select it and click Select.

The New Value column now shows the @FirstMth@ substitution variable. In grey, Jan 2015 is displayed.

Click Update. The report now displays UPDATED in place of the data cells and @FirstMth@ in place of Jan 2015.
With all the cells in the worksheet still select, click Design Manager again.
Scroll down to the Time dimension and select @Month2@.
Repeat steps 5-6 to replace @Month2@ with @FirstMth@.
Click the Member Select button and click Expression.
Click Add Function and select Lead.
Keep the default Offset of 1, and click Update.

The New Value column now shows the @FirstMth@.Lead(1) substitution variable plus expression. In grey, Feb 2015 is displayed.

Repeat steps 5-6 and 11-12 for the rest of the months, adding one more to the Offset for each subsequent month. Now all the months are expressed in relation to FirstMth.

Click Update to insert these changes into the report.
With all the cells in the worksheet still select, click Design Manager again.
Scroll down to the Time dimension and select @Qtr1@.
Repeat steps 5-6 to replace @Qtr1@ with @FirstMth@.
Click the Member Select button and click Expression.
Click Add Function and select Parent.
Click Update.

Select @Qtr2@.
Repeat steps 5-6 to replace @Qtr2@ with @FirstMth@.
Click the Member Select button and click Expression.
Click Add Function and select Parent.
Click Add Function and select Lead with Offset of 1.

Click Update.
Repeat for the remaining quarters, by creating the following chain expressions for them:

@FirstMth@.Parent.Lead(2) = Q3 2015

@FirstMth@.Parent.Lead(3) = Q4 2015

Click Update to insert these changes into the report.
With all the cells in the worksheet still select, click Design Manager again.
Scroll down to the Time dimension and select @Year@.
Repeat steps 5-6 to replace @Year@ with @FirstMth@.
Click the Member Select button and click Expression.
Click Add Function and select Parent.
Again, click Add Function and select Parent.
Click Update

Click Update to insert these changes into the report.

Now save the report design by clicking Save or Save As. Consider changing the name to preserve the original report with multiple substitution variables until you are confident that the new report is accurate.
Compare the data to your original report to ensure it is accurate.
Click Run to go into Run mode.

When running the report, now you can click the Substitution Variables button on the ribbon to change the FirstMth variable to the first month of any year.

Using Substitution Variables with Excel-based Reporting

If you have reports with substitution variables and expressions, you can use them with Excel-based Reporting.

Open a formatted report and click Capture Data.

When the report is first converted to Excel-based Reporting formulas, you see the substitution variables and expressions in place of the dimension members.

Click Refresh.

Notice that there is no Substitution Variables button on the ribbon, so you cannot change the value of the substitution variable from an Excel-based report. In a future release, similar options will be added so that substitution variables can be changed in Excel-based reports.

Best Practices

Define the master list of substitution variables that you expect to use in all of your standard company reports. This should be a fairly short list, such as: CurMth, CurQtr, CurYr, CurBudget, CurForecast, and so on. Then use expressions to access all other necessary members of your dimension hierarchy.
Limit the chain of expressions to two.

Limitations

Substitution variables are not supported in cascaded reports.
Substitution variables cannot be changed at runtime in Excel-based Reports.
Substitution variables cannot be changed at runtime in a Snapshot.
We recommend to chain together only two expressions in this first release of substitution variables with expressions.

Future Options

The following options will be added in future releases:

Ability to synchronize substitution variables between Host Analytics Planning and Host Analytics Modeling applications.
Ability to change substitution variable values at the time of Calculation definition.
Ability to change substitution variable values in Excel-based Reporting.

Additional Application Settings

Administrators can now set several options to be defaults for Views and Reports. Previously you had to set them one by one using View or Report Properties. These settings set the defaults for views and reports. Existing views and reports will not automatically adopt these defaults.

Select Manage, Application Administration, Application Settings. After making changes, click Save. Then logoff and login again to see the effect of the changes.

View Settings

Suppress Rows and Suppress Columns are options that determine whether rows and columns containing all zeros, all blanks, or a combination of zeros and blanks will be displayed in a view. Use the drop-down to select the types of data to suppress. The default is None.

None
Zero
Blank
Both - Zero & Blank

Note:

The exception to the App Settings defaults is with the Default view. If you select Analyze, Data, then select a Model, the first view listed under that model name is "Default." In the Default view, you zoom in, zoom out, drag and drop dimensions, and so on until you have the layout that you want. In the Default view, the Suppress Rows and Suppress Columns settings are ignored. As soon as you save the View, then the default value of Suppress Rows and Suppress Columns is used and you will see the effect when you run the view.

Additionally, you can specify Yes or No to allow or disallow Designers and Reviewers from making changes to the Suppress Rows and Suppress Columns settings in the properties of individual views. The default is Yes.

Note:

The Designer or Viewer can see the Suppress Rows and Suppress Columns options on the View Properties and can make changes and click Save. No error message appears, but the change is not saved if they do not have access to update view properties.

When done making changes to Application Settings, click Save. Then logoff and login again to see the effect of the changes.

Report Settings

Suppress Rows, Suppress Columns, and Refresh on POV Change can be set for all formatted reports.

For Refresh on POV Changes, specify Yes or No to automatically refresh the report when the user changes the Point of View. The default is No.

Suppress Rows and Suppress Columns are options that determine whether rows and columns containing all zeros, all blanks, or a combination of zeros and blanks will be displayed in a report. Use the drop-down to select the types of data to suppress. The default is None.

None
Zero
Blank
Both - Zero & Blank

Additionally, you can specify Yes or No to allow or disallow Designers from making changes to these settings in the properties of individual reports. The default is Yes.

Note:

The Designer can see the Refresh on POV Change, Suppress Rows, and Suppress Columns options on the Report Properties and can make changes and click Save. No error message appears, but the change is not saved if they do not have access to update report properties.

When done making changes to Application Settings, click Save. Then logoff and login again to see the effect of the changes.

Audit Log Enhancements

The Audit Log has been enhanced to include additional entries and search with date ranges and paging.

Only administrators have access to the Audit Log. Select Manage, Application Administration, Audit Log.

Additional Entries

The Audit Log now provides log entries for the following activities in the application:

View - Get Data
View - Get Data for All Open Views
Report - Refresh
Report - Refresh All Open Reports
Report - Substitution Variables Refresh
Excel-based Reporting - Refresh
Excel-based Reporting - Refresh All

Date Ranges and Paging in the Audit Log

The Audit Log now has options for viewing entries between two dates, and for paging through large volumes of entries.

The fields highlighted with yellow background are in this release.

From Date - Starting date for which you want to view audit details. The date must be in the format MM/DD/YYYY. By default, From Date shows today's date.

To Date - Ending date for which you want to view audit details. The date must be in the format MM/DD/YYYY. By default, To Date shows today's date.

Total Records - This is a display field only. It shows the number of audit log entries found.

Page Size - This is a display field only. It shows the number of entries shown on each page. The maximum page size is 1000.

Current Page - This is a drop-down list. If there are more than 1000 entries, they are divided into multiple pages. Select which page you want to view then click Refresh. In the example below, page 1 has 1000 entries, and page 2 has 448 entries.

Breakback Changes

The Breakback feature was introduced in Version 2.1.1. As we continue to improve this feature, we are introducing two changes in Version 2.1.2:

Hold is Available for Multiple Dimensions
Breakback on Rollups with Different Operators is Available

Hold is Available for Multiple Dimensions

In Version 2.1.1, Hold was available only for one dimension at a time. For example, you could run Breakback on 2017 and hold one or more members of the Time dimension: Jan-17 and Feb-17, or Q1-2017 and Q2-2017.

In Version 2.1.2, you can hold members from more than one dimension.

In the following example, revenue targets are increased for Mountain Bikes in 2016 but Quarter 1 in International markets is not increased.

Select Cell C10, Mountain Bikes for 2016. Notice that the Q1 value for International is 443,595 and Q1 value for North America is 118,249.
Select the Breakback button on the ribbon.
Select the Current spread.
Under Amount, specify the amount you want to spread. In this case, 2.6M.
Under the Hold box, select Add Dimension Member.
Specify the Time dimension and select Q1 2016. (In Excel, you can also click the Select Range button and simply click on the cell containing the member you want to Hold.)
Select Add Dimension Member again and specify the Department dimension and International member.
Click the Run Calculation button to run the calculation associated with this view after the Breakback is performed.

Click Run Breakback.

Here is the resulting data. Notice that Q1 International remains at 443,595, but Q1 North American has increased to 124,000. Q3 and Q4 also had proportional increases.

Breakback on Rollups with Different Operators Available

In Version 2.1.1, when using Breakback on rollups, all children in the hierarchy must be defined with the plus (+) operator. For example, months roll up to quarters and quarters roll up to a year using the + operator.

In Version 2.1.2, you can use Breakback on rollups with children with any operator, but you must first enable this capability on the Application Settings page. By default, it is disabled.

As a Best Practice, we recommend using Breakback only on rollups with the + operator. Running Breakback will change the data at the leaf level, and if the rollups use any operator other than +, the results of the Aggregation may be unpredictable.

By default, Enable Breakback on other rollup operators is set to No, and Breakback will report an error if you try to use it on rollups with varying operators.

Enabling Breakback on Other Rollup Operators

An administrator must make this change.

Select Manage, Application Administration, Application Settings.
Scroll down to the Model section and look for Enable Breakback on other (~!-) rollup operators.
Select Yes or No from the drop-down.

Click Save.
Logoff and login again to see the effect of the changes.

Known Issues

2975	Substitution variable and its runtime value should be retained after report is converted to Excel-based Report.
2974	User can see substitution variable expression from Excel-based Report but cannot edit it.
2971	Breakback does not hold the cells on the report which are locked.
2873	Breakback on rollup value from negative to positive may yield weird or incorrect results.
2778, 2752	Breakback can be performed on cells that have scaling (i.e. Amount Format) and on cells that are locked from Report.
2611	Cascade Reports will not work as expected if the user deletes a Dimension or an Attribute from the Model.
2492	If a report which is saved in an excel work book(offline) is renamed then users need to reload that report into the Excel workbook. Best practice is to refresh all reports in the saved workbook before renaming any report.
2421	Excel "Compatibility Mode" is Unsupported
2354	Snapshot email link will not work for users with SSO integration if they are not logged into the application. As a workaround they should log into the application and then access the Snapshot email link.
2276	If user makes any changes to the report (ex:- formatting, adding rows or columns, deleting rows or columns) after running it and then take a Snapshot then user will not see all the changes made to the report and in some cases the snapshot will look weird. We recommend users to take Snapshots without making any changes to changes to the report after its executed
2113	Integration between Planning & Modeling applications from web interface is best supported in Google Chrome browser. Users cannot navigate from Planning to Modeling if Internet Explorer compatibility mode is turned on.
2080	If users are using Firefox browser, right clicking an item in the Folder structure may display an incorrect menu.
1845	If POV member defined is removed or renames, it cannot be fixed in report design mode and error is displayed.
1492	Using special characters for the model name results in errors.
1464	When suppress rows/columns is enabled, If Dimension Members and Data Intersection are available in same column/row in a report then dimension members will be suppressed along with data intersections.
1457	In some cases Suppress blank rows/columns is not working as expected when Groups are expanded in the report.
1455	Suppress blank rows/columns is not supported in Spotlight (i.e. Web Interface).
1454	In Some cases Suppress blank rows / columns is not working as expected if groups and freeze panes are enabled in the Report.
1446	Unable to navigate to Design View after rename or remove HostAnalyze worksheet.
1406	Excel 2016 charts containing 3D Clustered Column, 3D Stacked Column, or 3D Stacked Bar are not supported.
1322	Unable to cascade with substitution variables.
1321	Substitution variables are not working as expected in Cascade Report.
1273	Cascade Report has inconsistencies with Filters.
1144	Freeze Panes location should not be outside of the sheet viewable range.
687	Modified Report definition by removing months column still retain after Refresh.

The following issues are specific to Excel-based Reporting.

2518	Reviewer user has no access to Publish Excel-based reports.
2302	If there are any Snapshots in the workbook then Convert Entire Workbook option will not convert the workbook.
2203	Shared POV status is lost upon changing value of POV in Design Manager / Formatted Report and EBR.
2199	Filter member options are not available if only 1 cell from a model exists, in formatted report and EBR.
2097	When using Design Manager, Update button is enabled only after entering a valid New Value and hitting enter.
1887	It takes over 1 - 3 min to open 22 MB Excel workbook.
1755	Locking / Scaling is not applied when converting a Formatted Report to Excel-based Report.
1699	It may takes up to couple of hours to Capture Entire Workbook with 30 worksheets and ~7000 data cells or more cells
1698	Message shows 'Please contact administrator...' when select Refresh after session timeout.
1683	Specifying a relative cell address to a cell in another tab in EBR creates an absolute cell address.
1672	Provide an option to reset the Excel workbook so users can upload using a different Report Template.
1624	Unable to download the same report as it's being used by another process.
1550	Errors when Capture Data as SpotlightXL Formulas with a cascade report.

Was this article helpful?