Hana Visualization plan execution of calculation view - Columnar search filter sequence issue

[former_member568360]

Hi All,

In my current project I am facing the challenge on Columnar search time vs number of records on base table and trying to understand how the sequence of filtering will be determined.

Would like to put with example.

I have a filter expression on Sold_to, Material Group and Billing Date at initial projection filter expression.

filter expression: (date("BILL_DATE") >= adddays(date('$$IN_BILL_DATE_TO$$'),-10) and date("BILL_DATE") <= date('$$IN_BILL_DATE_TO$$')) and (in("SOLD_TO", '$$ZIN_SOLD_TO$$') or match ("SOLD_TO",$$ZIN_SOLD_TO$$)) and (in("MATL_GRP_3",'L2','LC'))

Have INPUT parameters on Billing date and Sold_to. Sequence is Billing Date and Sold_TO

Expected Time of Column Search:

Customer selection(90 Records with 1 Sec) --> Materiel Group Selection( Records restrict to 50 with 1 sec) -->Billing date selection for last 10days ( Restriction to 40 Records with 2 Sec)---> Final Result 40 Records with 1+1+2 = 4 Sec

Happening Time of Column Search:

Customer selection(90 Records with 1 Sec) --> Materiel Group Selection( Records restrict to 50 with 1 sec) -->Billing date selection for last 10days ( Restriction to 1000 Records with 10 Sec)---> Final Result 40 Records with 1+1+10 = 12 Sec

So the column search is taking 12 sec to compete the search which is causing issue in run time of the report execution.

Issue: When searching on Date it should filter on input number of records which is 40 but 1000 records coming. Please let me know if any reason behind this behavior.

Thanks in-advance for help.

Regards,

Venkata Mahipathi.

[lbreddemann]

Sorry, but that description is insufficient to make any comment on the matter.

Given that it's usually rather complex to analyse the exact execution characteristics of a query, I recommend opening a support incident if you believe this is a faulty behavior.