Error in BUILD pas Model - No database found- Cubebuilder

31 Views

Hi all,

I am working on SSM 10.1 SP 3.

I creating a model in cube builder and after creating dimension and measure sets, when I click on BUILD PAS MODEL, it is giving me below error.

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 CONVERT(VARCHAR, ID) AS CID FROM CPMS_CB_CUBES WHERE NAME = 'SSM1'
[Sybase][ODBC Driver][Adaptive Server Enterprise]CPMS_CB_CUBES not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

SQLSTATE: 42000
SQL System code: 208

LSLink> lss create code = 'set control CUBEID ' + CID
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

Please help

Thanks and regards

Rahul Sharma