Skip to Content
0
Former Member
May 19, 2015 at 11:12 AM

Incorrect result when creating AAO 2.0 report on top of HANA calculation view with [multiple entries, optional] Input parameters

40 Views

Hi,

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.

Regards,

Alston Tixeira.