Cognos TM1 Datasource in Framework Manager Performance Issue

[dan.kelleher]

Hi,

This is an issue with both TM1 and BI, so could be moved to BI forum if needed.

I have 9.5.1 installed (previous 9.4 FP 2 also problematic) and have Cognos BI 8.4 installed.

Using the planning sample cubes as a datasource for a package (Nothing changed, port 12345) in BI works fine.

I then created a new server by copying the planning sample to a different location, change the tm1s.cfg to the below, delete all the cubes, ti processes, applications and dimensions. I then created a very simple a simple 3d cube (and dimensions), but now when viewing in Analysis Studio, the package is really really slow.

Code: Select all

# Security mode
#
# If IntegratedSecurityMode is set to 1. All clients must provide a database 
# username and password. This is traditionally done through a login screen.
#
# If IntegratedSecurityMode is set to 2. The clients will have the choice
# to connect provide a database username and password or use the single-login
# mechanism for authentication.
#
# If IntegratedSecurityMode is set to 3. All clients must use the single-login
# mechanism for authentication.
#
# If this is not set the parameter will be set to 1 by default.

# GroupsCreationLimit
#
# Note: The GroupsCreationLimit server configuration parameter pre-allocates 
# memory and should not be set higher than needed. Please see TM1 technical 
# bulletin: GroupsCreationLimit Recommendations for more information on 
# how this parameter works. 

[TM1S]
ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T
ServerName=Sandbox
#DataBaseDirectory=E:\Program Files\Cognos\TM1\Custom\TM1Data\PlanSamp
DataBaseDirectory=E:\TM1Servers\Sandbox\Data
AdminHost=XXXXXXXXX
#PortNumber=12345
PortNumber=10000
Language=ENG
SaveTime=
DownTime=
ProgressMessage=True
AuditLogOn=F
AuditLogMaxFileSize= 100 MB
AuditLogUpdateInterval=60
PersistentFeeders=F
#ServerCAMURI=http://:9300/p2pd/servlet/dispatch
#ClientCAMURI=http:///cognos8/cgi-bin/cognos.cgi
#ClientPingCAMPassport=900

#Optional CAM parameters
#CAMSSLCertificate=
#CAMSSLCertRevList=
#SkipSSLCAMHostCheck=TRUE

Any ideas?

Thanks in advance,

Dan

[dan.kelleher]

When I monitor threads with TM1TOP I see multiple Admin user threads for the server that is slow when I open the package in Analysis Studio, but the planning sample only has 1 Admin thread...