Tips on installing Cognos Planning 10.2

Product:

Cognos Planning 10.2

Windows 2012 server

Issue:

How install the new Cognos planning on windows server?

Some help:

Use of this information should help you get it right, ensure this things are done before you test the installation.

To integrate with Cognos BI try this  tips from ”How can I install IBM Cognos Planning in the same environment as 64-bit IBM Cognos Business Intelligence”

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

Error when start Planning Analyst and other tools ”cannot find files”
Ensure to do this:

renamed adminbifs.amf to adminbif.AMF
renamed adminodbc.AMF to adminodb.AMF
http://www-01.ibm.com/support/docview.wss?uid=swg21635667

Windows supports long file names up to 255 characters in length. Windows also generates an MS-DOS compatible short file name in 8.3 format to allow MS-DOS based or 16-bit windows based programs to access these files. When the 8.3 setting is enabled only short file names are generated. Therefore the long file name of adminbifs.AMF is shortened to adminbif.AMF and adminodbc.AMF is shortened to adminodb.AMF and this causes the error on startup as the file cannot be located as it does not exist under that name and Analyst is a 32-bit program and works off the long file name only.
Error when starting Planning Analyst of type ”cannot connect libraries”
Ensure to do this:

1. Launch MSCONFIG by from the Run menu.

2. Click on the Tools tab. Scroll down till you find “Disable UAC” . Click on that line.
3. Press the Launch button.
4. A CMD window will open. When the command is done, you can close the window.
5. Close MSCONFIG. You need to reboot the computer for changes to apply.

OR

Alternate Solution:
1. Give the everyone group full control to the folder where the libraries are located.

OR
Alternate Solution: If User Account Control resolution above does not resolve issue:
1. Right-click the Analyst shortcut
2. Select Properties > Compatibility tab
3. Check the box: Run this Program as Administrator
4. Now open Analyst as the user who is receiving the error.

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

To have access to the folders on the SQL server you need to do this:
Install the SQL Server Client tools (if this has not already been done).

NB For SQL Server 2005 you need to have the full SQL Client installed (comes with SQL Express) as the Native Client does not install all of the required .dll files.
For SQL Server 2008 full client tools required.

Once the SQL Server Client tools are installed, ensure that the Contributor user account used to connect to SQL Server has EXEC permissions to the following Extended Stored Procedures in the Masters Database:

xp_availablemedia
xp_subdirs
http://www-01.ibm.com/support/docview.wss?uid=swg21343839
Contributor Datastore server connection check Trusted Connection instead of login with an account

Depending on the setup you should use Trusted or SQL account login. Try the other if you have issues like “Subscript out of range”
http://www-01.ibm.com/support/docview.wss?uid=swg21986012

There are more things to configure — search google.com if you get issues.

http://www-01.ibm.com/support/docview.wss?uid=swg21991365&myns=swgimgmt&mynp=OCSSPN2D&mync=R&cm_sp=swgimgmt-_-OCSSPN2D-_-R

https://www.ibm.com/support/knowledgecenter/SSPN2D_10.2.0/com.ibm.swg.ba.cognos.cp_inst_cr_winux.10.2.0.doc/c_installingcognos8planningwithcognos8businessintelligence.html