Product:
Cognos TM1 10.2
PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5000.367-0
LICENSE_TM1_version=LICENSE_TM1-AW64-ML-RTM-10.2.5001.0-0
Windows 2008 R2 Server
Cognos BI
Symptom:
Can not login to Cognos TM1 when using CAM security. It works when using the TM1 native security.
Error message:
The forward URL does not exist or it has failed validation. Ensure that a valid forward URL is specified.
Cause:
The file variables_tm1.xml is on the wrong BI server.
Solution:
Copy your updated variables_tm1.xml file to all your Cognos BI servers in your solution.
Place the file in folder \\biservername\d$\Program Files (x86)\ibm\cognos\c10_64\templates\ps\portal
In short is the installation to get CAM to work for TM1 10.2 web different from previous version.
Unzip the D:\Program Files\IBM\cognos\tm1_64\webapps\tm1web\gateway_files\ tm1web_gateway.zip files.
Rename d:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\gateway_files\tm1web_gateway\templates\ps\portal variables_TM1.xml.sample to variables_TM1.xml.
Update variables_tm1.xml with the TM1 server name at line 23 instead of localhost:
<CRNenv>
<urls>
<url is-regex="true">http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLogin.aspx</url>
<url is-regex="true">http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLoginHandler.aspx</url>
<url is-regex="true">http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebMain.aspx</url>
<url>../tm1/web/tm1web.html</url>
</urls>
<cookies>
<param name="cam_passport"/>
</cookies>
</CRNenv>
Update the tm1web.html file to Cognos TM1 Web server name at line 40:
// Update the following to point to the location of the TM1Web service(s)
var tm1webServices = ["http://localhost:8080"];
Change to:
var tm1webServices = ["http://tm1servername:9510"];
Copy the files to your Cognos BI installation:
variables_TM1.xml = Copy to d:\Program Files\ibm\cognos\c10_64\templates\ps\portal templates\ps\portal on your Cognos BI report server and content manager server.
Tm1web.html = Copy to d:\Program Files\ibm\cognos\c10\webcontent\tm1\web on your Cognos BI gateway server.
In tm1s.cfg file you need for each TM1 application add the values for:
ServerCAMURI=http://biservername:9300/p2pd/servlet/dispatch
ClientCAMURI=http://biservername/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=900
CAMPortalVariableFile=portal\variables_TM1.xml
DistributedPlanningOutputDir=.\tunit
ForceReevaluationOfFeedersForFedCellsOnDataChange=T
AllowSeparateNandCRules=T
The value CAMPortalVariableFile is not needed in the TM1S.CFG file for tm1web to work.
More (same) Information:
http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.2.0.doc%2Ft_tm1_inst_tm1web_cogsecurity.html
www.cogknowhow.com