Hi Experts ,
I am bit stuck in specifying placeholders in a graphical calculation view.
I created one graphical calcualtion view which has 2 mandatory input paramters(PLANT & DATE).
SELECT "YYYYMM",
"DebitCreditCode",
sum("AmountInCompanyCodeCurrency") AS "Amount" FROM "_SYS_BIC"."TurnOverValue_BugFix/ABCDEFG_L1"
('PLACEHOLDER' = ('$$PLANT$$', '0001'), 'PLACEHOLDER' = ('$$TO_DATE$$', '201401'))
GROUP BY
"DebitCreditCode",
"YYYYMM";
Here, i need to replace '0001' and '201401' with dynamic values. I tried bot ":variable_name' and "variable_name". Both raise error.
Thanks in advance ,
Sreehari V Pillai