Getting and MDX Error while refreshing a WEBI Report

39 Views

Hi,

I have a problem in developing/refreshing my Webi Info view report.

I have my report like this.

It has 15 dimensions and 3 measures.

Purpose of the report is to display the purchase order details for a particular state/or all in a Country for a particular year.

In this scenario my database has two Calendar Years: 2011 and 2012.

And states (in US) as New York, Rhone Island etc..

Here comes the typical issue.

I have developed the report and when i m trying to refresh the report giving 2011 as Year and New York as State for prompts and generating the report.

Now i m getting the error of MDX query; Below is the error message:

"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( { (0PLANT__0REGION).[US NY] } , { (ZIPO_ID__ZCALYEAR).[2011] } ), (0PLANT).[LEVEL01].MEMBERS ), (ZIPO_ID).[LEVEL01].MEMBERS ), (0PUR_GROUP).[LEVEL01].MEMBERS ), (ZIVENDOR).[LEVEL01].MEMBERS ), { (ZIPO_ID__ZIPRICING).[TIME & MATERIAL] } ), { (ZIPO_ID__ZISEGMNT).[ELECTRIC], (ZIPO_ID__ZISEGMNT).[GAS & ELECTRIC], (ZIPO_ID__ZISEGMNT).[GAS] } ), EXCEPT( { (ZIPO_ID__ZICLASS).[LEVEL01].MEMBERS } , { { (ZIPO_ID__ZICLASS).[STOCK] } } ) ), (0CONTRSTART).[LEVEL01].MEMBERS ), (0CONTREND).[LEVEL01].MEMBERS ), (ZIPO_ID__0ENTRY_DATE).[LEVEL01].MEMBERS ), (ZIPO_ID__ZIPOAPDAT).[LEVEL01].MEMBERS ), (Measures).[35LYTRYAVWK4BUTF5WL7PC9AR] > 100000) ) DIMENSION PROPERTIES MEMBER_NAME, MEMBER_CAPTION, (0CONTREND).[20CONTREND], (0CONTRSTART).[20CONTRSTART], (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)"

This error is coming only when i m selecting 2011 and New York as prompt values.

When i m selecting any other value combinations, i dont get any error.

I m not sure why this error is coming.

Actually to say there is no data for the combination 2011 and New York. So ideally it has to display "No Data to Retrieve".

But this is not the case with these conditions.

Please suggset.

Thanks,

Prasad.