Latest Activity
Hi Denodo Team, Can you help me with this error that i get when i want to deploy the query to the database. The error is "Error loading database " databasename"". any suggestion what to fix in order to work? thank you.
Hi there, I am trying to retrive last business day of last year though this query select dateadd(yy,datediff(yy,-1,@date),-1)[In sql], but in denodo I am not able to find any solution here, so can you please help me out, Thanks,
Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, T...
Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...
Hi Team, Can Denodo support this function, to make the view name case insensitive, eg. I have one exact view like : DERIVED_VIEW_A, and when query the view, I may write the query like: select from "derived_view_a", or select from "Derived_View_a", an...
I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...
Nevermind! Figure out the issue.
I have a view, I need to update columnA with Column B if that columnA as null value , do we have denodo query for it.?
Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.
Hi, We have a report view that is run monthly and is critical from the end user perspective. This view is cached on a regular schedule. When we run the view in vdp and it does not have any functions like current date() or get quarter(), I see that the...