Input Parameters in SAP HANA

[former_member205022]

I have following requirement.

I have created Mixed scenario (BW on HANA and Native HANA) as base physical tables are DSO active tables.

I have created 2 scripted calculation views for FIAR and billing data separately. When I am trying to create Input parameter script (Placeholder) it is showing syntax error allowing where condition only. Preview shows correct values for input parameters. pls confirm if the following script is ok.

select Customer, INV_no, INV_itm ... from "SAPHAP"."xxx/"AZFIO0100" ('PLACEHOLDER' = ('$VAR_CUSTOMER$', :VAR_CUSTOMER));

Base table is based on BW DSO Active Table. 2. Graphical calculation views on top of this mapped to base input parameters. But preview is not showing any values for selection. But if I remove Input parameters it is showing result. Can you please let me know if there is any issue in passing parameters to BW on HANA base Active DSO table. Is there any alternate way I can restrict data for any user selected customer value at the base level as there is huge data volume in underlying tables and joins result in dumps. Best Regards