using cognos tm1 cubes in framework manager

[Raj]

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

[sunosoft]

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

[Raj]

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

[sunosoft]

Did you manage to create TM1 data source and test it successfully ?

[MFGF]

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.

[Raj]

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

[MFGF]

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.

[Raj]

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
   

[MFGF]

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.

[Raj]

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

[MFGF]

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.

[sunosoft]

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

Not sure if its related to 32bit and 64 bit tm1 api....try installing both ...