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

#Unavailable error in webi

Hello,
In below example crosstab webi report, ObjQ is coming from Excel dataprovider; ObjC, ObjM, KF are coming from BEx Query. objM is merged object and vObjQ is detailed variable (associated to merged object)
So If we break the report on detailed variable vObjQ, then sum for each objQ (i.e sum(vObjQ) is displaying fine but I am expecting sum of Q1 and sum of Q2 in the end as seperate columns.

vobjQ Q1 Q1 Q2 Q2 objM M1 M2 M3 M4 Q1 Q2 objC KF KF KF KF KF KF CT1 10 20 30 40 30 70

If we apply below formulae it is working fine.
=sum([Kf] in ([objC];[objM];[vobjQ]) where ([objM] inlist ("M1";"M2")))

But there are chances of M3 falling under Q1, so again instead of editing above formulae to add M3 in the list, I am trying to restrict on vObjQ instead of objM. Something like below. But it is dislaying #UNAVAILABLE.

=sum([Kf] in ([objC];[objM];[vobjQ]) where ([vObjQ] = "Q1"))

I went through related SAP notes and concepts of smart measures, database deligated and calucation context..... but i can't find any workaroud. Could anyone please hsuggest me to get rid of this error message.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2012 at 01:53 PM

    Hi Prem,

    You don't mention which version you are on. I can tell you that there are a lot of fixes for these types of messages in the latest patches so test with the absolute latest version and see if you still have a problem. There is actually a thread on this page where some of the fixed issues are outlined.

    Thanks,

    John

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2012 at 03:19 PM

    Hi Prem,

    We usually get the error, when we use the Measures which are coming out of Bex query universes. #UNAVAILABLE occurs when we are using smart measures and Web Intelligence cannot calculate the value based on the contexts used. Do not use smart measures while applying filter on a aggregated value from your query and further aggregate it within the report. At the same time, it will throw the error, when we use it in the formula too.

    How can we fix the error. We can modify the property of the measure object in universe to resolve the issue.

    Measure object Properties-> Function to "Sum" (relevant projection too) , which was "Database Delegated" by default for OLAP universe.

    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.