HI I have following Scenario , i have Table Function based Graphical Calculation view(Converted from Script Based Calculation View ) SAY A. This table function internally calls another pure Graphical Calc View SAY B.
I have three Input Parameters passed from this table function based Graphical Calc View A to this Graphical View B.
One is PRODUCTCATEGORY, Second is PLAN_WEEK and third is REGION. All of them are coming from Dimensional Calc View. These are intern passed into B calc views which has similar 3 Inputs but one is InputParam which is PLAN_WEEK and others are Variables, PLAN_WEEK and REGION.
.
When i am trying to open Data Preview Editor of A calc View, i can view these values for corresponding Input Parameters from Dimension Calculation Views. After selecting required input values and submit; i am unable to see the available data. But If i try to run the Calc View A with Generate SQL i get following Syntax rendered in SQL
SELECT *
FROM "_SYS_BIC"."IBP_RAINIER_TEST/A"('PLACEHOLDER' = ('$PRODUCTCATEGORY$', '''<Enter Value>'''), 'PLACEHOLDER' = ('$PLAN_WEEK$', '<Enter Value>'), 'PLACEHOLDER' = ('$REGION$', '''<Enter Value>'''))
When I pass the values with following syntax i can view the result
SELECT *
FROM "_SYS_BIC"."_TEST/A"('PLACEHOLDER' = ('$PRODUCTCATEGORY$', 'SCANNERS'), 'PLACEHOLDER' = ('$PLAN_WEEK$', '2018-W31'), 'PLACEHOLDER' = ('$REGION$', 'AMS'))
But When I pass the values with following syntax i can not view the result, is it possible that the data preview editor might be trying to pass following way to HANA?
SELECT *
FROM "_SYS_BIC"."_TEST/A"('PLACEHOLDER' = ('$PRODUCTCATEGORY$', '''SCANNER'''), 'PLACEHOLDER' = ('$PLAN_WEEK$', '2018-W31'), 'PLACEHOLDER' = ('$REGION$', '''AMS'''))
Can you please help, why the data preview editor doesn't show up result whereas SQL execution with single quote shows.
thanks