BI IP - Issue with input query/web template when no data available
We need dynamic number of fiscal periods in the data columns section based on type of planning (i.e. annual or quarter etc). We have used fiscal period with variable in the columns section which determines number of periods.
Access Type for Result Values attribute has been selected as 'Master Data' for the fiscal period in order to get data columns for all the required periods even if there is no data for any particular period.
If the filter conditions returns at least one record of data then the input template works fine. It displays current data and also displays new rows/lines for input.
However, if the filter condition does not retrieve any data at all then in stead of displaying blank new lines for input, the template gives java runtime error:
<b>The initial exception that caused the request to fail was:
Invalid state: Section I is valid, but neither II nor III. </b>
This is a very general requirement in a planning application.
Searched for OSS notes and could not find any note which can fix this issue.
Any help how to resolve this issue will be highly appreciated.
Tried to see how workbook planning application behaves for this same case. It doesnt give runtime error. Displays no data found, however doesnt give new lines for input.