Skip to Content
0
Former Member
May 06, 2016 at 10:29 AM

Universe on HANA calculation view with Parameters

466 Views

Hi Everyone,

We are building some reports on a HANA calculation view with parameters. As per the norm I created a derived table with the syntax

SELECT *

FROM "_SYS_BIC"."calculation_view"

(

'PLACEHOLDER'=('$$Z_IP_TARGET_P1$$',@prompt(P1)),

'PLACEHOLDER'=('$$Z_IP_TARGET_P2$$',@prompt(P2))

)

However, I recently read that from BO4.1, there is no need to create a derived table and the prompt can be directly assigned to the parameter. Could anyone please confirm if this is the case or do we need to still need to create a derived table?

Also is there a way to refresh the derived table instead of re creating it each time?

Also, when the query is created, it comes up like

select table1.col1,

table1.col2

from

(

SELECT *

FROM "_SYS_BIC"."calculation_view"

(

'PLACEHOLDER'=('$$Z_IP_TARGET_P1$$',@prompt(P1)),

'PLACEHOLDER'=('$$Z_IP_TARGET_P2$$',@prompt(P2))

) table1

Due to this data from the whole calculation view is processed and then filtered by the select statement. Is there a more efficient way to achieve the same?

Thanks in advance

Vinayak