Product:
Cognos BI 10.2.1 Cognos Connection

Problem:
User cannot replace a report in a folder with a different report he copied from a different folder. This is because the report to be pasted has different security settings for the user than the report in the target.
In the source folder you only have read, this means you can see reports and use them in report studio.
In the target folder you also have write access, this means you can create folders and paste reports there. But you cannot replace a report with a identical report from the source folder, because there the report is set with only READ access and not READ/WRITE.

Solution:
In the target folder you must have SET POLICY to be able to paste a report with other rights that the report you try to replace.
Workaround is to erase the report first, and then paste a new report into the folder. A new report does not change policy, and therefore can you save a report in a folder where you have write access.
If you only add new object to the target folder in Cognos Connection, you can manage with WRITE rights.
To work with a report or package you need to have READ, EXECUTE and TRAVERSE rights. If you only have EXECUTE and TRAVERSE you can run the report, or use the FM package in a report, but you cannot edit it in a Report Studio.

Product:
Cognos BI 10.2.1
Windows 2008 R2 server

Problem:
How to move reports and keep reference link intact?

Solution:
Drill through reports are linked with path and report ID, which gives this effect when you adjust the report.

Rename
When renamed a report, all involved links will be changed accordingly.

Copy and paste to new folder
All involved links will be changed accordingly.

Cut and paste both source and target report to new folder
All involved links will be changed accordingly.

Cut and paste target report to new folder
All involved links will be changed accordingly.

Move target report to new folder (found under More actions)
All involved links will be changed accordingly.

Open it and save as same name
All involved links will be broken, including drill through, portal page and Job

Open report A
Copy report to clipboard,
Change XML,
Open report from clipboard
Save as report A

Copy to another folder, then change it, then copy back
All involved links won’t be impacted

Copy report A to My folder
Open report A from My Folder
Change report A from My Folder , add color to a column.
Copy report A from My folder to original folder and overwrite old report

Copy to another folder, then copy report to XML, change XML and then save it as same name, then copy back
All involved links won’t be impacted

Copy report A to My folder
Open report A from My Folder
Copy report to clipboard from My Folder
Change XML,
Open report from clipboard
Save as report A in My folder and overwrite report A
Copy report A from My folder to original folder and overwrite old report

Copy to another folder, then save any other report as same name, then copy back
All involved links won’t be impacted

Copy report A to My folder
Save any other report as report A in My folder and overwrite report A
Copy report A from My folder to original folder and overwrite old report

Merge two drill through target reports to one
Given Source report A -> Target report A, Source report B -> Target report B,
request to change Source report B ->Target report A

Steps:
Delete Target report A
rename Target report B to Target A

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21341623
http://cognosknowhow.blogspot.se/2013/01/how-to-avoid-breaking-report-link-for.html

Product:
Cognos Controller FAP 10.1.1
Oracle Database

Problem:
Error log when start the Controller FAP service
Error message in file C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\error.log
2015-03-17 13:02:48,664 [schedulerThread] ERROR Scheduler – Connection error to FAP database
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.trace(LogDaoOracle.java:53)
at com.ibm.cognos.fap.common.persistence.dao.LogDao.info(LogDao.java:121)
at com.ibm.cognos.fap.common.persistence.dao.LogDao$$FastClassByCGLIB$$60127973.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:56)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.info()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:197)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 9 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 11 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 19 more
2015-03-17 13:02:48,680 [schedulerThread] ERROR RetryInterceptor – Trial 1 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:18,695 [schedulerThread] ERROR RetryInterceptor – Trial 2 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:48,710 [schedulerThread] ERROR RetryInterceptor – Trial 3 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
Possible solution:
Change in the FAPService.properties file to use a different SID name, try without the domain.com values at the end. The Oracle listener is setup to listen to only the name.
Change from db=fap42.domain.com
To db=fap42
In below file example;
u# IBM SOURCE CODE HEADER START
# =====================================================================
# OCO Source Materials
#
# BI and PM: ccr
#
# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved
#
# The source code for this program is not published or
# otherwise divested of its trade secrets, irrespective of
# what has been deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END

db=fap42
host=servername.domain.com
dbType=oracle
user=COGFAP
passwd=xxxxxx
clientcamuri=http://biwebalias.domain.com/ibmcognos/cgi-bin/cognosisapi.dll

Product:
Cognos Controller FAP 10.1.1
Oracle Database

Problem:
Error log when start the Controller FAP service
Error message in file C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\error.log
2015-03-17 10:06:49,227 [schedulerThread] ERROR Scheduler – Connection error to FAP database
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername-lx2488.domain.com:1521:FAP42.domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.trace(LogDaoOracle.java:53)
at com.ibm.cognos.fap.common.persistence.dao.LogDao.info(LogDao.java:121)
at com.ibm.cognos.fap.common.persistence.dao.LogDao$$FastClassByCGLIB$$60127973.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:56)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$766a4385.info()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:197)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 9 more
Caused by:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.lang.Class.forName(Class.java:139)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
… 11 more
2015-03-17 10:06:49,242 [schedulerThread] ERROR RetryInterceptor – Trial 1 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$766a4385.pingDatabase()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername-lx2488.domain.com:1521:FAP42.domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.lang.Class.forName(Class.java:139)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
… 12 more

