How to use Presentation variable in RPD SELECT table type or RDP view or Opaque view

 Sometimes we may need to pass presentation variable value of  Dashboard Prompt to RPD opaque view. But is not possible directly via presentation variable. No worries, it is possible with Request Variable. 

Let us take a scenario, assume that you have created a opaque view in the physical layer of RPD and you need to pass the presentation variable value of Dashboard prompt to the opaque where condition. You can achieve this by following steps. 

1. First, create a session variable (non system session variable) in the RPD, let us say the variable name is From_Date

2. Next, create the dashboard presentation variable with the same name of session variable (From_Date).         (Here the session variable's and presentation variable's are same, when the dashboard user set a value         for  From_Date presentation variable, then that value overwrites the session variable From_Date.)

3. Then use the variable From_Date in the RPD Opaque view's where condition.