#Unavailable error in webi

[Former Member]

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,

[Former Member]

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.

[former_member188911]

This would be correct if he was using Universes, in this case they are using BICS so the reply from Zahid seems the right one.

[Former Member]

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

[Former Member]

We are with BI 4.0 SP02 Patch 16. But If it is known bug and resolved with latest patch then probably we can suggest them to upgrade to latest version. was it mentioned in any release notes..??

[Former Member]

Search this for #unavailable:

https://websmp109.sap-ag.de/~sapidb/011000358700000629402012E/xi4sp4_release_notes_en.pdf

You might be able to install the sp4 client tools (for the webi rich client) or the full server on a test machine and see if the issue still exists to have a higher level of confidence than just checking the fixed issues list.

Thanks,

John

[former_member184594]

This issue is fixed with SP4 if your key figures's aggregation type is SUM. I have tested it. If I were you, I would have installed this SP4 on my system. Before apply this package check the notes 1733905 and 1695543.