# unavailable error on databse delegated measure from bex

[former_member195433]

I get unavailable error  on a  smart measure when I filter business =S1 ;  

Business , functions are group variables create in report  on cost center .

Business has two value  = S1 and S2 .

I have created a formula on HC  to include function , business and cost center in context to  avoid error   but no luck so far . any suggestions in writing a workaround formula on smart measures.

we are on  4.1 SP2

  = sum(HC  for each( Cost center , function , business ))

[amitrathi239]

Hi,

Better to raise a ticket with SAP Support team. This error still persists in BI 4.1 and for different secnior sap recommended the patches.

See attached sap note. 2036981 - #UNAVAILABLE error for some delegated measures shown in Web Intelligence reports

This is not exact the same issue which you are getting but sap support team will review and suggest.

Amit

[Former Member]

check out below link:

[former_member195433]

we are at 4.1  version . But we still get the error

[former_member195292]

Gone throught this SAP note helps you to find your senarios anbout this error 1606502 - BI 4.0: #UNAVAILABLE in Web Intelligence report using BEx query

[former_member195433]

I  was infact referring  to this note  but  what was solution or work around ?