error while creating a cube using Cube Builder

[Former Member]

we have installed the Cube builder for SSM 7.0

while creating the cube I am facing a error and the .TRC file contents are as follows :-

LSS>

LSS> set control LINKID SSM_CB_EA

LSS>

LSS> .... capture cube id in a control var to simplify queries on other tables

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> SELECT ID FROM CPMS_CB_CUBES WHERE NAME = 'CUBEBUILDER1'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CPMS_CB_CUBES'.

SQLSTATE: S0002

SQL System code: 208

LSLink> lss create code = 'set control CUBEID ' + ID

LSLink> output proc setcubeid;PIPADMINDEFAULT over

LSLink> peek create nohead nonumb

No Fields currently Selected

ACC004:

No Record Has Been Accessed From the Database.

ACC004:

No Record Has Been Accessed From the Database.

CHE FRE

CHE UPD

Kindly help me out........

[Former Member]

Hi Vijay,

It seems an ODBC error.

Did you create the ssm_cb_ea link ID which is explained in section 5.4.3 of the Server Configuration Guide?

Kind regards,

Santiago

[Former Member]

we have created that link as per the instructions given in the Configuration guide.

Edited by: vijay kumar on Dec 10, 2008 6:49 AM

[Bob_McGlynn]

Vijay,

Were you able to successfully test your LinkID connention in PAS? You may want to check to your SQLServer ODBC connections too.

Regards,

Bob