Skip to Content
0
Former Member
Nov 04, 2008 at 06:42 PM

Webi Report Against SAP BW Query Fails When Scheduled

23 Views

Hi all,

I'm facin a problem with all my Web intelligence Reports. When i refresh them on demand from view or design mode, everything works fine, but when i schedule them all instances fails with this error:

A database error occured. The database error text is: The MDX query SELECT { [Measures].[DF4LK70NQJ0KRU6XHODIE9TGA], [Measures].[3EG3OC7QZBODSE9J2JI4OLOPI], [Measures].[CXDGYOWE9FJFHS72KIO78WGTT], [Measures].[12C28AI1LLXSDEHMWCDUMJWCW], [Measures].[E2OE5J39YBUPP4IPZCX1HNHZX], [Measures].[5X2TIT4FSFEBHYFDEFACO2DCF], [Measures].[E6WGO3AACYBZ20ZIHZF28Y9TT], [Measures].[CB1PAR1H2KF21CWAY6G3NP2WK], [Measures].[8GZAGANUUZA7B2V59A5FBB5BO] } ON COLUMNS , NON EMPTY CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( [ZSOLTYPE].[LEVEL01].MEMBERS, [0CALMONTH].[LEVEL01].MEMBERS ), [0MATL_GROUP].[LEVEL01].MEMBERS ), [0MATERIAL__0MATL_TYPE].[LEVEL01].MEMBERS ), [0COMPL_DEL].[LEVEL01].MEMBERS ), [0BBP_STATUS].[LEVEL01].MEMBERS ), [0PLANT].[LEVEL01].MEMBERS ) ON ROWS FROM [CUBE_NAME/QUERY_NAME] SAP VARIABLES [ENTFINAL] INCLUDING X [0I_CALZ2] INCLUDING ENE 2008 : MAR 2008 failed to execute with the error FUNCTION_NOT_FOUND. (WIS 10901) .

BO is XI3.0, BW 3.5, Universe made from a SAP BW Query.

Thanks in advance!