How to pass parameter from data template to bursting query
I am running BI Publisher stand alone 10.1.3.4.2. I need to add a parameter which is defined in my data template to the bursting query. My bursting query is running against an xmltable and I will get "expected singleton sequence" error without adding a where clause. Works great if I hard code the value. When I add "where id = :parm_value", it returns a "Data not defined" error even though parm_value is defined in the data template. Is this possible?