Page 1 of 1
TM1 Cognos BI Integration
Posted: Tue Jun 17, 2014 9:18 pm
by 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.
Re: TM1 Cognos BI Integration
Posted: Tue Jun 17, 2014 9:48 pm
by 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.
Re: TM1 Cognos BI Integration
Posted: Wed Jun 18, 2014 3:55 pm
by 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.
Re: TM1 Cognos BI Integration
Posted: Sun Jun 22, 2014 1:12 pm
by 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.