TM1 Forum

Posted: **Wed May 17, 2017 3:43 pm**

Is there a server configuration parameter that controls how many DBS formulas you can have in a single workbook? I have an input template with 300 lines of DBS formulas in it but the cube will only accept the first 35 lines of data. This is 10.2.2. FP4. When I load up a VM on my laptop of just plain 10.2.2 then I can have as many DBS formulas as I want. Here are the contents of the tm1s.cfg file of the affected server:

Code: Select all

[TM1S]
DataBaseDirectory="E:\TM1\Data"
Logging Directory="E:\TM1\Logs"
ServerName=ATCDEV
PortNumber=90222

IntegratedSecurityMode=2
SecurityPackageName=Kerberos

AdminHost=
Protocol=TCP
NetworkFrame= 
Language=ENG
SaveTime= 
DownTime= 
RuleTraceOn= 
ODBCCatalogName= 
ODBCDataSource= 
ODBCUserName= 
ODBCPassword= 
ReadTM1WriteODBC=
UseSSL=F
GroupsCreationLimit=500
EnableSandboxCache=T
ServerLogging = T
MaximumCubeLoadThreads=3

#Setting to use Oracle data source
UseSQLExtendedFetch=T

#---------------------
# Cam Setup
#---------------------
#ServerCAMURI=http://devcog01.americantower.com:9300/p2pd/servlet/dispatch
#ClientCAMURI=http://devcog01.americantower.com/cognos8/cgi-bin/cognos.cgi
#CAMPortalVariableFile=portal/variables_TM1.xml
#CAMSSLCertificate=
#SkipSSLCAMHostCheck=TRUE
#ClientPingCAMPassport=900
ViewConsolidationOptimization=T
MessageCompression=T
#UseStargateForRules=F


AllowSeparateNAndCRules = T
DistributedPlanningOutputDir=tunit
PersistentFeeders=T
#ForceReevaluationOfFeedersForFedCellsOnDataChange=T

Posted: **Wed May 17, 2017 7:40 pm**

More likely to be an issue with Excel. Is Excel calculating properly? Is Excel properly licensed?

Posted: **Thu May 18, 2017 10:59 am**

lotsaram wrote:More likely to be an issue with Excel. Is Excel calculating properly? Is Excel properly licensed?

AFAIK, Excel is properly licensed. This is at a large corporate client and I'm pretty sure they wouldn't cheat. It also happens for every person that tries to use the workbook not just one. It also has the 35 cell limitation on TM1Web too.

Posted: **Thu May 18, 2017 11:18 am**

tomok wrote:
lotsaram wrote:More likely to be an issue with Excel. Is Excel calculating properly? Is Excel properly licensed?
AFAIK, Excel is properly licensed. This is at a large corporate client and I'm pretty sure they wouldn't cheat. It also happens for every person that tries to use the workbook not just one. It also has the 35 cell limitation on TM1Web too.

A bit of a long shot but the rows below 35 wouldn't be formatted as text by any chance would they? I know that in the past I've seen some formulas that don't recalculate properly if the format is changed to text, even though they continue to display correctly provided that they aren't edited. It's not a universal problem and I haven't seen it in ages, but it can sometimes be a "sneaker".

TM1 Forum

DBS/DBSW Limitation

DBS/DBSW Limitation

Re: DBS/DBSW Limitation

Re: DBS/DBSW Limitation

Re: DBS/DBSW Limitation