Cognos TM1 Datasource in Framework Manager Performance Issue
Posted: Wed Nov 03, 2010 4:24 pm
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.
Any ideas?
Thanks in advance,
Dan
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=TRUEThanks in advance,
Dan