Getting a MDX Query Error while refreshing a report.

[Former Member]

Hi,

I m using SAP BO 4.0 for building our reports.

There is BEX query on top of which Universe is built and report is built based on that Universe.

There were no prompts or filters defined at BEX level. All the prompts/filters/conditions are to be applied at report level.

There were around 16 dimensions and 3 measures in my report.

Two Prompts were created.

1. Against Approved Date and 2. Against State.

5 Filters/conditions were defined at BEX level.

When i refresh the report, i m getting an MDX error. Below is the error message i m getting.

"

Database error: The MDX query SELECT  { (Measures).[35LYTRYAVWK4BUTF5WL7PC9AR] }  ON COLUMNS , NON EMPTY UNORDER( FILTER( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN(  { (ZIPO_ID__ZCALYEAR).[2011] } ,  { (ZICTR_ID).[#] }  ), (ZICTRITEM__0CONTRSTART).[LEVEL01].MEMBERS ), (ZICTRITEM__0CONTREND).[LEVEL01].MEMBERS ),  { (0PLANT__0REGION).[US NY] }  ), (0PLANT).[LEVEL01].MEMBERS ), (ZIPO_ID).[LEVEL01].MEMBERS ), (0PUR_GROUP).[LEVEL01].MEMBERS ), (ZIVENDOR).[LEVEL01].MEMBERS ),  { (ZIPO_ID__ZIPRICING).[TIME & MATERIAL] }  ),  { (ZIPO_ID__ZISEGMNT).[GAS & ELECTRIC], (ZIPO_ID__ZISEGMNT).[ELECTRIC], (ZIPO_ID__ZISEGMNT).[GAS] }  ), EXCEPT(  { (ZIPO_ID__ZICLASS).[LEVEL01].MEMBERS } , {  { (ZIPO_ID__ZICLASS).[STOCK] }  } ) ), (ZIPO_ID__0ENTRY_DATE).[LEVEL01].MEMBERS ), (ZIPO_ID__ZIPOAPDAT).[LEVEL01].MEMBERS ),  (Measures).[35LYTRYAVWK4BUTF5WL7PC9AR] > 100000) )  DIMENSION PROPERTIES MEMBER_UNIQUE_NAME, MEMBER_NAME, MEMBER_CAPTION, (ZICTRITEM__0CONTREND).[2ZICTRITEM__0CONTREND], (ZICTRITEM__0CONTRSTART).[2ZICTRITEM__0CONTRSTART], (ZIPO_ID).[2ZIPO_ID], (ZIPO_ID__ZIPRICING).[1ZIPO_ID__ZIPRICING], (ZIPO_ID__ZIPRICING).[2ZIPO_ID__ZIPRICING], (ZIVENDOR).[20NAME], (ZIVENDOR).[2ZIVENDOR] ON ROWS FROM (ZSC_MPDTD/ZSC_MPDTD_QU0099)  failed to execute with the error Please enter a valid value for characteristic 0PLANT__0REGION.. (IES 10901) (WIS 10901)"

Can some one please suggest how to resolve this?

Thanks,

Prasad.

[nikhil_joy2]

Hi Prasad,

Error message mentioned here comes when threre is an add/change of any characteristic variable or hierarchichal variable in bex query. It breaks the webi report. An update is required to repair it. Check if you have made any changes in Bex query.

Refer below link and search for your error message.

http://wiki.sdn.sap.com/wiki/display/BOBJ/Impact+of+a+BEx+query+change+to+universes+and+WebI+documen...

Regards,

Nikhil Joy

[Former Member]

Hi Nikhil,

Thank you for your response.

There is no change made to my BEX query.

I referred to my BEX query and top of that i have refreshed my universe to reflect any changes made at BEX level.

I got a message saying that nothing to update

Please suggest.

Thanks,

Prasad