Possible cause:
The oracle database is not configured with the correct tables needed to use it as a FAP database. Run DBCONV to update the database with correct tables.
Also that the ojdbc5.jar file is not in the folder C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\lib

Product:
Cognos Controller 10.1.1 (update version 10.1.6302.53-0)
Controller FAP client (version 10.1.6235.60-0)
Windows 2008 R2 server
Oracle database

Problem:
When try to login to the FAP database from the FAP client you get a error message
“Can’t connect to FAP database”.
same error as when you write the wrong password.

Solution:
Install oracle driver 11.2.0.4.0 64 bit version on the computer where you run the Controller FAP client.
Select to do a Administration client installation.

If you have the TNSNAMES.ORA file in a different folder than the normal for Oracle, then you need to update the Windows registry with this value.
Start REGEDIT.EXE
Expand HKEY_LOCAL_MACHINE – SOFTWARE – ORACLE – KEY_OraClient11g_home2
Right Click and select NEW – String Value
Set Value name: TNS_ADMIN
Set Value data: c:\orarun\tnsadmin
(the path to the folder where the TNSNAMES file are)

Product:
Cognos TM1 Architect 10.2.2
Windows 2008 R2 Server
Oracle database
Problem:
When importing data from an ODBC oracle database, the preview in TM1 Architect is blank. You see the columns name, but no data.
You use a query statement like this SELECT * FROM IA_RUNREPORT;
Solution:
One of the columns in oracle database is in the format TIMESTAMP, and that is not considered a number or a string by TM1. You must then in your SQL statement convert that to a STRING.
Use this command:
TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”,

So then your SQL statement inside TM1 TI process Data Source Query should be something like this:
SELECT RUN_ID, ENV_ID, SOLUTION_ID, USER_ID, TIME_ID, CONTENT_ID, USERNAME, NAMESPACE, USERID, CAMID, REPORTPATH, TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”, TARGET_TYPE, STATUS, ERRORDETAILS, RUNTIME, PACKAGE, HOST_IPADDR, PROC_ID, SESSION_ID, REQUEST_ID, TIMEZONE_OFFSET, THREADID FROM IA_RUNREPORT;
Check in your Oracle data source with SQL Developer if there are any column that is not in NUMBER or VARCHAR format, because that you need to take care of in the import SQL statement to TM1.

Product:

Cognos TM1 10.2.2

Windows 2008 R2 Server

 

Problem:

How create the measure dimension in a TI process?

And not use the TM1S.CFG parameter DefaultMeasureDimension=T

That will make the last dimension the measure dimension at every cube creation.

http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SS9RXT_10.1.0/com.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc/c_defaultmeasuresdimension_tm1.html%23DefaultMeasuresDimension_tm1

 

Solution:

Go into TM1 Architect and create a new TI process;

In PROLOG set some parameters for the cube.

#—————————–

# set default values

#——————————-

cCubeName = ‘IA.WLicensUsage’ ;

cDimParameter = ‘IA.WUsers’ ;

cDimMeasure=  ‘IA.WLicens’ ;

In EPILOG set this command

cellputs (cDimMeasure, ‘}CubeProperties’,cCubeName,’MEASURES_DIMENSION’);

 

Change the variables names to fit with your cube and dimensions names.


Product:
Cognos BI 10.2.2
Windows 2012 R2

Problem:
The tree prompt is starting all over again and is not showing the next 20 rows of selections as it did in previous version of Cognos BI.

Solution:
Go to the Framework Manager Package icon in Cognos Connection that is used of that report.
Click on MORE
Click Modify the package configuration
Change the Default member limit in a data tree level to 200 from 20
Change the Maximum member limit in a data tree level to 500 from 50
Click OK
Test runs the report again.

Product:
Cognos Controller 10.2.1 FAP service
Windows 2012 R2
Problem:
When starting the IP in FAP client you get an error message it cannot connect to the TM1 instance called FAP.
Error message:
2015-05-29 10:47:52,183 [schedulerThread] ERROR Scheduler – Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerClientNotFound
at com.ibm.cognos.tm1.API.logonCAMNamespace(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.login(TM1Context.java:106)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:530)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:252)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:157)
at java.lang.Thread.run(Thread.java:795)

Solution:
Enter correct password for the CAM user account domain\cognosfap
Save and try again.
More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21679216&aid=1

Product:
Cognos BI 10.2.2
Windows 2012 R2 server

Issue:
After upgrade from Cognos BI 10.1.1 to Cognos BI 10.2.2 the creation of PDF reports takes several minutes, when it before take only seconds.
HTML reports are as fast they were in the older version of Cognos BI.
If you remove the pictures in the report, then the PDF file is created fast.

Possible Solution:
Copy all the images to the Report BI server, in old version the images that are in reports are on the Cognos BI Gateway server only. Now it is recommended to have them on all BI servers.
Update all servers to have the pictures in the folder .. \samples\images.
D:\Program Files\ibm\cognos\c10_64\webcontent\samples\images

The PDF creation looks locally for the pictures at first, before going to the gateway.