How to get filters and prompts to universe from cal view

[former_member202170]

Hi All,

Recently created some cal view when i am creating universe against  cal view

it is not getting filters and prompts to universe

Please advise How to get filters and prompts to Universe in WEBI

[Former Member]

First check if the filters and prompts are working in HANA studio.

The HANA engine expects to have the input parameters and attribute filter variables passed to the SQL with the following syntax:

SELECT [...]
FROM <viewname> ('PLACEHOLDER' = ('$$<parameter name>$$',<parametervalue>)

WHERE <attribute name>=<filter value>

To provide this kind of query to HANA you can make use of two functionalities of the semantic layer: derived tables and filter objects.

You can generate the PLACEHOLDER syntax with a derived table and you can use a compulsory filter to generate the correct Where statement.

For more detailed info check the below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a20445-6377-2f10-49ab-f6c9565db...

[former_member199842]

Hi Krishna,

Is there an input parameter used in the  calculation view? if  yes, what is the type of input parameter used ?

Is the universe created on a Relational Connection making use of JDBC Driver or ODBC Driver ?

And what is the BIP/ BOE version that is being used ?

Kindly provide the above details to narrow down the issue

Thanks and Regards,

Poorna