cancel
Showing results for 
Search instead for 
Did you mean: 

Error when Build SAP Model (SSM Cube Builder)

Former Member
0 Kudos

Hi Guys,

I need your help!

I´m working with the follow SSM environment :

  • SSM 7.5 (SP 12)
  • NetWeaver 7.2 (SP 07)
  • Oracle 10.2.0.5 Database
  • Link ID (SSM_CB_EA - Success in Test Connection)
  • Windows Server 2008 R2 Enterprise (64-bit)

When i'm make Cube use Build SAP Model there is an error :

There was a problem with the creation of the cube.

Check the content of the cb_build_SGG.trc file in the HOME directory.

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 = 'SGG'

LSLink> output proc setcubeid;PIPADMINDEFAULT over

LSLink> peek nohead nonumb

set control CUBEID 111601532764195                                                                                                                                                   

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setcubeid;PIPADMINDEFAULT

LSS> set control CUBEID 111601532764195

LSS>

LSS> .... start by getting FY start month and setting calendar

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> select fy_start_month from cpms_cb_cubes where name = 'SGG'

LSLink> lss create code = 'set fiscal calendar ' + fy_start_month

LSLink> output proc setfiscal;PIPADMINDEFAULT over

LSLink> peek create nohead nonumb

set fiscal calendar January                                                                                                                                                                                 

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setfiscal;PIPADMINDEFAULT

LSS> set fiscal calendar January

LSS>

LSS> .... build all the dimensions

LSS> job 'cb_adddims.pro'

LSS> .... cb_adddims.pro

LSS>

LSS> ..... procedure called to add and also update dimensions

LSS>

LSS>

LSS> .... temp table has info for dims in this model that is used by cb_onedim.pro

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> .... should have been dropped at end of last build but doing here just in case

LSLink> drop table cpms_cbtmp1

ORA-00942: table or view does not exist

   

LSLink>

LSLink> begin

> create table cpms_cbtmp1 as

> select id, name, num_levels, level0 as inp,

> ifnull(',' || level1, ' ') as out1,

> ifnull(',' || level2, ' ') as out2,

> ifnull(',' || level3, ' ') as out3,

> ifnull(',' || level4, ' ') as out4,

> ' ' as result

> from cpms_cb_dims

> where  cpms_cb_cubes_id = 111601532764195

> and result = 1

> union

> select id, name, num_levels, level0 as inp,

> ifnull(',' || level1, ' ') as out1,

> ifnull(',' || level2, ' ') as out2,

> ifnull(',' || level3, ' ') as out3,

> ifnull(',' || level4, ' ') as out4,

> 'NORESULT' as result

> from cpms_cb_dims

> where  cpms_cb_cubes_id = 111601532764195

> and result = 0

> end

ORA-00904: "IFNULL": invalid identifier

LSLink>

LSLink> select id from cpms_cbtmp1

ORA-00942: table or view does not exist

   

LSLink> lss create code = "job 'cb_onedim.pro' '" + id + "'"

LSLink> output proc blddims;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

The problem is caused because the oracle that does not recognize the IFNULL function or any configuration errors? Please help.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

only paste all files on :

C:\Program Files (x86)\SAP BusinessObjects\Strategy Management\InternetPub\procs\oracle_procs

to

C:\Program Files (x86)\SAP BusinessObjects\Strategy Management\InternetPub\procs\

SUCCESS..!!

Naser
Discoverer
0 Kudos

HI,

I'm getting this error.

What you mention above I did the same copy from InternetPub\procs\oracle_procs to InternetPub\procs\ but still, I'm getting the same error message:

There was a problem with the creation of the cube.

Check the content of the cb_build_SGG.trc file in the HOME directory.


Kindly let me know how to solve it.

Regards,

Naser

Answers (0)