im trying to set the select of the sql query of pentaho bi server dynamic but it didn't work here is my code : select SELECT CASE ${param} WHEN 'productLine' THEN productLine WHEN 'productVendor' THEN productVendor ELSE productLine END AS groupByColumn, Sum(quantityInStock) as totalQuantity from products group by productLine this is what i get and here is my param
i tried to change it without params it worked but every time i add param it don't work