I have a HANA calculation view, with a [column, multiple entries, optional] input parameter on the year field. This input parameter uses a hana live view (sap.hba.ecc::year) to get its help values. On doing a data preview, I am able to get correct output in HANA studio.
However, when I am using this same view in Advanced Analysis for Office 2.0, the following 3 scenarios occur:
1. Year Prompt - Nothing is selected for year : Output shows data only for the default value of input parameter (which in my case is 2015).
Ideal output: Data for all the years should be shown for which there is data available.
2. Year Prompt - (with initial values of input parameter i.e. 2015) : No applicable data found.
Ideal output: Data for the year 2015 should be shown for which there is data available.
3. Year Prompt - (From the value help more values are chosen say, 2008, 2014, 2015) : No applicable data found. In the backend I have checked
there is data available for all these 3 years.
Ideal output: Data for the years, 2008, 2014 and 2015 should be shown for which there is data available.
Even when the input parameter is mandatory, scenarios 2 & 3 occur.
Please share your insights or inputs in how can this situation be mitigated.