Hi,
presently i am using frame work manager 10.2.1 version,recently i got a requirement i.e we already have cognos tm1 cubes in some other server so i need to use those cubes in FM and have to create package for reporting purpose, but i dont have any idea on that, how i have to use tm1 cubes in FM.
I have tm1 client and tm1 api, by using this i need to create packages in FM. please advise me what steps i have to follow.
Thanks in advance,
sekhar
You need to install TM1 api on Cognos servers first. Then you need to create datasource for TM1 cube. After this u can start working in FM by connecting this TM1 data source.
Below link gives all details.
https://www-01.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/c_tm1_deploy_as_datasource_cogbi.html
Hi,
Thanks for reply
while doing the above process in frame work manager iam getting below error
TM1-ERR-0073 the TM1 server <admin server name>/abcde cannot be found
XTM-CON-0001 An attempt to login to the TM1 server failed. The TM1 error code is: SystemServerNotFound. The TM1 error message is: SystemServerNotFound. " Admin Host:"xxxx" Server Name:"TM1E_Test"".
please help me to resolve above error.
Thanks,
sekahar
Did you manage to create TM1 data source and test it successfully ?
Quote from: sekhar1988 on 23 Dec 2015 03:52:26 AM
Hi,
Thanks for reply
while doing the above process in frame work manager iam getting below error
TM1-ERR-0073 the TM1 server <admin server name>/abcde cannot be found
XTM-CON-0001 An attempt to login to the TM1 server failed. The TM1 error code is: SystemServerNotFound. The TM1 error message is: SystemServerNotFound. " Admin Host:"xxxx" Server Name:"TM1E_Test"".
please help me to resolve above error.
Thanks,
sekahar
Hi,
The "Admin Host" should be the host name or IP address of the server hosting your TM1 instance. In this case it appears you have entered it as xxxx? It can usually be found as the "AdminHost" setting in your tm1s.cfg file.
The "Server Name" should be the name of the TM1 instance you have configured on that machine. It can be found as the "ServerName" setting in your tm1s.cfg file. It must also be running - either as a service or as an application.
Cheers!
MF.
thanks for reply,
now iam connected successfully to tm1 server and imported the cube in FM and then i published this in cognos connection
But while running the report using this package iam getting below error, please advise what i have to follow
XQE-PVD-0003
An error occurred while loading provider instance "NGTM1":
XTM-JAP-0001 An attempt to initialize the TM1 API failed. The TM1 error code is: CannotInitializeAPI. The TM1 error message is: "Could not load tm1api.dll due to: The specified module could not be found.
details:
RSV-SRV-0042 Trace back:RSReportService.cpp(754): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(857): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(914): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSMetadataService/RSMetadataMgr.cpp(185): XQEException: CCL_RETHROW: RSMetadataMgr::executeRequest()RSQueryMgrBasic.cpp(289): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandQFSSession.cpp(1153): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(180): XQEException: CCL_RETHROW: QFSQuery::ExecuteXQEConnector.cpp(289): XQEException: CCL_THROW: XQEConnector::send
Thanks,
sekhar
Quote from: sekhar1988 on 24 Dec 2015 02:48:41 AM
thanks for reply,
now iam connected successfully to tm1 server and imported the cube in FM and then i published this in cognos connection
But while running the report using this package iam getting below error, please advise what i have to follow
XQE-PVD-0003
An error occurred while loading provider instance "NGTM1":
XTM-JAP-0001 An attempt to initialize the TM1 API failed. The TM1 error code is: CannotInitializeAPI. The TM1 error message is: "Could not load tm1api.dll due to: The specified module could not be found.
details:
RSV-SRV-0042 Trace back:RSReportService.cpp(754): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(857): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(914): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSMetadataService/RSMetadataMgr.cpp(185): XQEException: CCL_RETHROW: RSMetadataMgr::executeRequest()RSQueryMgrBasic.cpp(289): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandQFSSession.cpp(1153): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(180): XQEException: CCL_RETHROW: QFSQuery::ExecuteXQEConnector.cpp(289): XQEException: CCL_THROW: XQEConnector::send
Thanks,
sekhar
Did you install the TM1 client tier on your Cognos server as suggested by sunosoft?
https://www-01.ibm.com/support/knowledgecenter/SS9RXT_10.2.0/com.ibm.swg.ba.cognos.tm1_inst.10.2.0.doc/t_tm1_inst_enablingbireportingontm1datasources.html
MF.
Thanks for reply,
Yes, Tm1 admin installed Tm1 client Tier in cognos server,with out installing tm1 server can we create the package in fm with Tm1 cubes.
please correct if my question is wrong
Thanks,
sekhar
Quote from: sekhar1988 on 24 Dec 2015 04:13:29 AM
Thanks for reply,
Yes, Tm1 admin installed Tm1 client Tier in cognos server,with out installing tm1 server can we create the package in fm with Tm1 cubes.
please correct if my question is wrong
Thanks,
sekhar
Yes you can. Did you restart the Cognos BI service after installing the TM1 client tier?
MF.
Yes, But i can see the Tm1 cubes in Framework manager and ibm cognos connection while running report only im not getting the data from tm1 servers and i am getting above error.
Thanks,
sekhar
Quote from: sekhar1988 on 24 Dec 2015 06:18:21 AM
Yes, But i can see the Tm1 cubes in Framework manager and ibm cognos connection while running report only im not getting the data from tm1 servers and i am getting above error.
Thanks,
sekhar
The above error seems to indicate the TM1 client tier isn't installed.
MF.
QuoteXQE-PVD-0003
An error occurred while loading provider instance "NGTM1":
XTM-JAP-0001 An attempt to initialize the TM1 API failed. The TM1 error code is: CannotInitializeAPI. The TM1 error message is: "Could not load tm1api.dll due to: The specified module could not be found.
details:
RSV-SRV-0042 Trace back:RSReportService.cpp(754): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(857): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(914): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSMetadataService/RSMetadataMgr.cpp(185): XQEException: CCL_RETHROW: RSMetadataMgr::executeRequest()RSQueryMgrBasic.cpp(289): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandQFSSession.cpp(1153): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(180): XQEException: CCL_RETHROW: QFSQuery::ExecuteXQEConnector.cpp(289): XQEException: CCL_THROW: XQEConnector::send
Not sure if its related to 32bit and 64 bit tm1 api....try installing both ...