title: How to add a presentation variable in the logical sql in obiee 11g
body: <p>I make a dashboardprompt and I want to make a default selection starting from an logical sql. In th options I choose as default selection "SQL Results". In my query I want to put a filter with a presentation variable. I thought to use this query:</p>
  
  <pre><code>SELECT "Human Resources - Talent Profile Management"."Basic Information"."Person Number" 
  FROM "Human Resources - Talent Profile Management"
  WHERE
  ("Position"."Position Identifier" = '@{P_pos_id}{9900574}')
  </code></pre>
  
  <p>But I don't know how to put the presentation variable. Like this code, it does not work. </p>