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 Martin

i think you better raise this question as a new thread since it will get more exposure and u can get a more number of hits and answers.

as for your problem kindly check if the master of your database is 'SAPCE1ADM' or something else. i made a similar mistake and got it corrected now. Plus kindly create an ODBC connection and check your system DSN both at the server side and your PC side as well and ensure you have the required drivers.

hope this helps

Vijay.