Changing TNSNames.ora Location

This explains how to change the TNSnames.ora file location on registery

Go to registery find the Key_OracleClient10GHome1

add TNS admin parameter and edit that with the local path where TNSNames.ora is available.

Scheduling TNS Names for Auto Refresh

1. Create a batch file to copy the TNS names form Common Location

2. Save this file to a location on local.

3. Schedule it with Windows "Scheduled Tasks"

---------------------------------
@echo off
setlocal
REM Copy tnsnames.ora from x:\batch to d:\oracle...  Execute weekly or as needed updates are identified.
copy /v /y file://ad.xxxx.com/whq/CorpApps/BATCH/tnsnames.ora D:\oracle\tnsnames
endlocal
echo on
---------------------------------

Setting Load Balancing on Cognos8

Load Balancing is used when you have non identical server on a distributed environment.

Pic 1.


Select properties--> Settings-> Category--> Tuning

Select Router Capacity to XX based on the number assigned on the server.

Cognos 10

IBM Cognos 10 Redbook link and new features details

Link to the Book
http://www.redbooks.ibm.com/redbooks/pdfs/sg247912.pdf

Some of the Feature I like:
New dynamic query capability. Optimized caching, in-memory calculations, 3x faster query

Cognos admins can export all system metrics to a RDBMS and then analyze with Business Insight(new Dashboard tool integrated in COgnos 10).

The UI works very well and looks very well thought out.

Allows end user to manage their own login credentials reducing the load on IT.

we should more intensively use upgrade manager

Improved content manager performance through caching and faster olap in memory caching

New external data wizard for Cognos10 Report Studio. A feature that supports and encourages agile development

No more messy javascript to modify prompt object text - they are now modifiable properties in cognos10 (this is the best)
---------------------------------------------------------------------------------------------------

Cognos 10.1 installation & configuration guides
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=/com.ibm.swg.im.cognos.vvm_installation_guide.10.1.0.doc/vvm_installation_guide.html

---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------

Conos8

Schedule an Entry/Report Based on an Occurrence/Trigger 
http://abhishekdharga.blogspot.com/2010/12/schedule-entryreport-based-on.html

How to find Cognos installed Version

Go to cognos installation location and find the cmplst file. This conmtains the installation details with exact version.


How to enable ISAPI on Windows 2008 server 64-bit with IIS 7.0

http://www.cogknowhow.com/index.php/knowledge-articles/30-cognos-8/376-how-to-enable-isapi-on-windows-2008-server-64-bit-with-iis-70