Home
Follow us on Twitter


Countries

48.2%United States United States
7.3%India India
7%United Kingdom United Kingdom
5.6%Canada Canada
5.4%Australia Australia

Visitors

Today: 109
Yesterday: 467
This Week: 576
Last Week: 2534
This Month: 840
Last Month: 7295
Total: 760762


How do I copy a cube from on TM1 server to another TM1 server in a different environment? PDF Print E-mail
Written by Roger   

 

Product:
Cognos TM1 10.2.2
Windows 2008 R2 Server

Issue:
How do I copy a cube from on TM1 server to another TM1 server in a different environment? The 2 TM1 servers are part of two different BI installations, they use the same Active Directory for authentication, and there are no firewall issues between the servers.

Possible Solution:
Use a ODBO connection in Cognos TM1 Architect to create the copy.
Start TM1 Architect and log in to the receiving TM1 server.
Right click and select to create a new process.
Select Datasource type: ODBO – cube.
In connection you need to enter this information:
ODBO Provider: IBM Cognos TM1 OLE DB MD Provider
ODBO Location: servername.domain.com (servername of the windows host that have TM1 admin service)
ODBO Datasource: FAP  (name of the TM1 server where you want to get data from)
ODBO Catalog:
ODBO UserID: username   (name of the admin user in TM1 application)
ODBO Password: password
Additional Connection Parameters: Provider String=”CAMNamespace=CDS”
The additional Connection Parameters is only if you have a TM1 application that use CAM/BI authentication – enter the name of the Cognos BI namespace, in our example CDS.
Click on CONNECT button – if no errors then you wrote the correct values above.
Go to Load ODBO Cube dialog tab
Select ODBO Cube to load from: FAPMonthlyCompanyDetails  (or any other cube you want to import)
Select TM1 Cube to load to: FAPMonth (or any other name you have for it)
Cube Type: Physical Cube
TM1 Cube Action: Create Cube
Data Action: Store Values
Click on Cube Dimensions dialog tab
Here you can change what dimensions the values should connect to, or let the import create the new dimensions in your TM1 receiving server.
Click on MDX Query tab
Here you should be possible to adjust the MDX if you need to.
Click SAVE icon to save the process, give it a name like: FAP import from external server
Run the process.
Depending on the size of the TM1 Cube this can take some time.
When done you should have a copy of the cube and the dimensions.

More Information:
http://blog.tm1tutorials.com/2012/07/27/automating-data-transfers-between-tm1-servers/
http://blog.tm1tutorials.com/tag/odbo/

 

 

www.cogknowhow.com

 

 
When you start ODBC Data source administrator to add ODBC connections to xls files you get a error PDF Print E-mail
Written by Roger   
Product:
Cognos Planning 10.1.1
Analyst on Microsoft Windows 7 64 bit

Symptom:
When you start ODBC Data source administrator to add ODBC connections to xls files you get a error on your brand new Windows 7 computer.

You need to add ODBC connection to be able to import xls files into Cognos Analyst for Planning.  Inside Analyst how you selected New D-Link and then click on source, and selected ODBC (SQL) database. But then there are no connections to select, you have to create the connections in the ODBC tool.

Problem:
The setup routines for the Microsoft Excel Driver (xls xlsx xlsm xlsb) ODBC driver could not be found. Please reinstall the driver.

Cause:
In windows 7 the odbc icon in administrative tools are for  64 bit connections, and cognos planning use only 32 bit connections.

Solution:
Create a shortcut to the file c:\windows\syswow64\odbcad32.exe

Use this icon to edit the ODBC connection for Excel to be used in Cognos Planning.


www.cogknowhow.com

 
How do i change the startup picture when I start the Cognos Controller program locally? PDF Print E-mail
Written by Roger   
Product:
IBM Cognos Controller 10.1.1
Windows 2008 R2

Problem:
How do i change the startup picture when I start the Cognos Controller program locally?
I want the company logo to be incorporated in this flash picture.


Solution:
On client or Citrix server go to folder.
C:\Program Files (x86)\ibm\IBM Cognos Controller.
Open file CCRSplash_en-GB.jpg in mspaint program.
Draw or past in the company logo into the picture.
Save the file.


