#UNAVAILABLE Error in SAP BW Webi report

#UNAVAILABLE Error is a common notice in Web intelligence reports with SAP BW universe.

All the key figures in the SAP BEx query is set to sum without any Exception Aggregation.

The reason for this error is that measures coming from BEX is set Database Delegated by default and there is no way to set them as SUM in BICS connection (direct connection to BEX). This can be fixed at OLAP universes created in

Universe Design Tool by setting measures’ aggregation type from Database Delegated to SUM.
When we create a variable in Webireport, and put it on a table with measure. Measure asks BW to give the value based on WebI variable. Since BW has no such a value, it returns #UNAVAILABLE.

This problem is fixed in SAP BOBJ BI4.0 SP4 with BICS connections., Upgrade to SAP BOBJ BI4.0 SP4 patch 9 is advisable.


One thought on “#UNAVAILABLE Error in SAP BW Webi report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.