Skip to Content
author's profile photo Former Member
Former Member

#Unavailable in WEBI Report

Hi,

I get the error #unavailable in Webi (BO 4.0) and do not know what to do. I create a variable to generate the quarters. For this I use IF statements. Once created, I would like to add that variable and use the function "Insert Section". Then it showed me the quarters with the corresponding months(For Example: Q1= Jan 2011, Feb 2011, Mar 2011....). But it shows in the measure columns "#unavailable". I use for this report a bex query. Thanks for any help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2011 at 04:00 AM

    Hi Michael,

    #UNAVAILABLE appears when it is not possible to calculate the value of a smart measure because it is managed by the back-end - database-delegated. Smart measuresu201D are measures whose values are calculated by the database (relational or OLAP) on which a universe is based. They differ from classic measures, which are calculated from the detailed values returned by the database

    Kindly refer SAP Note 1606502 for more details on this; let me know if it helps.

    Regards,

    Nakul Mehta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2011 at 01:11 PM

    Hi Michael,

    I had a similar problem...

    SAP Note 1603634 solved my problem.

    Hope this helps you!

    Regards,

    Kathi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2015 at 10:39 AM

    Hi,

    this #unavailabel issue is not solved completely. It is caused by different factors and even with the latest version it might turn up. Following advices might reduce the chance of this problem:

    - using the latest patch

    - turn of query stripping

    - reducing the complexity of webI key-figures

    - using different webi key-figure calculation

    • Using a formula that may induce aggregation.
    • Filtering on a dimension which is not in the dimension context of the smart measure (i.e. not in block).
    • Applying a filter on a smart measure AND on a dimension in the dimensional context of the smart measure.
    • Aggregating (or delegating) filtered data.
    • Using the OR operator in nested filters.

    - checking the BEx query for clear restrictions in the key figure selection (that means even restrictions which normally should not cause any errors)

    Cheers Michael

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.