The Error #UNAVAILABLE is getting displayed in 2 measures of the report which is based on the Hyperion Essbase OLAP Cube.
The requirement is to display the current and previous year data in single block of the crosstab report. Below is the report template.
We have displayed the current year data in the Body Cells and the previous year data (just 2 fields) are getting displayed in the row headers. Kindly refer the attached document.
If I apply a filter in the block to get the current year data then I will be losing my previous year data in the report. Hence I am adding the WHERE clause in the column header and Body cells to get the current year data. The same is done to get the previous year data in the row headers.
Example: [Year] where ([Year]=”FY12” and [Scenario]=”Plan”)
After adding the WHERE clause in the column header and Body cells 2 of my measure objects displays #UNAVAILABLE.
Could you please let me know how this issue can be resolved?
BO Version : SAP BO 4.0 Fix pack 2
Using Rich Client to generate the report.