SAP Knowledge Base Article - Preview

1589459 - Key Figure shows #UNAVAILABLE when you use a variable or formula on a Dimension objects using BICS

Symptom

  • You create a report on BI 4.0 using Web Intelligence via BICS
  • Creating a variable or formula =If(Match([Country];"*C*")) Then "Sparkling" Else [Country]
  • Add the variable to the report Panel and run the query the result show the key figure #UNAVAILABLE


Read more...

Environment

  • SAP Business Objects Enterprise 4.0
  • SAP BW 7.01
  • Using BICS conectivity from SAP Business Objects to SAP BW
  • Web Intelligence  ( Desktop and Thing Client)

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

KBA , BI-RA-WBI , Web Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.