Maximum rows in active form?

Post Reply
missspeedy23
Posts: 19
Joined: Wed Sep 28, 2016 1:43 pm
OLAP Product: Cognos TM1
Version: 10.1.1
Excel Version: 2007

Maximum rows in active form?

Post by missspeedy23 »

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.
EvgenyT
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?

Post by EvgenyT »

First point of call would be to check inconsistently named named ranges, TM1 web sometimes acts funny with those.
Post Reply