Hi,
XQE error encountered: The property([0MATERIAL_ZPRODCODE]].[20MATERIAL_ZPRODCODE]]] 
does not appear in any dimension on the axis.
-Error comes while running a report. The report asks for prompt value but unable to 
run the report throwing the above mentioned error.
-  In the active report, it's developed in a basis that when I select a Product 
category, it'll drill down to products.  In its cross tab for products, when I bring 
Product category level 4 hierarchy, I'm not getting any error and I can execute the 
report.  When I bring the data Item available in level 4 hierarchy, which consists of 
key, description, I'm getting error.  But the same can be done in new active report 
crosstab.
Can you please suggest solution to resolve the error?
Regards,
Antony Jerald.