Skip to Content
0
Apr 24, 2019 at 11:53 AM

Passing Input Parameter from Table Function based calculation view to graphical calculation view

776 Views Last edit Apr 24, 2019 at 12:27 PM 3 rev

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.

.

inputparam.jpg

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


Attachments

inputparam.jpg (36.1 kB)