Hierarchy on HANA Calculation View with Optional Input Parameters Fails

[Former Member]

Hi,

Has anyone succeeded in building a hierarchy on top of a calculation view with optional input parameters, where an input parameter is not filled?

The original requirement came from the wish to create a parent child hierarchy on a calculation view that was copied into the customer space from a HANA Live Financial Statement query view, but I have found the following when creating a simple level hierarchy on a calculation view that consumes one table. The Calculation View has one Input Parameter where the 'mandatory' box is unchecked.

• Calculation view reads ECC table FAGLFLEXT
• Simple level based hierarchy on fields PRCTR, RACCT and SEGMENT
• Input parameter is used as a filter for PRCTR with logic ("EMPTY" = '$$P_PROFITCTR$$' or "PRCTR" = '$$P_PROFITCTR$$')

When I run the view I see the following behaviour in HANA Studio and Analysis for Excel

• Before building the hierarchy I could run the view with or without the Input Parameter
• After building the hierarchy I can run the view with the Input Parameter filled, but it fails when the Input Parameter is not filled.
• Error message is "error: search table error:  [2426] missing placeholder; missing value for mandatory parameter P_PROFITCTR"

P_PROFITCTR is not a mandatory parameter, but the selection for the hierarchy view thinks it should be. I don't find any notes around this issue, so I don't think it's version related, however the version I have used for this test is 1.00.70.

It's a shame we can't currently build the hierarchy as the parent child relationship is provided in HANA Live view NewGLFinancialStatementQuery.

Thanks,

Ken

[Former Member · Accepted solution]

I should add the comment that hierarchies do work in HANA SPS07 with optional input parameters. A new type of calculation view was introduced in SPS07 - the Star Join. We have found problems in SPS07 with hierarchies in a star join, however in SPS08 it seems to work. Given at this point SPS08 has not achieved 'data centre' approved status, I can't guarantee this will work as intended, but something worth looking.

[former_member42822]

Hello Ken,

From studio, only parent child hierarchy supports input parameter, and not level hierarchy.

Regards,

Vinoth

[Former Member]

Ken,

Your error message is showing that you are not mentioning values of IP for P_PROFITCTR column. Since you have mentioned IP as not mandatory, can you try to copy the model & activate it again.

You can also try with option of creating variables at semantic layer for filtering columns .

Kulwinder

[Former Member]

Hi Kulwinder,

Thank you for your response.

I have created this scenario a few times, so I don't believe copying and reactivating is going to help.

I'm pretty sure that if I change to optional variables instead of input parameters the hierarchy will work. However I would like it to work on HANA Live content, and it's not feasible to recreate their views from the ground up, plus input parameters are also used in formulas, not just as a filter.

Regards,

ken

[Former Member]

Hi Ken,

We have been facing similar issue. We have even tried to set default value and as optional parameter. View still fails to create hierarchy (we are not using HANA live). As mentioned on page 97 of HANA modelling guide input parameter is mandatory from engine point of view. Hierarchy is generated as column view during the initial activation of calculation view and therefore expect a value by caller.

This seems to be a product error. Some one from HANA development team should explain this issue in detail. I would expect someone like reply to us.

At the moment, we cant use input parameter for date prompt which gives us calendar popup feature for date selection. Hierarchies just don't work with input parameter. We are missing something.

Regards

Angad