Issues connecting Analysis for Office to HANA Calculation Views with Input Parameters

[former_member277290]

Hi Folks,

I am having difficulties making Analysis for Office work correctly when connecting to HANA Calculation Views which use Input Parameters or Variables.

I define an Input Parameter, with reference to an existing column:

A restricted key figure column is defined with reference to the input parameter:

When using Data Preview in HANA Studio, the prompt appears with appropriate Value Help, reading from the column it is referencing.

and the results of Data Preview behave as expected:

Now over in Analysis for Office, the prompt does appear, but I get no Value Help appearing. (Note: This is true even when the Input Parameter type is set to 'List' and I hard code appropriate values in the IP definition.)

And when continuing, if I simply type in a value and continue, I get 'No applicable data':

Alternately, if I type in a value into the search box of the prompt, I can get individual values to appear. If I select these using the radio button, instead I get a different error:

in some other attempted implementations, results will appear but any calculations using the input parameter will simply be ignored as if the value is not passed to the back end.

I have also tried this with Variables instead of Input Parameters - they are just ignored completely and do not even activate the Analysis for Office Prompt.

So can anybody point out if I am missing a step or approaching this incorrectly? It seems like this should be a quite straightforward exercise but I am at a loss to explain where the problem is.

Kind Regards,

-Elliott

[akshinde]

what is version of AFO you are using

[former_member277290]

This is on AfO 2.6.201

[former_member211603]

Hi,

Did you find solution to this problem. I am also facing same issue.

I have tried cal view->compositie provider -> Bex query->AFO 2.7

Cal view -> AFO 2.7 still same issue in both cases. Can not get any prompt values (F4) for input parameters.

[former_member277449]

Hi Elliott, did you find a solution / workaround for it. I am facing the same issue.

Thanks,

safia

[TammyPowlas]

Hi Elliott, I am not using HANA but I found some SAP notes that may apply:

https://launchpad.support.sap.com/#/notes/2603528

https://launchpad.support.sap.com/#/notes/2433770

[former_member277290]

Thanks Tammy as always for the swift response.

Unfortunately those notes don't seem to apply here. Merge Variables doesn't come into it because I'm not attempting to do any merge (although it is disappointing that you can't merge when connecting directly to HANA Views. Boo!), and I believe parameter mapping is only relevant for variables, whereas my issues are primarily happening with Input Parameters.
The example above uses Input Parameters with type Column, where I explicitly maintain a mapping for Value Help to a column in the View. This works as expected in the Studio, just not when talking to AfO for some bizarre reason.

[vincenzocappelluti]

"HTTP Status 405 - Bad Method" error in the first link