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_member84747 · Accepted solution]

The problem you're having with finding the CPMS_CB_CUBES table makes this issue sound like you're not using the owner of those tables in your Link ID.

In SQL Server, if you're querying the tables as anyone but the owner, you have to use OWNER.TABLENAME as the format for accessing the tables. However, because we do not know who the owner of the tables is, it will vary in every CE installation, we simply assume that you're using the owner of the tables in your Link ID, and then you will be able to query using just the tablename.

In a CE installation, the owner of the tables is usually SAP<SID>DB, for example SAPCE1DB if your SAP Instance Identifier is CE1. This is a user that is automatically created by the CE installation in SQL Server, and is the user that you need to use in your Link ID. I would recommend that you check your Link ID and see what user you are using and make sure it is the SAP<SID>DB user. If it is not, when you make that change my guess is that you will be able to successfully build the cube from Cube Builder.

Hope this helps,

Robert