the DDR is returning general ledger transactions so it won't be static and from my understanding we don't have dataset functionality Might have to go plan Z 😁 I appreciate all your responses Cheers GT

Yes we do have a column in the subject area, but for some reason this column gets truncated in the subject area. The Batch Name in the ebusiness tables is say 100 characters in the column in the subject area it only shows the first 60 characters. That's why I was trying to use the DDR column in dashboard prompt

Hey Chere, when you say presentation columns, do you mean columns in a subject area? Sorry for the dumb question, I haven't used analytics for many years :) Cheers GT

I understand that the SQL statement is wrong in the above screenshot This is what is in the DDR: gl_je_batches glb and glb.name IN ('@{PV_BATCHNAME}{}') I am sure I have done this in OBIEE/OBI previously but that was many many years ago Thanks again for your help!!

Hi All, thanks for your replies!!. This is the error message I am getting in the dashboard prompt: