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.
TM1 Cognos BI Integration
-
- Posts: 80
- Joined: Tue Jun 04, 2013 3:35 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Cognos BI Integration
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.
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.
Declan Rodger
-
- Posts: 80
- Joined: Tue Jun 04, 2013 3:35 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: TM1 Cognos BI Integration
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.
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
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.
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.