Skip to Content

<body><p>Here is this blog, which helps to fix an #UNAVAILABLE error and Date formatting in Web Intelligence from BEx based universe. </p><p># UNAVAILABLE ERROR</p><p>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.</p><p><img  />//weblogs.sdn.sap.com/weblogs/images/252181350/Unavailable.png|height=338|alt=image|width=339|src=https://weblogs.sdn.sap.com/weblogs/images/252181350/Unavailable.png|border=0!</p><p>How can we fix the error. We can modify the property of the measure object in universe to resolve the issue.</p><p>Measure object Properties-> Function to “Sum” (relevant projection too) , which was “Database Delegated” by default for OLAP universe.</p><p>Date Format</p><p>When we migrating the BEx reports to Web Intelligence report, mostly we ended up having issues with date format. Find below the format the BEx query returns to Web Intelligence report.</p><p><img  />//weblogs.sdn.sap.com/weblogs/images/252181350/BExDateFormat.png|height=362|alt=image|width=277|src=https://weblogs.sdn.sap.com/weblogs/images/252181350/BExDateFormat.png|border=0!</p><p>To fix the date format, say as MM/dd/yyyy format, then apply the following formula,</p><p> </p><p>=ToDate(FormatNumber(<Date Object>;”0″);”yyyyMMdd”)</p><p> </p><p>The result would be,</p><p><img  /></body>

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply