I have this simple Active Form in TM1 Web. I'm using SUBNM as dimension selection lists. These lists work fine in normal Excel worksheets in Web, but I hit an error if I use them in Active Form (web). After selecting an element in the pop-up window and click OK, the following error message appears:
Server Error in '/TM1Web' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
Applix.TM1.Web.WebControls.Websheet.TitleData.ChangeTitleElement(String selectedElement) +69
Applix.TM1.Web.WebControls.Websheet.ViewExData.UpdateTitles() +415
Applix.TM1.Web.WebControls.Websheet.TM1WebActiveReport.CheckForTitleChanges(ActiveReportRecalc mode) +52
Applix.TM1.Web.WebControls.Websheet.TM1WebActiveReport.Evaluate(ActiveReportRecalc mode) +28
Applix.TM1.Web.WebControls.Websheet.TM1WebBook.Recalc(Boolean fullRecalc, ActiveReportRecalc mode) +686
Applix.TM1.Web.WebControls.Websheet.TM1WebBook.Recalc() +8
Applix.TM1.Web.Page.ElementSelectorSession.UpdateCallerSubset() +347
Applix.TM1.Web.Page.ElementSelectorSession.PerformEdit(String operation) +1308
Applix.TM1.Web.Page.SubsetTree.Page_Load(Object sender, EventArgs e) +1563
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
The funny thing is, if I ignore the error and close the pop-up, then rebuild the active form worksheet, the selection actually appears! How do I solve this error so the user experience will not be affected?
Planning Analytics latest version, including Cloud
This may or may not help. It's worth giving it a shot. This is from IBM Cognos' release notes. You may need TM1MR1 File Patch 1.
Workbook Recalculation Variable TM1REBUILDOPTION
A new calculation model was introduced in TM1 9.4 which forced an automatic recalculation of
all sheets in a workbook, even when the Excel calculation mode was set to Manual. The new model
forced a recalculation upon initial opening of any workbook, upon element selection via a SUBMN
formula, or upon any server connect event.
TM1 9.4 MR1 includes a new workbook name variable, TM1REBUILDOPTION, which lets you
manage calculation in workbooks containing TM1 slices and Active Forms. When you create a
slice or Active Form in TM1 9.4 MR1, the TM1REBUILDOPTION name is automatically created
in the corresponding Excel workbook and set to 1, indicating that all worksheets in the current
workbook should be rebuilt and recalculated when a TM1 server connect event occurs.
If TM1REBUILDOPTION is present in a workbook and set to 0, or if TM1REBUILDOPTION is
not present in a workbook, worksheets are not rebuilt/recalculated when a server connect event
occurs.
Modifying the TM1REBUILDOPTION Setting
If you do not want workbooks created with TM1 9.4 MR1 to automatically rebuild and recalculate
all slices and Active Forms when a server connect event occurs, you can set the TM1REBUILDOPTION
value to 0.
Steps
1. In Excel, click Insert, Name, Define.
2. In the Define Name dialog box, select TM1REBUILDOPTION.
3. Set the value in the Refers to box to =0.
4. Click OK.
I have tried your recommendation i.e. change TM1REBUILDOPTION to "0". It does not help. So is it true that there is soem conflict between SUBNM and Active Form in TM1 Web?
Planning Analytics latest version, including Cloud
Have you downloaded & install the file patch 1 for TM1MR1? This patch addressed several issues relating to active forms & TM1web.
If you haven't, Alan Kirk has posted a topic within this forum http://forums.olapforums.com/viewtopic.php?f=3&t=886.
RLReyes wrote:This may or may not help. It's worth giving it a shot. This is from IBM Cognos' release notes. You may need TM1MR1 File Patch 1.
Workbook Recalculation Variable TM1REBUILDOPTION
A new calculation model was introduced in TM1 9.4 which forced an automatic recalculation of
all sheets in a workbook, even when the Excel calculation mode was set to Manual. The new model
forced a recalculation upon initial opening of any workbook, upon element selection via a SUBMN
formula, or upon any server connect event.
TM1 9.4 MR1 includes a new workbook name variable, TM1REBUILDOPTION, which lets you
manage calculation in workbooks containing TM1 slices and Active Forms. When you create a
slice or Active Form in TM1 9.4 MR1, the TM1REBUILDOPTION name is automatically created
in the corresponding Excel workbook and set to 1, indicating that all worksheets in the current
workbook should be rebuilt and recalculated when a TM1 server connect event occurs.
If TM1REBUILDOPTION is present in a workbook and set to 0, or if TM1REBUILDOPTION is
not present in a workbook, worksheets are not rebuilt/recalculated when a server connect event
occurs.
Modifying the TM1REBUILDOPTION Setting
If you do not want workbooks created with TM1 9.4 MR1 to automatically rebuild and recalculate
all slices and Active Forms when a server connect event occurs, you can set the TM1REBUILDOPTION
value to 0.
Steps
1. In Excel, click Insert, Name, Define.
2. In the Define Name dialog box, select TM1REBUILDOPTION.
3. Set the value in the Refers to box to =0.
4. Click OK.