The file CCRSplash_en-GB.jpg is only used when you have selected ENGLISH as language in Cognos controller configuration.
That settings is stored in the CCR.exe.config file as:

<add key="Language" value="2057"/>


If you want to update the picture for SWEDISH users you should edit the CCRSplash_sv-SE.jpg file.

If you want to update the picture on the server for people who start Cognos controller direct from the webserver url, then you should edit the file in folder C:\Program Files (x86)\ibm\cognos\c10\webcontent\ccr

www.cogknowhow.com

 
Error to start Cognos BI service, only errors in file catalina.log PDF Print E-mail
Written by Roger   
Product:
Cognos Controller FAP 10.1.1
Microsoft Windows 2008 R2 server
Cognos BI 10.1.1

Symptom:
Error to start Cognos BI service.
No error in Cogserver.log file, you find any errors in file catalina.2014-03-27.log


Cause:
When publish in FAP you get error C8ITKShared (not found in java.library.path) after you have changed TM1 from native security to use CAM (Cognos BI) security on the FAP cube.
You added the folder to TM1 Bin folder to PATH, c:\program files\ibm\cognos\tm1_64\bin
This disturbs Cognos Bi, and it will not start the service.

Solution:
Remove the folder to tm1 bin from the Windows PATH environment variable.

Copy two files from folder c:\program files\ibm\cognos\tm1_64\bin to the folder c:\program files(x86)\ibm\cognos\c10\server\fap folder.

C8ITKproxy.dll
C8ITKshared.dll

Restart the Cognos FAP service.
Test to do an Initial Publish in FAP again.

http://www-01.ibm.com/support/docview.wss?uid=swg21450399

www.cogknowhow.com

 
Option inside TI Turbo Integrator dialog for “IBM Cognos Package” is greyed out PDF Print E-mail
(1 vote, average 1.00 out of 5)
Written by Roger   
Product:
IBM Cognos TM1 10.2 server (version 10.2.5000.367-0)
IBM Cognos TM1 package connector (version 10.2.5000.14-0)
IBM Cognos BI 10.2.1 Fix Pack 1 (version 10.2.5001.156-0)
IBM Cognos BI 10.2.1 Fix Pack 2 (version 10.2.5002.78-0)
Windows 2008 R2 server

Symptom:
After installation of TM1 Package Connector (tm1pc_10.1.1_bi_10.2.1_win_ml.tar) on the same computer where you have TM1 Architect and Framework Manager installed, the option inside TI Turbo Integrator dialog for “IBM Cognos Package” is greyed out and not selectable.

You only get this issue on the Developer computer where you have also installed frame work manager for Cognos BI 10.2.1 fix pack 1.
If there is only TM1 installed or there is not a Cognos BI fix pack installed, it will work.

Solution:
Uninstall TM1 package connector from your computer.
Leave the Framework Manager and other software still installed.
Run installation of TM1 Package Connector again, but
Select a new folder, like:
C:\program files (x86)\ibm\cognos\c10pack
And also remember to set a new shortcut folder name to “IBM Cognos 10 Package Connector”
Finish the installation.
Then go to start menu and open Cognos configuration from “IBM Cognos 10 Package Connector”.
Update the environment tab with values for you Cognos Gateway server;
http://BIgatewayname.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll
And for you Dispatcher URI for external applications set it to;
http://BIservername.domain.com:9300/p2pd/servlet/dispatch
Save the settings.
Exit Cognos Configuration.
Start TM1 Architect
Click on a TM1 application to login.
Inside a TM1 application right click on “processes” and select “create new process”
Try to click on “IBM Cognos Package” – if it works, then you have succeeded.

TM1 architect use the windows variable TM1_PACKAGE_CONNECTOR to find the installation files its needs, so this variable should be a system variable. You can type SET in the command prompt on the server to check its current value, it should be
TM1_PACKAGE_CONNECTOR=c:\program files (x86)\ibm\cognos\c10pack\bin

You need to replace the URL/PATHS with the correct values for your servers.

www.cogknowhow.com

 
«StartPrev12345NextEnd»

 

CogKnowHow Newsletter

Newsletter
Please register to the site before you can sign for a list.
No account yet? Register
Banner

Polls

How many users are working on your Cognos environment?