title: SAP HANA SQL Query with Dynamic Placeholder
body: <p>I have a query that is passing the current year as a placeholder parameter that right now is hard coded. How can I have this just pass the current year? I've seen a few different potential solutions but most of them are in HANA Studio or involve dynamic SQL generation. </p>
  
  <p>I'm putting the SQL into Tableau so those are both off the table. </p>
  
  <pre><code>...sum("StockInQualityInspection") as in_quality,
           sum("StockInTransit") as its
    from "_SYS_BIC"."stream.models.marketing.poly/InventoryQuery" ('PLACEHOLDER' = ('$$IPCurrentYear$$', '2018'))
    where "StockValuatedUnrestrictedUse" &lt;&gt; 0 or "StockInQualityInspection" &lt;&gt; 0 or "StockInTransit" &lt;&gt; 0
    group by case when "ReceivingPlant" is null then "Plant" else "ReceivingPlant" end, 
             case.... 
  </code></pre>