Skip to Content
0
Former Member
Dec 07, 2012 at 04:31 AM

Trying to build a model from cube builder in ssm 10. Syntax Error : select 'set control CUBEID ' || id<, row 34, item: 34

24 Views

After defining dimensions and KPI's tried to build the PAS model from model builder in ssm 10 encountered following error in trace file.

Also the procs have been copied from oracle folder to procs folder.

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 'set control CUBEID ' || id from cpms_cb_cubes where name = 'DEMO'

RFC RETURN: Type E

Id BRAINOLAPAPI

Number 4121388

Message Syntax error: Syntax Error : select 'set control CUBEID ' || id<, row 34, item: 34

Log No

Message V1 Syntax Error : select 'set control CUBEID ' || id<

Message V2 34

Message V3 34

Message V4

Parameter

Row 0

Field

System

LSLink> output proc setcubeid;PIPADMINDEFAULT over

LSLink> peek 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