TM1 Cognos BI Integration

[LutherPaul]

Hi Gurus,
I want to know what components are required on BI servers for BI integration.
We are planning on having CAM security and access TM1 cubes on BI server.
Environment - 10.2.2.
Can someone help?

Thanks,
Luther.

[declanr]

The install documentation is actually pretty good for this as long as you follow it step by step in the exact order it says I've not seen any issues.

There are files to unzip from the tm1 install and copy over to the BI server etc but like I said its all (unusually) well documented.

[LutherPaul]

Thanks Declanr. I restarrted the servers and found that I get diff error now.

I am configuring CAM - integrated security -5. I have one TM1 server 10.2.2 (admin and Tm1 server) and two TM1 web servers, two BI APP(10.2.1 with fix pack 4) and two BI web servers.

As read in the install guide, I have put various files in respective folders(planning.html, variables_TM1.xml and others). Can anyone help me with the path that security moves from which page to which?

Currently, I am having issues with web page redirecting between below URLs.

http://BI_WEB_SERVERNAME.com/ibmcognos/planning.html?cam_passport=MTsxMDE6NmNiYzZlNjYtZWMyNS1mNmE5LTMzOWMtMDk1OTExOWI2MzY3OjE0MDYzNzcwNDk7MDszOzA7&CRN=showOptionSummary%3Dtrue%26useAccessibilityFeatures%3Dfalse%26columnsPerPage%3D3%26skin%3DASRC_Corporate%26showHiddenObjects%3Dfalse%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2Fconstants%2FbiDirectionalOptionEnum%23biDirectionalFeaturesEnabled%3Dfalse%26productLocale%3Den%26displayMode%3Dlist%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2Fconstants%2FsystemOptionEnum%23accessibilityFeatures%3Dfalse%26contentLocale%3Den-us%26listViewSeparator%3Dbackground%26timeZoneID%3DEST%26format%3DHTML%26automaticPageRefresh%3D30%26showWelcomePage%3Dtrue%26linesPerPage%3D150%26&pg=%2fapplications.jsp&ps=http%3a%2f%2fAFBI-C10TM1WBP1.asrcfh.local%3a9510

and

http://BI_WEB_SERVERNAME.com/ibmcognos/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/bridge.xts&c_env=portal/variables_plan.xml&c_cmd=../planning.html&ps=http%3A%2F%2FAFBI-C10TM1WBP1.asrcfh.local%3A9510&pg=%2Fapplications.jsp


Thanks,
Paul.

[dkleist]

Not sure about 10.2.2 but in earlier versions, it did a string match on server name from the server config files (i.e. not tm1p.ini). This meant either all references need to be all FQDN or all short names. Unless they've updated the doc, the examples mixed the types and I couldn't get it to work when strictly adhering to the documentation. Can't quite say where the string match happens as it's been a while since I ran into that. I think it was the BI side pointing back to TM1 after the security call.

Also, if you go short name, you may need to manually edit fmpsvc_config.xml on the TM1 server (the config page kept stuffing in the FQDN, so I shut down services and edited manually). This was 10.2.1 so not sure if that was fixed.