I have a manual SQL query that pulls two columns to use on a dashboard. One is a long string created by string addition and it works fine when it's all by itself on the dashboard.
The other is a “posted date” which is a datetime object from the db and I attach a time hierarchy to it in the datacube.
My sql query works fine in both my SQL developer and in the datacube. I do not have any null “posted date” values in any of my data.
I’m trying to attach a calendar range / range date to the posted date and the minute I do I get this error:
ORA-01008: not all variables bound
Normally date filters are super easy. Any ideas why I am getting this error?