Is there a limit to how many rows can be returned in an active form? And if so is it a parameter than can be changed?
I have an active form in v10.1.1 that works fine with less than 100 rows but when I try to do say 1000 rows I just keep getting a timeout error. When I've looked at the web log file there is an error on there:
2016-12-06 16:35:51,194 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - Last AR data row object was null, check for off 'used range' reference
2016-12-06 16:49:55,835 [5] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
2016-12-06 16:50:28,570 [7] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
It seems as though there is a restriction on the number of rows that can be returned but I need to present the data in an active form because the form links a number of cubes/attributes/dimension data so can't be done by just a plain simple cube view.
Maximum rows in active form?
-
- Posts: 19
- Joined: Wed Sep 28, 2016 1:43 pm
- OLAP Product: Cognos TM1
- Version: 10.1.1
- Excel Version: 2007
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: Maximum rows in active form?
First point of call would be to check inconsistently named named ranges, TM1 web sometimes acts funny with those.