To default value of month prompt using SQL result
1)I want to default date and month values in their prompts to be used for my dashboard.
Following is my SQL for date:
select CAST(CAST(TIMESTAMPADD(SQL_TSI_DAY,-2,CURRENT_DATE) AS CHAR) AS TIMESTAMP)
FROM "Subject Area".
2) Similarly, I also want to default the value of month for which I have following SQL.
Select Month (TIMESTAMPADD(SQL_TSI_MONTH,-0,TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( TIMESTAMP '@{p_date}' ) * -(1) + 1, TIMESTAMP '@{p_date}'))) from "Subject Area".
Or instead of using TIMESTAMP '@{p_date}' I can also use CURRENT_DATE which also returns the same result.