#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.

Advertisements

One Response to #UNAVAILABLE Error in SAP BW Webi report

  1. Eric says:

    we have sp4 and patch 9 but stil have the problem sum no option because it is about average measures

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: