on 06-17-2012 11:05 AM
Hi Guys,
I need your help!
I´m working with the follow SSM environment :
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.
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..!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.